Reducing Overconfidence in Spreadsheet Development

Abstract

Despite strong evidence of widespread errors, spreadsheet developers rarely subject their spreadsheets to post-development testing to reduce errors. This may be because spreadsheet developers are overconfident in the accuracy of their spreadsheets. This conjecture is plausible because overconfidence is present in a wide variety of human cognitive domains, even among experts. This paper describes two experiments in overconfidence in spreadsheet development. The first is a pilot study to determine the existence of overconfidence. The second tests a manipulation to reduce overconfidence and errors. The manipulation is modestly successful, indicating that overconfidence reduction is a promising avenue to pursue.

Cited by in corpus (12)

• The Importance and Criticality of Spreadsheets in the City of London
• Effect of Range Naming Conventions on Reliability and Development Time for Simple Spreadsheet Formulas
• From Good Practices to Effective Policies for Preventing Errors in Spreadsheets
• Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability
• Exploring Human Factors in Spreadsheet Development
• An approach for the automated risk assessment of structural differences between spreadsheets (DiffXL)
• The Reification of an Incorrect and Inappropriate Spreadsheet Model
• Introducing Morphit, a new type of spreadsheet technology
• Semi-structured data extraction and modelling: the WIA Project
• Defending the future: An MSc module in End User Computing Risk Management
• Concerning the Feasibility of Example-driven Modelling Techniques
• Spreadsheets in Clinical Medicine