# On the accuracy of statistical procedures in Microsoft Excel 2010

@article{Mlard2014OnTA, title={On the accuracy of statistical procedures in Microsoft Excel 2010}, author={Guy M{\'e}lard}, journal={Computational Statistics}, year={2014}, volume={29}, pages={1095-1128} }

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…

## Figures, Tables, and Topics from this paper

## 53 Citations

Microsoft EXCEL 2010 offers an improved random number generator allowing efficient simulation in chemical laboratory studies.

- Computer Science, MedicineClinica chimica acta; international journal of clinical chemistry
- 2015

One of the features of the new versions of EXCEL is a much improved pseudorandomnumber generator (PRNG) and the feasibility of its practical use in the clinical laboratory is tested.

Assessing Excel VBA Suitability for Monte Carlo Simulation

- Computer Science, MathematicsArXiv
- 2015

The results of the study indicate that Microsoft Excel (versions 2010 and 2013) is a strong Monte Carlo simulation application offering a solid framework of core simulation components including spreadsheets for data input and output, VBA development environment and summary statistics functions.

On the Examination of the Reliability of Statistical Software for Estimating Logistic Regression Models

- Computer Science
- 2015

This study followed the National Institute of Standards and Technology procedures when they generated certified values of parameter estimates and standard errors for the nonlinear logistic regression models used.

On the accuracy of linear regression routines in some data mining packages

- Computer ScienceWIREs Data Mining Knowl. Discov.
- 2019

The National Institute of Standards and Technology Statistical Reference Datasets tests for the numerical accuracy of statistical packages to 7 data mining packages find that one package has an unstable algorithm for the calculation of the sample variance and only two have reliable linear regression routines.

Excel-lence in Data Visualization?: The Use of Microsoft Excel for Data Visualization and the Analysis of Big Data

- Computer Science
- 2017

This chapter plots the historical development of spreadsheets in general, and Excel in particular, highlighting how new features have allowed for new forms of data analysis in the spreadsheet environment.

Inaccurate regression coefficients in Microsoft Excel 2003: an investigation of Volpi’s “zero bug”

- Computer ScienceComput. Stat.
- 2017

This so-called “zero bug” of the linear regression function LINEST(), is investigated, and it is found that the inaccuracy is caused by a non-standard modified back-substitution procedure.

Excel Templates: A Helpful Tool for Teaching Statistics

- Computer Science
- 2017

A free, open-source collection of templates for the popular Excel (2013, and later versions) spreadsheet program that allow easy and intuitive learning and the implementation of practical examples concerning descriptive statistics, random variables, confidence intervals, and hypothesis testing.

Simple Statistical Tests and P Values

- Computer ScienceEvidence-Based Surgery
- 2019

The goal of this chapter is to describe common statistical principles in English, leaving the mathematical symbolism to a minimum, and to introduce readers to common statistical ideas including chi-square tests, Student’s t test, Fisher exact tests, and sensitivity analysis.

Resampling methods in Microsoft Excel® for estimating reference intervals

- Computer Science, MedicineBiochemia medica
- 2015

The purpose of this paper is to introduce the reader to resampling estimation techniques in general and in using Microsoft Excel® 2010 for the purpose of estimating reference intervals in particular.

Methodological Expectations for Studies Using Computer Simulation

- Business
- 2016

Simulation is often used in papers and studies across diverse fields like logistics, supply chains, health care, manufacturing, and defense. But simulations must be properly done, including input and…

## References

SHOWING 1-10 OF 65 REFERENCES

On the accuracy of statistical procedures in Microsoft Excel 2007

- Computer ScienceComput. Stat. Data Anal.
- 2008

No statistical procedure in Excel should be used until Microsoft documents that the procedure is correct; it is not safe to assume that Microsoft Excel’s statistical procedures give the correct answer.

The accuracy of statistical distributions in Microsoft® Excel 2007

- Mathematics, Computer ScienceComput. Stat. Data Anal.
- 2008

It is found that the accuracy of various statistical functions in Excel 2007 range from unacceptably bad to acceptable but significantly inferior in comparison to alternative implementations.

Statistical Accuracy of Spreadsheet Software

- Computer Science
- 2011

The results suggest that Gnumeric is the most reliable both in performing statistical analysis and for calculations involving statistical distributions, while Google Docs spreadsheet, while convenient, has deficiencies and should not be used for scientific statistical analysis.

On the accuracy of statistical procedures in Microsoft Excel 2003

- Mathematics
- 1999

Excel 2007, like its predecessors, fails a standard set of intermediate-level accuracy tests in three areas: statistical distributions, random number generation, and estimation. Additional errors in…

On the accuracy of statistical procedures in microsoft Excel 2000 and Excel XP

- Computer Science
- 2002

The problems that rendered Excel 97 unfit for use as a statistical package have not been fixed in either Excel 2000 or Excel 2002 (also called "Excel XP"). Microsoft attempted to fix errors in the…

Polynomial Trendline function flaws in Microsoft Excel

- Mathematics, Computer ScienceComput. Stat. Data Anal.
- 2010

This work reports newly discovered problems with Excel 2007 when generating polynomial trend line equations, having a user-specified (forced) intercept, from graphed data.

On the Numerical Accuracy of Spreadsheets

- Computer Science
- 2010

It is concluded 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.

Nonstandard operator precedence in Excel

- Mathematics, Computer ScienceComput. Stat. Data Anal.
- 2007

In this note the operator precedence in Excel is explained, the previous nonlinear regression results are corrected, and a simple example of maximum likelihood estimation is given.

On the accuracy of statistical distributions in Microsoft Excel 2003

- 1998

Some of previously indicated errors in Microsoft Excel 97 and Excel XP have been eliminated in Excel 2003. But some others have not been corrected in Excel 2003 and new ones have been found as is…

Assessing the Reliability of Statistical Software: Part I

- Mathematics
- 1998

Abstract Entry-level tests of the accuracy of statistical software, such as Wilkinson's Statistics Quiz, have long been available, but more advanced collections of tests have not. This article…