A Novel Approach to Formulae Production and Overconfidence Measurement to Reduce Risk in Spreadsheet Modelling

Simple item page
dc.creatorThorne, Simon
dc.creatorBall, David
dc.creatorLawson, Zoe
dc.date2008-03-12
dc.date.accessioned2026-07-07T09:26:24Z
dc.date.available2026-07-07T09:26:24Z
dc.descriptionResearch on formulae production in spreadsheets has established the practice as high risk yet unrecognised as such by industry. There are numerous software applications that are designed to audit formulae and find errors. However these are all post creation, designed to catch errors before the spreadsheet is deployed. As a general conclusion from EuSpRIG 2003 conference it was decided that the time has come to attempt novel solutions based on an understanding of human factors. Hence in this paper we examine one such possibility namely a novel example driven modelling approach. We discuss a control experiment that compares example driven modelling against traditional approaches over several progressively more difficult tests. The results are very interesting and certainly point to the value of further investigation of the example driven potential. Lastly we propose a method for statistically analysing the problem of overconfidence in spreadsheet modellers.
dc.description12 pages, 7 figures
dc.identifierhttps://arxiv.org/abs/0803.1754
dc.identifierhttp://arxiv.org/abs/0803.1754
dc.identifierProc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2004 71-83 ISBN 1 902724 94 1
dc.identifier.urihttp://salesiana.dossiersoluciones.com/handle/123456789/156737
dc.subjectHuman-Computer Interaction
dc.subjectComputers and Society
dc.subjectD.1.7; D.2.1; D.2.11; D.3.2; D.3.3; H.4.1; K.6.4; K.8.1
dc.titleA Novel Approach to Formulae Production and Overconfidence Measurement to Reduce Risk in Spreadsheet Modelling
dc.typetext

Files

Collections

arXiv