The Detection of Human Spreadsheet Errors by Humans versus Inspection (Auditing) Software
Software Engineering
2010-09-16 v1
Abstract
Previous spreadsheet inspection experiments have had human subjects look for seeded errors in spreadsheets. In this study, subjects attempted to find errors in human-developed spreadsheets to avoid the potential artifacts created by error seeding. Human subject success rates were compared to the successful rates for error-flagging by spreadsheet static analysis tools (SSATs) applied to the same spreadsheets. The human error detection results were comparable to those of studies using error seeding. However, Excel Error Check and Spreadsheet Professional were almost useless for correctly flagging natural (human) errors in this study.
Keywords
Cite
@article{arxiv.1009.2785,
title = {The Detection of Human Spreadsheet Errors by Humans versus Inspection (Auditing) Software},
author = {Salvatore Aurigemma and Raymond R. Panko},
journal= {arXiv preprint arXiv:1009.2785},
year = {2010}
}
Comments
14 Pages, 4 Figures