Link to the University of Pittsburgh Homepage
Link to the University Library System Homepage Link to the Contact Us Form

Spreadsheet Presentation and Error Detection: An Experimental Study

Galletta, DF and Hartzel, KS and Johnson, SE and Joseph, JL and Rustagi, S (1996) Spreadsheet Presentation and Error Detection: An Experimental Study. Journal of Management Information Systems, 13 (3). 45 - 63. ISSN 0742-1222

[img] Plain Text (licence)
Available under License : See the attached license file.

Download (1kB)

Abstract

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 2x2 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.".


Share

Citation/Export:
Social Networking:
Share |

Details

Item Type: Article
Status: Published
Creators/Authors:
CreatorsEmailPitt UsernameORCID
Galletta, DFGALLETTA@pitt.eduGALLETTA
Hartzel, KS
Johnson, SE
Joseph, JL
Rustagi, S
Date: 1 January 1996
Date Type: Publication
Access Restriction: No restriction; Release the ETD for access worldwide immediately.
Journal or Publication Title: Journal of Management Information Systems
Volume: 13
Number: 3
Page Range: 45 - 63
DOI or Unique Handle: 10.1080/07421222.1996.11518133
Institution: University of Pittsburgh
Schools and Programs: College of Business Administration > Business Administration
Refereed: Yes
ISSN: 0742-1222
Date Deposited: 04 Sep 2012 21:46
Last Modified: 02 Feb 2019 15:55
URI: http://d-scholarship.pitt.edu/id/eprint/13927

Metrics

Monthly Views for the past 3 years

Plum Analytics

Altmetric.com


Actions (login required)

View Item View Item