首页    期刊浏览 2024年11月27日 星期三
登录注册

文章基本信息

  • 标题:On the Numerical Accuracy of Spreadsheets
  • 本地全文:下载
  • 作者:Marcelo G. Almiron ; Bruno Lopes ; Alyson L. C. Oliveira
  • 期刊名称:Journal of Statistical Software
  • 印刷版ISSN:1548-7660
  • 电子版ISSN:1548-7660
  • 出版年度:2010
  • 卷号:34
  • 期号:4
  • 出版社:University of California, Los Angeles
  • 摘要:

    This paper discusses the numerical precision of five spreadsheets (Calc, Excel, Gnumeric, NeoOffice and Oleo) running on two hardware platforms (i386 and amd64) and on three operating systems (Windows Vista, Ubuntu Intrepid and Mac OS Leopard). The methodology consists of checking the number of correct significant digits returned by each spreadsheet when computing the sample mean, standard deviation, first-order autocorrelation, F statistic in ANOVA tests, linear and nonlinear regression and distribution functions. A discussion about the algorithms for pseudorandom number generation provided by these platforms is also conducted. We conclude that there is no safe choice among the spreadsheets here assessed: they all fail in nonlinear regression and they are not suited for Monte Carlo experiments.

国家哲学社会科学文献中心版权所有