• Corpus ID: 7664795

Error Estimation in Large Spreadsheets using Bayesian Statistics

@article{Bradley2009ErrorEI,
  title={Error Estimation in Large Spreadsheets using Bayesian Statistics},
  author={Leslie Bradley and Kevin McDaid},
  journal={ArXiv},
  year={2009},
  volume={abs/0908.1190}
}
Spreadsheets are ubiquitous in business with the financial sector particularly heavily reliant on the technology. It is known that the level of spreadsheet error can be high and that it is often necessary to review spreadsheets based on a structured methodology which includes a cell by cell examination of the spreadsheet. This paper outlines the 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… 

Figures and Tables from this paper

References

SHOWING 1-10 OF 23 REFERENCES
Errors in Operational Spreadsheets
TLDR
This research addresses three questions about errors in operational spreadsheets: what is the aver age cell error rate, how does it differ among spreadsheets, and what types of errors are most prevalent.
An auditing protocol for spreadsheet models
A Typical Model Audit Approach: Spreadsheet Audit Methodologies in the City of London
TLDR
It is noteworthy that in the United Kingdom, the management of spreadsheet error is almost unheard of outside of the City of London despite the commercial ubiquity of the spreadsheet.
Impact of errors in operational spreadsheets
The Importance and Criticality of Spreadsheets in the City of London
TLDR
The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.
REDUCING SPREADSHEET ERROR RATES
TLDR
This study looks at the impact of spreadsheet training that includes emphasis on spreadsheet errors and their consequences in reducing spreadsheet error rates and indicates that more knowledge of the problem domain is associated with fewer spreadsheet errors.
Spreadsheets on trial: a survey of research on spreadsheet risks
  • R. Panko, R. Halverson
  • Economics
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
The paper presents a framework for risks in spreadsheeting and organizes selected research findings in terms of this framework.
What we know about spreadsheet errors
TLDR
Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications, and error rates are in line with those in programming and other human cognitive domains.
Spreadsheet Errors: What We Know. What We Think We Can Do
TLDR
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and the degree to which other techniques can reduce spreadsheet errors needs to be determined.
Gaining Confidence in Software Inspection Using a Bayesian Belief Model
TLDR
How confidence in a software inspection can be obtained through calculating an estimate of its effectiveness is described, which provides answers to some of the questions and limitations raised by current models used to predict inspection effectiveness.
...
...