The Cognitive Science of Spreadsheet Errors: Why Thinking is Bad

@article{Panko2013TheCS,
  title={The Cognitive Science of Spreadsheet Errors: Why Thinking is Bad},
  author={Raymond R. Panko},
  journal={2013 46th Hawaii International Conference on System Sciences},
  year={2013},
  pages={4013-4022}
}
  • R. Panko
  • Published 7 January 2013
  • Biology
  • 2013 46th Hawaii International Conference on System Sciences
Research has long shown that spreadsheet developers are 96% to 99% accurate when they enter information into spreadsheet cells. For large spreadsheets, unfortunately, a cell error rate of 1% to 6% will almost certainly lead to incorrect results. Can cell error rates (CERs) really be this high? General human error research has shown that when humans do simple but nontrivial cognitive tasks, they inevitably have comparable error rates. The problem is that human cognitive mechanisms have evolved… 

Figures and Tables from this paper

What We Don't Know About Spreadsheet Errors Today: The Facts, Why We Don't Believe Them, and What We Need to Do
TLDR
This paper argues that any prescription for reducing errors that has not been rigorously proven safe and effective should be rejected, and suggests that the code inspection methodology developed in software development is likely to apply very well to spreadsheet inspection.
Are We Overconfident in Our Understanding of Overconfidence ?
In spreadsheet error research, there is a Grand Paradox. Although many studies have looked at spreadsheet errors, and have found, without exception, has error rates that are unacceptable in
Teaching methods are erroneous: approaches which lead to erroneous end-user computing
TLDR
Teachers should believe in the incremental nature of science and have high self-efficacy to make students understand and appreciate science, and it is high time fundamental changes were introduced.
Beyond the mechanics of spreadsheets: using design instruction to address spreadsheet errors
TLDR
A three-step approach for introducing spreadsheet design practices to novice spreadsheet developers is outlined and a summary of foundational readings related to spreadsheet errors as well as specific teaching strategies for addressing the most common spreadsheet errors identified in the literature are provided.
Thinking Fast and Slow in Computer Problem Solving
TLDR
The results of the analyses of teaching materials collected in different languages from all over the world are presented, considering the different problem solving approaches, set in the frame of different thinking modes, the characteristics of expert teachers, and the meaning system model of teaching approaches.
Evaluating the Effectiveness of Static Analysis Programs Versus Manual Inspection in the Detection of Natural Spreadsheet Errors
TLDR
The results showed that while manual human inspection results for this study were consistent with previous research in the field, the performance of the static analysis programs at detecting natural errors was very poor for every category of spreadsheet errors.
IMPROVEMENT OF SPREADSHEET SKILLS IN BUSINESS- ORIENTED UNIVERSITY COURSES
TLDR
Based on a selection of current best practices, this paper presents several proposals for updating/innovating courses related to spreadsheet development, and suggests that spreadsheet error prevention and reduction techniques are used rarely.
The Comparison of Students’ Self-Assessment, Gender, and Programming-Oriented Spreadsheet Skills
Previous research proved that teaching spreadsheeting from a programming perspective is much more effective than the widely accepted tool-centered surface approach methods. Spreadsheeting as an
Sprego, End-user Programming in Spreadsheets
TLDR
The essence of Sprego programming is provided, which is a high mathability, computer-supported real world problem solving approach in spreadsheet environments, along with its theoretical background and tools, and it is found and proved that it supports knowledge transfer between the subfields of computers sciences and other traditional sciences.
...
...

References

SHOWING 1-10 OF 44 REFERENCES
A critical review of the literature on spreadsheet errors
The Many Uses of Error
TLDR
This chapter focuses on the case of inadvertent slips, which may be defined as actions that reveal a mismatch between a reportable intention and overt performance.
Individual differences in reasoning: implications for the rationality debate?
TLDR
In a series of experiments involving most of the classic tasks in the heuristics and biases literature, the implications of individual differences in performance for each of the four explanations of the normative/descriptive gap are examined.
The Invisible Gorilla: And Other Ways Our Intuitions Deceive Us
The Invisible Gorilla: And Other Ways Our Intuitions Deceive Us Christopher Chabris and Daniel Simons Crown Publishers, 2010 A fool learns from his mistakes, but a wise person learns from the
Spreadsheets and Sarbanes-Oxley: Regulations, Risks, and Control Frameworks
  • R. Panko
  • Economics
    Commun. Assoc. Inf. Syst.
  • 2006
TLDR
This paper examines spreadsheet risks for Sarbanes-Oxley (and other regulations) and discusses how general and IT-specific control frameworks can be used to address the control risks created by spreadsheets.
How Spreadsheets Get Us to Mars and Beyond
TLDR
This paper will share the lessons learned in building various spreadsheet intensive systems and applications, and propose a number of exploratory ideas as to the dimensions of spreadsheet system complexity.
Spreadsheets in Financial Departments: An Automated Analysis of 65,000 Spreadsheets using the Luminous Technology
TLDR
An analysis of 65,000 spreadsheets for the financial departments of both a government and a private commercial organisation provides important insight into the nature and structure of these spreadsheets, the links between them, the existence and nature of macros and the level of repetitive processes performed through the spreadsheets.
A New Ideomotor Theory of Voluntary Control
A century ago, psychology was defined as the study of three core topics: conation (i. e., volition or will), cognition, and emotion (Hilgard, 1980). But since the advent of behaviorism and logical
End User Computing: The Dark Matter (and Dark Energy) of Corporate IT
  • R. Panko, D. Port
  • Computer Science
    2012 45th Hawaii International Conference on System Sciences
  • 2012
TLDR
It is time to stop ignoring end user computing in general and spreadsheets in particular and only talk about development, regardless of whether the developer user a 3GL or 4GL.
...
...