Carnegie Mellon University

File(s) stored somewhere else

Please note: Linked content is NOT stored on Carnegie Mellon University and we can't guarantee its availability, quality, security or accept any liability.

Spreadsheet Errors and Decision Making: Evidence from Field Interviews

journal contribution
posted on 2005-09-19, 00:00 authored by Jonathan P. Caulkins, Erika Layne Morrison, Timothy Weidemann
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. We interviewed 45 executives and senior managers/analysts in the private, public, and non-profit sectors 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.