• Corpus ID: 18026488

Thinking is Bad: Implications of Human Error Research for Spreadsheet Research and Practice

  title={Thinking is Bad: Implications of Human Error Research for Spreadsheet Research and Practice},
  author={Raymond R. Panko},
  • R. Panko
  • Published 20 January 2008
  • Business
  • ArXiv
In the spreadsheet error community, both academics and practitioners generally have ignored the rich findings produced by a century of human error research. These findings can suggest ways to reduce errors; we can then test these suggestions empirically. In addition, research on human error seems to suggest that several common prescriptions and expectations for reducing errors are likely to be incorrect. Among the key conclusions from human error research are that thinking is bad, that… 

Figures from this paper

Do Spreadsheet Errors Lead to Bad Decisions: Perspectives of Executives and Senior Managers
Executives and senior managers / analysts in the private, public, and non-profit sectors interviewed about their experiences with spreadsheet quality control and with errors affecting decision making believed spreadsheet errors were a significant problem and that more formal spreadsheetquality control could be beneficial.
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.
Empirical study on spreadsheet quality: Case of Serbian SMEs
This paper presents the results of a research which involved analysis of spreadsheets collected from 40 Serbian SMEs. Based on related research, the collected spreadsheets were analysed for presence
Using Bayesian statistical methods to determine the level of error in large spreadsheets.
  • L. Bradley, Kevin McDaid
  • Computer Science
    2009 31st International Conference on Software Engineering - Companion Volume
  • 2009
The research that has been carried out into the use of Bayesian Statistical methods to estimate the level of error in large spreadsheets based on expert knowledge and spreadsheet test data can aid in the decision to accept or re-examine a large time consuming spreadsheet.
Error Estimation in Large Spreadsheets using Bayesian Statistics
Early research that has been carried out into the use of Bayesian Statistical methods to estimate the level of error in large spreadsheets during cell be cell examination based on expert knowledge and partial spreadsheet test data are outlined.
In Pursuit of Spreadsheet Excellence
A simple sampling test - The Clean Sheet Test - which can be used to objectively evaluate if an organisation is in control of the spreadsheets it is using in important processes such as financial reporting.
Controlling End User Computing Applications - a case study
Several workstreams were employed in order to bring about a cultural change within the bank towards the use of spreadsheets and other end-user tools, covering policy development, awareness and skills training, inventory monitoring, user licensing, key risk metrics and mitigation approaches.
On-line support - a virtual treasure trove for end-user developers in small organisations?
In an explorative study it is tried to pinpoint what, if anything, the participants feel about on-line support and if they use it to solve problems.
Requirements for Automated Assessment of Spreadsheet Maintainability
This position paper argues for the need to create a model to estimate the maintainability of a spreadsheet based on (automated) measurement and proposes the creation of a curated, community-contributed repository of spreadsheets.
Qualitative Deviation Models for Spreadsheet Debugging
  • Birgit Hofer, I. Nica, F. Wotawa
  • Computer Science
    2017 IEEE International Symposium on Software Reliability Engineering Workshops (ISSREW)
  • 2017
A new improved model that makes use of the deviations obtained between the expected value of cells and the actual ones is introduced that allows interactive debugging for spreadsheets.


Spreadsheet Presentation and Error Detection: An Experimental Study
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
Spreadsheets and Sarbanes-Oxley: Regulations, Risks, and Control Frameworks
  • R. Panko
  • Economics
    Commun. Assoc. Inf. Syst.
  • 2006
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.
Recommended Practices for Spreadsheet Testing
This paper presents the authors recommended practices for spreadsheet testing, and logic inspection appears to be feasible for spreadsheet developers to do and safe and effective for module testing.
Applying Code Inspection to Spreadsheet Testing
  • R. Panko
  • Business
    J. Manag. Inf. Syst.
  • 1999
Findings were that subjects were overconfident when inspecting alone, that certain types of errors are especially difficult to detect, and that the benefits of the group phase is greatest for these difficult-to-detect type of errors.
Error Detection Processes in Statistical Problem Solving
Good problemsolvers detected a higher proportion of their errors compared to poor problem solvers, probably due to differences in the processes leading up to the triggering of an evaluative episode rather than to differences after the episode had been triggered.
Mental procedures in real-life tasks: a case study of electronic trouble shooting.
The mental procedures used by skilled electronics repair men in their normal working environment have been studied by analysis of verbal protocols and demonstrate a great ability by the men to conduct the search by general routines mostly depending upon their general professional background.
Two models of group behavior in the solution of eureka-type problems
A study by Shaw (7) some twenty years ago is frequently cited by social scientists to support the generalization that groups are superior to individuals in problem-solving. Shaw suggests that
Categorization of action slips.
A slip is the error that occurs when a person does an action that is not intended. In this article I examine several collections of slips, primarily of actions, with the aim of devising a theoretical
Does spell-checking software need a warning label?
Users---ironically, often those most verbally armed---put too much trust and little effort in questioning spell- and grammar-checking programs.