Journal article
On the accuracy of statistical procedures in Microsoft Excel 2003
Computational statistics & data analysis, v 49(4), pp 1244-1252
2005
Featured in Collection : UN Sustainable Development Goals @ Drexel
Abstract
Some of the problems that rendered Excel 97, Excel 2000 and Excel 2002 unfit for use as a statistical package have been fixed in Excel 2003, though some have not. Additionally, in fixing some errors, Microsoft introduced other errors. Excel's new and improved random number generator, at default, is supposed to produce uniform numbers on the interval (0,1); but it also produces negative numbers. Excel 2003 is an improvement over previous versions, but not enough has been done that its use for statistical purposes can be recommended.
Metrics
Details
- Title
- On the accuracy of statistical procedures in Microsoft Excel 2003
- Creators
- B.D. McCullough - Department of Decision Sciences, LeBow College of Business, Drexel University, Philadelphia, PA 19104, USABerry Wilson - Finance and Graduate Economics Department, Lubin School of Business, Pace University, New York, NY 10038, USA
- Publication Details
- Computational statistics & data analysis, v 49(4), pp 1244-1252
- Publisher
- Elsevier
- Resource Type
- Journal article
- Language
- English
- Academic Unit
- Decision Sciences (and Management Information Systems)
- Web of Science ID
- WOS:000230077400017
- Scopus ID
- 2-s2.0-19044363551
- Other Identifier
- 991019169651104721
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:
- Collaboration types
- Domestic collaboration
- Web of Science research areas
- Computer Science, Interdisciplinary Applications
- Statistics & Probability