On the accuracy of statistical procedures in Microsoft Excel 2010

被引:0
|
作者
Guy Mélard
机构
[1] ECARES and Solvay Brussels School of Economics and Management,Université libre de Bruxelles
来源
Computational Statistics | 2014年 / 29卷
关键词
Statistical function; Random number generator; Nonlinear regression; OpenOffice.org Calc 3.3; Gnumeric;
D O I
暂无
中图分类号
学科分类号
摘要
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
页数:33
相关论文
共 6 条
  • [1] On the accuracy of statistical procedures in Microsoft Excel 2010
    Melard, Guy
    COMPUTATIONAL STATISTICS, 2014, 29 (05) : 1095 - 1128
  • [2] A NONLINEAR FITTING PROGRAM IN PHARMACOKINETICS WITH MICROSOFT(R) EXCEL SPREADSHEET
    DELBOY, H
    INTERNATIONAL JOURNAL OF BIO-MEDICAL COMPUTING, 1994, 37 (01): : 1 - 14
  • [3] Fitting net photosynthetic light-response curves with Microsoft Excel - a critical look at the models
    Lobo, F. de A.
    de Barros, M. P.
    Dalmagro, H. J.
    Dalmolin, A. C.
    Pereira, W. E.
    de Souza, E. C.
    Vourlitis, G. L.
    Rodriguez Ortiz, C. E.
    PHOTOSYNTHETICA, 2013, 51 (03) : 445 - 456
  • [4] A Self-Directed Workshop for Developing Advanced Data Processing and Analysis Skills in Chemistry Using Microsoft Excel
    Campbell, Craig D.
    Smallwood, Zoe M.
    Stewart, Malcolm, I
    JOURNAL OF CHEMICAL EDUCATION, 2020, 97 (09) : 2635 - 2642
  • [5] A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet
    Brown, AM
    COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2001, 65 (03) : 191 - 200
  • [6] Utilization of integrated Michaelis-Menten equations for enzyme inhibition diagnosis and determination of kinetic constants using Solver supplement of Microsoft Office Excel
    Bezerra, Rui M. F.
    Fraga, Irene
    Dias, Albino A.
    COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2013, 109 (01) : 26 - 31