Computational Statistics

, Volume 29, Issue 5, pp 1095–1128

On the accuracy of statistical procedures in Microsoft Excel 2010

Original Paper

Abstract

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.

Keywords

Statistical function Random number generator Nonlinear regression OpenOffice.org Calc 3.3 Gnumeric 

Supplementary material

180_2014_482_MOESM1_ESM.pdf (217 kb)
Supplementary material 1 (pdf 217 KB)

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  1. 1.Université libre de BruxellesECARES and Solvay Brussels School of Economics and ManagementBrusselsBelgium

Personalised recommendations