On the accuracy of statistical procedures in Microsoft Excel 2007

Computational Statistics and Data Analysis

Volumn 52, Issue 10, 2008, Pages 4570-4578

  McCullough, B D ^a   Heiser, David A ^b  

^a DREXEL UNIVERSITY   (United States)

^b NONE

Author keywords

[No Author keywords available]

Indexed keywords

ERROR ANALYSIS; SOFTWARE PACKAGES; SOFTWARE TESTING;

MICROSOFT DOCUMENTS; MICROSOFT EXCEL 2007;

STATISTICAL METHODS;

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

References (42)

1. Altman M., Gill J., and McDonald M.P. Numerical Issues in Statistical Computing for the Social Scientists (2004), John Wiley and Sons, New York
2. Barreto H., and Howland F.M. Introductory Econometrics: Using Monte Carlo Simulation with Microsoft Excel (2006), Cambridge University Press, New York
3. Berger R.L. Nonstandard operator precedence in Excel. Computational Statistics & Data Analysis 51 6 (2007) 2788-2791
4. Cook, H.R., Cox, M.G., Dainton, M.P., Harris, P.M., 1999. Testing spreadsheets and other packages used in metrology: Testing the intrinsic functions of Excel. Report to the National Measurement System Policy Unit, Department of Trade and Industry, from the UK Software Support for Metrology Programme. NPL Report CISE 27/99
5. de Levie R. Advanced Excel for Scientific Analysis (2003), Oxford University Press, New York
6. Denton P. Analysis of first-order kinetics using Microsoft Excel solver. Journal of Chemical Education 77 11 (2000) 1524-1525
7. Gottfreid B.S. Spreadsheet Tools for Engieers Using Excel (2002), Mcgraw-Hill, New York
8. Heiser D.A. Microsoft Excel 2000 and 2003 faults, problems, workarounds and fixes. Computational Statistics & Data Analysis 51 2 (2006) 1442-1443
9. Heiser, and David A. Statistical tests, tests of significance, and tests of a hypothesis using Excel. Journal of Applied Statistical Methods 5 2 (2006) 155-171
10. Hesse R. Incorrect nonlinear trend curves in Excel. Foresight: International Journal of Applied Forecasting 3 (2006) 39-43
11. Jones C.M., Lamont O., and Lumsdaine R. Macroeconomic news and bond market volatility. Journal of Financial Economics 47 (1998) 315-337
12. Keeling K., and Pavur R. A comparative study of the reliability of nine statistical software packages. Computational Statistics & Data Analysis 51 8 (2007) 3811-3831
13. Keller G. Applied Statistics with Microsoft Excel (2001), Duxbury, Belmont, CA
14. Kennedy W., and Gentle J. Statistical Computing (1980), Marcel Dekker, New York
15. Kitchen A., Drachenberg R., and Symanzik J. Assessing the reliability of web-based statistical software. Computational Statistics 18 1 (2003) 107-122
16. L'Ecuyer P., and Simard R. TESTU01: A C library for empirical testing of random number generators. ACM TOMS 33 4 (2007) Article 22
17. Levine D., Stephan D., Krehbiel T., and Berenson M. Statistics for Managers Using Microsoft Excel, 3e (2002), Prentice-Hall, Englewood Cliffs, NJ
18. Marsaglia, George, 1996. DIEHARD: A Battery of Tests of Randomness. http://stat.fsu.edu/pub/diehard
19. McCullough B.D. Assessing the reliability of statistical software: Part I. The American Statistician 52 (1998) 358-366
20. McCullough B.D. Assessing the reliability of statistical software: Part II. The American Statistician 53 2 (1999) 149-159
21. McCullough B.D. Econometric software reliability: E-Views, LIMDEP, SHAZAM, and TSP. Journal of Applied Econometrics 14 2 (1999) 191-202
22. McCullough B.D. Some details of nonlinear estimation, chapter eight. In: Altman M., Gill J., and McDonald M.P. (Eds). Numerical Methods in Statistical Computing for the Social Sciences (2004), Wiley, New York
23. McCullough B.D. Wilkinson's tests and econometric software. Journal of Economic and Social Measurement 29 1-3 (2004) 261-270
24. McCullough, B.D., 2004c. Fixing stataistical errors in spreadsheet software: The cases of gnumeric and Excel, CSDA Statistical Software Newsletter, www.csdassn.org/software_reports.cfm
25. McCullough B.D. Microsoft Excel's 'Not The Wichmann-Hill' random number generators. Computational Statistics & Data Analysis (2008)
26. McCullough B.D., and Renfro C.G. Some numerical aspects of nonlinear estimation. Journal of Economic and Social Measurement 26 1 (2000) 63-77
27. McCullough B.D., and Wilson B. On the accuracy of statistical procedures in microsoft Excel 97. Computational Statistics and Data Analysis 31 (1999) 27-37
28. McCullough B.D., and Wilson B. On the accuracy of statistical procedures in Microsoft Excel 2000 and XP. Computational Statistics and Data Analysis 40 4 (2002) 27-37
29. McCullough B.D., and Wilson B. On the accuracy of statistical procedures in Microsoft Excel 2003. Computational Statistics and Data Analysis 49 4 (2005) 1244-1252
30. Miles J.N.V. Confirmatory factor analysis using Microsoft Excel. Behavior and Research Methods 37 4 (2005) 672-676
31. Mondragon P.F., and Borchers B. A comparison of nonlinear regression codes. Journal of Modern Applied Statistical Methods 4 1 (2005) 343-351
32. Montgomery D.C., Johnson L.A., and Gardiner J.S. Forecasting and Time Series Analysis. 2nd ed (1990), McGraw-Hill, New York
33. Newbold P., and Bos T. Introductory Business Forecasting (1990), Southwestern, Cincinatti, OH
34. Nikitas P., and Pappa-Louisi A. Non-linear least-squares fitting with Microsoft Excel solver and related routines in HPLC modelling of retention. Chromatographia 52 7-8 (2000) 477-486
35. Pottel, Hans, 2003. Statistical flaws in Excel, Mimeo, Innogenetics NV, Zwijnaarde, Belgium
36. Sawitzki G. Report on the numerical reliability of data analysis systems. Computational Statistics and Data Analysis 18 2 (1994) 289-301
37. Simonoff, Jeffrey, 2002. Statistical analysis using Microsoft Excel 2000, Mimeo, Stern School of Business, NYU
38. Su Y.-S. It's easy to produce chartjunk using Microsoft Excel 2007 but hard to make good graphs. Computational Statistics and Data Analysis (2008)
39. Thisted R.A. Elements of Statistical Computing: Numerical Computation (1988), Chapman and Hall, New York
40. Wilkinson L. Statistics Quiz (1985), Systat, Inc., Evanston, IL
41. Yalta A.T. The numerical reliability of GAUSS 8.0. The American Statistician 61 3 (2007) 262-268
42. Yalta A.T. On the accuracy of statistical distributions in Microsoft Excel 2007. Computational Statistics & Data Analysis (2008)