arXivDaily arXiv每日学术速递 周一至周五更新
北美退伍军人节(Veterans Day),12 日无更新
arXiv 0908.1190cs.SEcs.HC
收藏

基于贝叶斯统计的大型电子表格误差估计

Error Estimation in Large Spreadsheets using Bayesian Statistics

Leslie Bradley, Kevin McDaid

摘要:

电子表格在商业中无处不在,金融部门尤其严重依赖这项技术。众所周知,电子表格错误的级别可能很高,并且通常需要基于结构化方法来检查电子表格,该结构化方法包括电子表格的逐个单元检查。本文概述了早期的研究,已进行到使用贝叶斯统计方法来估计在大型电子表格中的错误水平,在电池单元检查的基础上,专家知识和部分电子表格测试数据。评估可以帮助决定电子表格的质量以及是否需要进行进一步测试。

英文摘要:

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 be cell examination based on expert knowledge and partial spreadsheet test data. The estimate can aid in the decision as to the quality of the spreadsheet and the necessity to conduct further testing or not.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑