An Empirical Study of End-User Behaviour in Spreadsheet Error Detection & Correction

Simple item page
dc.creatorBishop, Brian
dc.creatorMcDaid, Kevin
dc.date2008-02-24
dc.date.accessioned2026-07-07T09:25:31Z
dc.date.available2026-07-07T09:25:31Z
dc.descriptionVery little is known about the process by which end-user developers detect and correct spreadsheet errors. Any research pertaining to the development of spreadsheet testing methodologies or auditing tools would benefit from information on how end-users perform the debugging process in practice. Thirteen industry-based professionals and thirty-four accounting & finance students took part in a current ongoing experiment designed to record and analyse end-user behaviour in spreadsheet error detection and correction. Professionals significantly outperformed students in correcting certain error types. Time-based cell activity analysis showed that a strong correlation exists between the percentage of cells inspected and the number of errors corrected. The cell activity data was gathered through a purpose written VBA Excel plug-in that records the time and detail of all cell selection and cell change actions of individuals.
dc.description12 Pages, 3 Figures
dc.identifierhttps://arxiv.org/abs/0802.3479
dc.identifierhttp://arxiv.org/abs/0802.3479
dc.identifierProc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2007 165-176 ISBN 978-905617-58-6
dc.identifier.urihttp://salesiana.dossiersoluciones.com/handle/123456789/156434
dc.subjectHuman-Computer Interaction
dc.subjectComputers and Society
dc.subjectD.2.4; D.2.5; H.4.1; K.6.4; K.8.1
dc.titleAn Empirical Study of End-User Behaviour in Spreadsheet Error Detection & Correction
dc.typetext

Files

Collections

arXiv