Spreadsheet Errors and Decision Making:
There is consensus in the literature that spreadsheets are both ubiquitous and error-prone, but little direct evidence concerning whether spreadsheet errors frequently lead to bad decision making. As part of research, 45 executives and senior managers/analysts in the private, public, and non-profit sectors were interviewed about their experiences with spreadsheet errors and quality control procedures. Differences across sectors do not seem pronounced. Almost all respondents report that spreadsheet errors are common. Most can report instances in which the errors directly led to losses or bad decisions, but opinions differ as to whether the consequences of spreadsheet errors are severe. Error checking and quality control procedures are in most cases informal. A significant minority of respondents believe such ad hoc processes are sufficient because the "human in the loop" can detect any gross errors. Others thought more formal spreadsheet quality control processes could be beneficial.
Publication Year: 2005
Type: Working Paper
Working Paper Number: 19
- View Full Text (.pdf)
Adobe .pdf files require the Adobe Acrobat Reader.
Download and install the Adobe Acrobat Reader.