An experimental study of spreadsheet presentation and error detection
- 1 January 1996
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- Vol. 2, 336-345 vol.2
- https://doi.org/10.1109/hicss.1996.495417
Abstract
Several well-founded concerns exist about the integrity and validity of electronic spreadsheets. One hundred thirteen MBA students sought eight errors planted in a single-page spreadsheet to discover if differences in the presentation format would facilitate error-finding performance. Five presentation formats were used. Spreadsheets were presented on the screen, both with and without formulas. Spreadsheets were also presented on paper with a list of formulas attached or without formulas. A new integrated formula paper treatment was introduced with formulas presented in each cell directly under each calculated value. Subjects found, on average, only about 50% of the errors across all presentation formats. The on-screen treatments were clearly inferior to the paper treatments, whether or not formulas were presented. Practitioners should be aware of the difficulties in finding even simple errors, especially on-screen, and should develop training programs to facilitate spreadsheet auditors' performance.Keywords
This publication has 20 references indexed in Scilit:
- Tools for spreadsheet auditingInternational Journal of Human-Computer Studies, 1996
- Spreadsheets on trial: a survey of research on spreadsheet risksPublished by Institute of Electrical and Electronics Engineers (IEEE) ,1996
- An empirical study of spreadsheet error-finding performanceAccounting, Management and Information Technologies, 1993
- Reading from paper versus screens: a critical review of the empirical literatureErgonomics, 1992
- A model of end-user computing policy: Context, process, content and complianceInformation & Management, 1992
- A Role Theory Perspective on End-User DevelopmentInformation Systems Research, 1990
- Analysis of the Cognition Involved in Spreadsheet Software InteractionHuman–Computer Interaction, 1987
- Reading from CRT Displays Can Be as Fast as Reading from PaperHuman Factors: The Journal of the Human Factors and Ergonomics Society, 1987
- Reading Is Slower from CRT Displays than from Paper: Attempts to Isolate a Single-Variable ExplanationHuman Factors: The Journal of the Human Factors and Ergonomics Society, 1987
- The management of end user computingCommunications of the ACM, 1983