On the accuracy of statistical procedures in Microsoft Excel 2007

  • Authors:
  • B. D. McCullough;David A. Heiser

  • Affiliations:
  • Department of Decision Sciences, LeBow College of Business, Drexel University, Philadelphia, PA 19104, United States;Carmichael, CA, United States

  • Venue:
  • Computational Statistics & Data Analysis
  • Year:
  • 2008

Quantified Score

Hi-index 0.03

Visualization

Abstract

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 specific Excel procedures are discussed. Microsoft's continuing inability to correctly fix errors is discussed. 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. Persons who wish to conduct statistical analyses should use some other package.