On the accuracy of statistical procedures in Microsoft Excel 2003

Computational Statistics and Data Analysis

Volumn 49, Issue 4, 2005, Pages 1244-1252

  McCullough, B D ^a   Wilson, Berry ^b  

^a DREXEL UNIVERSITY   (United States)

^b PACE UNIVERSITY   (United States)

Author keywords

Benchmarks; Software; Strd; TestU01

Indexed keywords

ALGORITHMS; BENCHMARKING; CONTROL SYSTEMS; FUNCTIONS; PARAMETER ESTIMATION; PROBLEM SOLVING; PROGRAM DEBUGGING; STATISTICAL METHODS;

STATISTICAL DISTRIBUTIONS; STATISTICAL SOFTWARE; STRD; TESTU01;

COMPUTER SOFTWARE;

EID: 19044363551     PISSN: 01679473     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.csda.2004.06.016     Document Type: Article

References (23)

1. Carlson, W., 2002. The use of Microsoft Excel for statistical purposes: a textbook author perspective. Proceedings of the 2001 Joint Statistical Meetings [CD ROM], American Statistical Association, Alexandria, VA.
2. Cook, H.R., Cox, M.G., Dainton, M.P., Harris, P.M., 2000. Testing the intrinsic functions of excel. NPL Report CISE 27/00, www.npl.co.uk/ssfm/ download.
3. Cryer, J., 2002. Problems with using Microsoft Excel for statistics. Proceedings of the 2001 Joint Statistical Meetings [CD-ROM], American Statistical Association, Alexandria, VA.
4. J.E. Gentle Random Number Generation and Monte Carlo Methods 2 e 2003 Springer New York
5. Knüsel, L., 1989. Computergestützte Berechnung Statistischer Verteilungen. Oldenburg, München-Wien (An English version of the program can be obtained at http://www.stat.uni-muenchen.de/ ∼ knuesel/elv).
6. L. Knüsel On the accuracy of statistical distributions in Gauss Comput. Statist. Data Anal. 20 1995 699 702
7. Knüsel, L., 2004. On the accuracy of statistical distributions in Microsoft Excel 2003. Manuscript.
8. D.E. Knuth The Art of Computer Programming, vol. 2, Semminumerical Algorithms 1981 Addison-Wesley Reading, MA
9. P. L'Ecuyer Uniform random number generation Ann. Oper. Res. 53 1994 77 120
10. L'Ecuyer, P., Simard, R., 2003. TESTU01: a software library in ANSIC for empirical testing of random number generators. Manuscript, Department d'Informatique et de Recherche Operationnelle, University of Montreal.
11. Marsaglia, G., 1996. DIEHARD: a battery of tests of randomness. http://stat.fsu.edu/ ∼ geo.
12. M. Matsumoto, and T. Nishimura Mersenne twister a 623-dimensionally equidistributed uniform pseudorandom number generator ACM Trans. Model. Comput. Simul. 8 1 1998 3 30
13. B.D. McCullough Assessing the reliability of statistical software part I Amer. Statist. 52 1998 358 366
14. B.D. McCullough Experience with the StRD application and interpretation Statist. Comput. 31 2000 16 21 (Proceedings of the Interface Conference)
15. B.D. McCullough The accuracy of mathematica 4 as a statistical package Comput. Statist. 15 2000 279 299
16. McCullough, B.D., 2002. Does Microsoft fix errors in excel? Proceedings of the 2001 Joint Statistical Meetings [CD-ROM], American Statistical Association, Alexandria, VA.
17. McCullough, B.D., 2004a. Fixing statistical errors in spreadsheet software: the cases of Gnumeric and Excel. Statist. Software Newslett. http://www.ssncsda.org/reports.
18. B.D. McCullough Some details of nonlinear estimation M. Altman J. Gill M.P. McDonald Numerical Methods in Statistical Computing for the Social Sciences 2004 Wiley New York 199 218 (Chapter 8)
19. B.D. McCullough, and B. Wilson On the accuracy of statistical procedures in Microsoft Excel 97 Comput. Statist. Data Anal. 31 1999 27 37
20. B.D. McCullough, and B. Wilson On the accuracy of statistical procedures in Microsoft Excel 2000 and XP Comput. Statist. Data Anal. 40 4 2002 27 37
21. B.A. Wichmann, and I.D. Hill Algorithm AS 183 an efficient and portable pseudo-random number generator Appl. Statist. 31 1982 188 190
22. B.A. Wichmann, and I.D. Hill Correction algorithm AS 183: an efficient and portable pseudo-random number generator Appl. Statist. 33 1984 123
23. S. Wolfram The Mathematica Book 4 e 1999 Cambridge University Press New York