Implications of data quality for spreadsheet analysis
ACM SIGMIS Database
An experimental study of people creating spreadsheets
ACM Transactions on Information Systems (TOIS)
Spreadsheets can be hazardous to your health
Personal Computing
Expansion and control of end-user computing
Journal of Management Information Systems
Strategies for end-user computing: An integrative framework
Journal of Management Information Systems
Journal of Accountancy
A model of end-user computing policy: Context, process, content and compliance
Information and Management
International Journal of Human-Computer Studies
The management of end user computing
Communications of the ACM
A controlled experiment in program testing and code walkthroughs/inspections
Communications of the ACM
The Psychology of Human-Computer Interaction
The Psychology of Human-Computer Interaction
An Experimental Study of Spreadsheet Presentation and Error Detection
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
Factors Influencing Risks and Outcomes in End-User Development
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
Spreadsheets on Trial: A Survey of Research on Spreadsheet Risks
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
Hitting the Wall: Errors in Developing and Debugging a "Simple" Spreadsheet Model
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
A Risk and Control Oriented Study of the Practices of Spreadsheet Application Developers
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
An investigation of the information center from the user's perspective
ACM SIGMIS Database
Influencing the success of spreadsheet development by novice users
ICIS '98 Proceedings of the international conference on Information systems
A graphical approach for reducing spreadsheet linking errors
Advanced topics in end user computing
Advanced topics in end user computing
Applying code inspection to spreadsheet testing
Journal of Management Information Systems - Special section: Strategic and competitive information systems
An auditing protocol for spreadsheet models
Information and Management
A critical review of the literature on spreadsheet errors
Decision Support Systems
Revising the Panko-Halverson taxonomy of spreadsheet errors
Decision Support Systems
Reliability, mindfulness, and information systems
MIS Quarterly
Education and Information Technologies
A web-centred approach to end-user software engineering
ACM Transactions on Software Engineering and Methodology (TOSEM) - Testing, debugging, and error handling, formal methods, lifecycle concerns, evolution and maintenance
Hi-index | 0.00 |
The pervasiveness and impact of electronic spreadsheets have generated serious concerns about their integrity and validity when used in significant decision-making settings. Previous studies have shown that few of the errors that might exist in any given spreadsheet are found, even when the reviewer is explicitly looking for errors. It was hypothesized that differences in the spreadsheets' presentation and their formulas could affect the detection rate of these errors. A sample of 113 M.B.A. students volunteered to search for eight errors planted in a one-page spreadsheet. The spreadsheet was presented in five different formats. A 2 × 2 design specified that four groups were given apparently conventional spreadsheets for comparing paper and screen and the presence or absence of formulas. A fifth group received a special printed spreadsheet with formulas visibly integrated into the spreadsheet-printed in a small font directly under the resultant values. As in previous studies, only about 50 percent of the errors were found overall. Subjects with printed spreadsheets found more errors than their colleagues with screen-only spreadsheets but they took longer to do so. There was no discernible formula effect; subjects who were able to refer to formulas did not outperform subjects with access to only the final numbers. The special format did not facilitate error finding. Exploratory analysis uncovered some interesting results. The special experimental integrated paper format appeared to diminish the number of correct items falsely identified as errors. There also seemed to be differences in performance that were accounted for by the subjects' self-reported error-finding strategy. Researchers should focus on other factors that might facilitate error finding, and practitioners should be cautious about relying on spreadsheets' accuracy, even those that have been "audited."