Journal article
On the accuracy of statistical procedures in Microsoft Excel 2007
Computational statistics & data analysis, v 52(10), pp 4570-4578
15 Jun 2008
Featured in Collection : UN Sustainable Development Goals @ Drexel
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. (C) 2008 Elsevier B.V. All rights reserved.
Metrics
Details
- Title
- On the accuracy of statistical procedures in Microsoft Excel 2007
- Creators
- B. D. McCullough - Drexel Univ, Dept Decis Sci, LeBow Coll Business, Philadelphia, PA 19104 USADavid A. Heiser
- Publication Details
- Computational statistics & data analysis, v 52(10), pp 4570-4578
- Publisher
- Elsevier
- Number of pages
- 9
- Resource Type
- Journal article
- Language
- English
- Academic Unit
- Decision Sciences (and Management Information Systems)
- Web of Science ID
- WOS:000257377100002
- Scopus ID
- 2-s2.0-44349100403
- Other Identifier
- 991019168624404721
UN Sustainable Development Goals (SDGs)
This publication has contributed to the advancement of the following goals:
InCites Highlights
Data related to this publication, from InCites Benchmarking & Analytics tool:
- Web of Science research areas
- Computer Science, Interdisciplinary Applications
- Statistics & Probability