On the accuracy of statistical procedures in Microsoft Excel 2010

被引:43
|
作者
Melard, Guy [1 ,2 ]
机构
[1] Univ Libre Bruxelles, ECARES, B-1050 Brussels, Belgium
[2] Solvay Brussels Sch Econ & Management, B-1050 Brussels, Belgium
关键词
Statistical function; Random number generator; Nonlinear regression; OpenOffice.org Calc 3.3; Gnumeric; DISTRIBUTIONS; RELIABILITY; SOFTWARE;
D O I
10.1007/s00180-014-0482-5
中图分类号
O21 [概率论与数理统计]; C8 [统计学];
学科分类号
020208 ; 070103 ; 0714 ;
摘要
All previous versions of Microsoft Excel until Excel 2007 have been criticized by statisticians for several reasons, including the accuracy of statistical functions, the properties of the random number generator, the quality of statistical add-ins, the weakness of the Solver for nonlinear regression, and the data graphical representation. Until recently Microsoft did not make an attempt to fix all the errors in Excel and was still marketing a product that contained known errors. We provide an update of these studies given the recent release of Excel 2010 and we have added OpenOffice.org Calc 3.3 and Gnumeric 1.10.16 to the analysis, for the purpose of comparison. The conclusion is that the stream of papers, mainly in Computational Statistics and Data Analysis, has started to pay off: Microsoft has partially improved the statistical aspects of Excel, essentially the statistical functions and the random number generator.
引用
收藏
页码:1095 / 1128
页数:34
相关论文
共 45 条
  • [1] On the accuracy of statistical procedures in Microsoft Excel 2010
    Guy Mélard
    Computational Statistics, 2014, 29 : 1095 - 1128
  • [2] On the accuracy of statistical procedures in Microsoft Excel 2003
    McCullough, BD
    Wilson, B
    COMPUTATIONAL STATISTICS & DATA ANALYSIS, 2005, 49 (04) : 1244 - 1252
  • [3] Microsoft Excel: a tool for research
    Perez Gonzalez, Luis Orlando
    MEDISUR-REVISTA DE CIENCIAS MEDICAS DE CIENFUEGOS, 2006, 4 (03): : 68 - 71
  • [4] Design and use of the Microsoft Excel Solver
    Fylstra, D
    Lasdon, L
    Watson, J
    Waren, A
    INTERFACES, 1998, 28 (05) : 29 - 55
  • [5] Creating single-subject design graphs with Microsoft Excel™
    Carr, JE
    Burkholder, EO
    JOURNAL OF APPLIED BEHAVIOR ANALYSIS, 1998, 31 (02) : 245 - 251
  • [6] Analyzing Drop Jump Ground Reaction Forces in Microsoft Excel
    Pedley, Jason S.
    Radnor, John M.
    Lloyd, Rhodri S.
    Oliver, Jon L.
    STRENGTH AND CONDITIONING JOURNAL, 2023, 45 (06) : 683 - 697
  • [7] A NONLINEAR FITTING PROGRAM IN PHARMACOKINETICS WITH MICROSOFT(R) EXCEL SPREADSHEET
    DELBOY, H
    INTERNATIONAL JOURNAL OF BIO-MEDICAL COMPUTING, 1994, 37 (01): : 1 - 14
  • [8] Statistical Accuracy of Spreadsheet Software
    Keeling, Kellie B.
    Pavur, Robert J.
    AMERICAN STATISTICIAN, 2011, 65 (04) : 265 - 273
  • [9] Microsoft Power BI: Extending Excel to Manipulate, Analyze, and Visualize Diverse Data
    Becker, Louis T.
    SERIALS REVIEW, 2019, 45 (03) : 184 - 188
  • [10] Statistical Accuracy of iPad Applications: An Initial Examination
    Lomax, Richard G.
    AMERICAN STATISTICIAN, 2013, 67 (02) : 105 - 108