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}
}
  • G. Mélard
  • Published 1 October 2014
  • Computer Science
  • Computational Statistics
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… 
View on Springer
dipot.ulb.ac.be
53 Citations
Highly Influential Citations
2
Background Citations
8
Methods Citations
9
Results Citations
1

53 Citations

Citation Type

Citation Type

Microsoft EXCEL 2010 offers an improved random number generator allowing efficient simulation in chemical laboratory studies.
  • A. Kallner
  • Computer Science, Medicine
    Clinica chimica acta; international journal of clinical chemistry
  • 2015
TLDR
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
TLDR
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
TLDR
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
TLDR
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
TLDR
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”
TLDR
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
TLDR
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
TLDR
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
TLDR
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
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…
...
1
2
3
4
5
...

References

SHOWING 1-10 OF 65 REFERENCES
On the accuracy of statistical procedures in Microsoft Excel 2007
TLDR
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
  • A. T. Yalta
  • Mathematics, Computer Science
    Comput. Stat. Data Anal.
  • 2008
TLDR
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
TLDR
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
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
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
TLDR
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
TLDR
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
  • R. Berger
  • Mathematics, Computer Science
    Comput. Stat. Data Anal.
  • 2007
TLDR
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
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
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…
...
1
2
3
4
5
...