On the accuracy of statistical procedures in Microsoft Excel 2010
@article{Mlard2014OnTA,
title={On the accuracy of statistical procedures in Microsoft Excel 2010},
author={G. 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… CONTINUE READING
Figures, Tables, and Topics from this paper
44 Citations
Microsoft EXCEL 2010 offers an improved random number generator allowing efficient simulation in chemical laboratory studies.
- Computer Science, Medicine
- Clinica chimica acta; international journal of clinical chemistry
- 2015
- 6
Assessing Excel VBA Suitability for Monte Carlo Simulation
- Computer Science, Mathematics
- ArXiv
- 2015
- 4
- PDF
On the Examination of the Reliability of Statistical Software for Estimating Logistic Regression Models
- Computer Science
- 2015
- 1
- PDF
On the accuracy of linear regression routines in some data mining packages
- Computer Science
- Wiley Interdiscip. Rev. Data Min. Knowl. Discov.
- 2019
- 2
Excel-lence in Data Visualization?: The Use of Microsoft Excel for Data Visualization and the Analysis of Big Data
- Computer Science
- 2017
- 5
- PDF
Inaccurate regression coefficients in Microsoft Excel 2003: an investigation of Volpi’s “zero bug”
- Computer Science
- Comput. Stat.
- 2017
- 1
Resampling methods in Microsoft Excel® for estimating reference intervals
- Computer Science, Medicine
- Biochemia medica
- 2015
- 2
- PDF
Estimating the Accuracy of the Return on Investment (ROI) Performance Evaluations
- Computer Science, Mathematics
- ArXiv
- 2014
- 3
- PDF
References
SHOWING 1-10 OF 65 REFERENCES
On the accuracy of statistical procedures in Microsoft Excel 2007
- Computer Science
- Comput. Stat. Data Anal.
- 2008
- 127
- PDF
The accuracy of statistical distributions in Microsoft® Excel 2007
- Mathematics, Computer Science
- Comput. Stat. Data Anal.
- 2008
- 54
- Highly Influential
- PDF
On the accuracy of statistical procedures in microsoft Excel 2000 and Excel XP
- Computer Science
- 2002
- 102
- PDF
Polynomial Trendline function flaws in Microsoft Excel
- Mathematics, Computer Science
- Comput. Stat. Data Anal.
- 2010
- 16
- PDF
Nonstandard operator precedence in Excel
- Mathematics, Computer Science
- Comput. Stat. Data Anal.
- 2007
- 11
- Highly Influential