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

Authors:
B. D. McCullough;Berry Wilson
Affiliations:
Department of Decision Sciences, LeBow College of Business, Drexel University, Philadelphia, PA;Finance and Graduate Economics Department, Lubin School of Business, Pace University, New York, NY
Venue:
Computational Statistics & Data Analysis
Year:
2002

Citing 8
Cited 8

Numerical recipes in FORTRAN (2nd ed.): the art of scientific computing

Numerical recipes in FORTRAN (2nd ed.): the art of scientific computing
Testing numerical reliability of data analysis systems

Computational Statistics & Data Analysis
Report on the numerical reliability of data analysis systems

Computational Statistics & Data Analysis
On the accuracy of statistical distributions in Microsoft Excel 97

Computational Statistics & Data Analysis
On the accuracy of statistical procedures in Microsoft Excel 97

Computational Statistics & Data Analysis
Applied Statistics with Microsoft Excel

Applied Statistics with Microsoft Excel
Statistics for Managers Using Microsoft Excel

Statistics for Managers Using Microsoft Excel
Practical Statistics by Example Using Microsoft Excel and MINITAB

Practical Statistics by Example Using Microsoft Excel and MINITAB

On the reliability of Microsoft Excel XP for statistical purposes

Computational Statistics & Data Analysis
Numerical accuracy issues in using Excel for simulation studies

WSC '04 Proceedings of the 36th conference on Winter simulation
Short communication: Nonstandard operator precedence in Excel

Computational Statistics & Data Analysis
A comparative study of the reliability of nine statistical software packages

Computational Statistics & Data Analysis
Automatic determination of ligand purity and apparent dissociation constant (Kapp) in Ca2+/Mg2+ buffer solutions and the Kapp for Ca2+/Mg2+ anion binding in physiological solutions from Ca2+/Mg2+-macroelectrode measurements

Computers in Biology and Medicine
The accuracy of statistical distributions in Microsoft®Excel 2007

Computational Statistics & Data Analysis
Statistical functions and procedures in IDL 5.6 and 6.0

Computational Statistics & Data Analysis
Should Economists Use Open Source Software for Doing Research?

Computational Economics

Quantified Score

Hi-index	0.03

Visualization

Abstract

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 standard normal random number generator and the inverse normal function, and in the former case actually made the problem worse.