On the accuracy of statistical procedures in Microsoft Excel 2010

被引：45

作者：

Melard, Guy ^{[1
,2
]}

机构：

[1] Univ Libre Bruxelles, ECARES, B-1050 Brussels, Belgium

[2] Solvay Brussels Sch Econ & Management, B-1050 Brussels, Belgium

来源：

COMPUTATIONAL STATISTICS | 2014年 / 29卷 / 05期

关键词：

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

共 47 条

[21] eeFit: a Microsoft Excel-embedded program for interactive analysis and fitting of experimental dose-response data [J].

Vivaudou, Michel .

BIOTECHNIQUES, 2019, 66 (04) :186-193

[22] Quantitative thermodynamic predication of interactions between nucleic acid and non-nucleic acid species using Microsoft excel [J].

Zou, Jiaqi ;

Li, Na .

COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2013, 111 (03) :755-762

[23] A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet [J].

Brown, AM .

COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2001, 65 (03) :191-200

[24] A microsoft-excel-based tool for running and critically appraising network meta-analyses-an overview and application of NetMetaXL [J].

Brown S. ;

Hutton B. ;

Clifford T. ;

Coyle D. ;

Grima D. ;

Wells G. ;

Cameron C. .

Systematic Reviews, 3 (1)

[25] An appraisal of statistical procedures used in derivation of reference intervals [J].

Ichihara, Kiyoshi ;

Boyd, James C. .

CLINICAL CHEMISTRY AND LABORATORY MEDICINE, 2010, 48 (11) :1537-1551

[26] Statistical criteria for parallel tests: A comparison of accuracy and power [J].

Miguel A. García-Pérez .

Behavior Research Methods, 2013, 45 :999-1010

[27] Statistical criteria for parallel tests: A comparison of accuracy and power [J].

Garcia-Perez, Miguel A. .

BEHAVIOR RESEARCH METHODS, 2013, 45 (04) :999-1010

[28] Circular data in biology: advice for effectively implementing statistical procedures [J].

Landler, Lukas ;

Ruxton, Graeme D. ;

Malkemper, E. Pascal .

BEHAVIORAL ECOLOGY AND SOCIOBIOLOGY, 2018, 72 (08)

[29] Utilization of integrated Michaelis-Menten equations for enzyme inhibition diagnosis and determination of kinetic constants using Solver supplement of Microsoft Office Excel [J].

Bezerra, Rui M. F. ;

Fraga, Irene ;

Dias, Albino A. .

COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2013, 109 (01) :26-31

[30] Statistical methods to assess the reliability of measurements in the procedures for forensic age estimation [J].

Ferrante, L. ;

Cameriere, R. .

INTERNATIONAL JOURNAL OF LEGAL MEDICINE, 2009, 123 (04) :277-283

← 1 2 3 4 5 →