Statistical accuracy of spreadsheet software

American Statistician

Volumn 65, Issue 4, 2011, Pages 265-273

  Keeling, Kellie B ^a   Pavur, Robert J ^b  

^a UNIVERSITY OF DENVER   (United States)

^b Department of Information Technology and Decision Sciences   (United States)

Author keywords

Gnumeric; Microsoft excel; Open office; Open source; Software accuracy; Spreadsheet; Strd

Indexed keywords

EID: 84856051135     PISSN: 00031305     EISSN: None     Source Type: Journal    
DOI: 10.1198/tas.2011.09076     Document Type: Article

References (26)

1. Almiron, M.G., Lopes, B., Oliveira, A.L.C., Medeiros, A.C. and Frery, A.C. (2010), "On the Numerical Accuracy of Spreadsheets," Journal of Statistical Software, 34, 1-29. 265
2. Cambell-Kelly, M. (2007), "Number Crunching without Programming: The Evolution of Spreadsheet Usability," IEEE Annals of the History of Computing, 29, 6-19. 266
3. Dielman, T. (2002), "The Numerical Accuracy of Statistical Calculations in Excel 2000 and Minitab Version 13," Journal of Business and Management, 8, 199-207. 265
4. Keeling, K., and Pavur, R. (2007), "Assessing the Accuracy of Common Software Used for Statistical Analysis," Computational Statistics and Data Analysis, 51, 3811-3831. 265, 268
5. Knusel, L. (2005), "On the Accuracy of Statistical Distributions in Microsoft Excel 2003," Computational Statistics and Data Analysis, 48, 445-449. 265, 272
6. L'Ecuyer, P., and Simard, R. (2007), "TestU01: A C Library for Empirical Testing of Random Number Generators," ACM Transactions on Mathematical Software, 33, Article 22, 21-40. 272
7. Marsaglia, G. (1996), "The Marsaglia Random Number CDROM Including the Diehard Battery of Tests of Randomness," available online at http;/stat.fsu.edu/pub/diehard/.272
8. Matsumoto, M., and Nishimura, T. (1998), "Mersenne Twister: A 623-Dimensionally Equidistributed Uniform Pseduo-Random Number Generator," ACM Transactions on Modeling and Computer Simulation, 8, 3-30. 272
9. McCullough, B.D. (1998), "Assessing the Reliability of Statistical Software: Part I," The American Statistician, 52, 358-366. 266
10. McCullough, B.D. (1999), "Assessing the Reliability of Statistical Software: Part II," The American Statistician, 53, 149-159. 266
11. McCullough, B.D. (2004a), "Fixing Statistical Errors in Spreadsheet Software: The Cases of Gnumeric and Excel," available online at www.csdassn.org/softwarereports.cfm. 265, 269, 272
12. McCullough, B.D. (2004b), "Wilkinson's Tests and Econometric Software," Journal of Economic and Social Measurement, 29, 261-270. 266
13. McCullough, B.D., and Wilson, B. (2008), "Microsoft Excel's 'Not the Wichmann-Hill' Random Number Generators," Computational Statistics and Data Analysis, 52, 4587-4593. 265, 272
14. McCullough, B.D., and Heiser, D.A. (2008), "On the Accuracy of Statistical Procedures in Microsoft Excel 2007," Computational Statistics and Data Analysis, 52, 4570-4578. 272
15. McCullough, B.D., and Wilson, B. (1999), "On the Accuracy of Statistical Procedures in Microsoft Excel 97," Computational Statistics and Data Analysis, 31, 27-37. 272
16. McCullough, B.D., and Wilson, B. (2002), "On the Accuracy of Statistical Procedures in Microsoft Excel 2000 and Excel XP," Computational Statistics and Data Analysis, 40, 713-721. 272
17. McCullough, B.D., and Wilson, B. (2005), "On the Accuracy of Statistical Procedures in Microsoft Excel 2003," Computational Statistics and Data Analysis, 49, 1244-1252. 265, 272
18. Nash, J.C. (2006), "Spreadsheets in Statistical Practice-Another Look," The American Statistician, 60, 287-289. 265
19. Nash, J.C. (2008), "Teaching Statistics with Excel 2007 and Other Spreadsheets," Computational Statistics and Data Analysis, 52, 4602-4606. 265
20. Oppenheimer, D.M. (2009), "Function Improvement," in Excel Blog, http://blogs.office.com/b/microsoft-excel/archive/2009/09/10/function-improvements-in-excel-2010.aspx.272
21. Sawitzki, G. (1994), "Report on the Reliability of Data Analysis Systems," Computational Statistics and Data Anaysis, 18, 289-301. 266
22. Scheier, R.L. (2009), "Can Google Really Hack It in Business?," in Network World Asia: Questex Media. 266
23. Wilkinson, L. (1985), Statistics Quiz: Problems Which Reveal Deficiencies in Statistical Programs, Evanston, IL.: Systat Inc. 266
24. Wilkinson, L. (1994), "Practical Guidelines for Testing Statistical Software," in Computational Statistics: Papers Collected on the Occasion of the 25th Conference on Statistical Computing, eds. P. Dirschedl and R. Ostermann, Schloss Reisensburg: Physica-Verlag. 266
25. Yalta, A.T. (2008), "The Accuracy of Statistical Distributions in Microsoft Excel 2007," Computational Statistics and Data Analysis, 52, 4579-4586. 265, 266, 271, 272
26. Yalta, A.T., and Yalta, Y. (2010), "Should Economists Use Open Source Software for Doing Research?," Computational Economics, 35, 371-394. 272