i-nth logo

Authors

Harry Howe & Mark G. Simkin

Abstract

The extensive computational and formatting capabilities of today's spreadsheets enable users to create sophisticated analytical models with professionally formatted outputs. But good-looking reports can mask a host of input errors, formula mistakes, and computational problems.

This article examines the subject of spreadsheet error detection in detail and describes an experiment designed to identify those factors influencing the error-detection capabilities of a sample of spreadsheet users.

Sample

Number of errors detected
Number of errors detected

The results suggest a fairly uniform distribution of student ability to detect errors, with the exception of a few subjects who performed quite poorly or quite well.

Publication

2006, Decision Sciences Journal of Innovative Education, Volume 4, Number 1, January, pages 101-122

Full article

Factors affecting the ability to detect spreadsheet errors