On the numerical accuracy of spreadsheets

Journal of Statistical Software

Volumn 34, Issue 4, 2010, Pages 1-29

  Almiron, Marcelo G ^a   Lopes, Bruno ^a   Oliveira, Alyson L C ^a   Medeiros, Antonio C ^a   Frery, Alejandro C ^a  

^a FEDERAL UNIVERSITY OF ALAGOAS   (Brazil)

Author keywords

GNU Oleo; Gnumeric; Microsoft Excel; NeoOffice; Numerical accuracy; OpenOffice.org Calc; Spreadsheet software; Statistical computation

Indexed keywords

EID: 77953199991     PISSN: 15487660     EISSN: 15487660     Source Type: Journal    
DOI: 10.18637/jss.v034.i04     Document Type: Article

References (63)

1. Aliane N (2008). "Spreadsheet-Based Control System Analysis and Design - A CommandOriented Toolbox for Education." IEEE Control Systems Magazine, 28(5), 108-113.
2. Almiron MG, Almeida ES, Miranda MN (2009). "The Reliability of Statistical Functions in Four Software Packages Freely Used in Numerical Computation." Brazilian Journal of Probability and Statistics, 23(2), 107-119.
3. Altman M (2002). "A Review of JMP 4.03 with Special Attention to Its Numerical Accuracy." The American Statistician, 56(1), 72-75.
4. Apigian CH, Gambill SE (2004)."Is Microsoft Excel 2003 Ready for the Statistics Classroom?" Journal of Computer Information Systems, 45(2), 27-35.
5. Bäckman S (2008). "Microeconomics Using Excel: Integrating Economic Theory, Policy Analysis and Spreadsheet Modelling." European Review of Agricultural Economics, 35(2), 247-248.
6. Berger RL (2007). "Nonstandard Operator Precedence in Excel." Computational Statistics & Data Analysis, 51(6), 2788-2791.
7. Bianchi C, Botta F, Conte L, Vanoli P, Cerizza L (2008). "Biological Effective Dose Evaluation in Gynaecological Brachytherapy: LDR and HDR Treatments, Dependence on Radiobiological Parameters, and Treatment Optimisation." Radiologia Medica, 113(7), 1068-1078.
8. Bustos OH, Frery AC (2006). "Statistical Functions and Procedures in IDL 5.6 and 6.0." Computational Statistics & Data Analysis, 50(2), 301-310.
9. Croll GJ (2009). "Spreadsheets and the Financial Collapse." In Proceedings of the European Spreadsheet Risks Interest Group, pp. 145-161.
10. Dzik WS, Beckman N, Selleng K, Heddle N, Szczepiorkowski Z, Wendel S, Murphy M (2008). "Errors in Patient Specimen Collection: Application of Statistical Process Control." Transfusion, 48(10), 2143-2151.
11. Free Software Foundation (2000). GNU Oleo 1.99.16. Free Software Foundation, Inc., Boston, MA. URL http://www.gnu.org/software/oleo/.
12. Free Software Foundation (2007a). "GNU General Public License." URL http://www.gnu.org/copyleft/gpl.html.
13. Free Software Foundation (2007b). "GNU Lesser General Public License." URL http://www.gnu.org/licenses/lgpl.html.
14. Galassi M, Davies J, Theiler J, Gough B, Jungman G, Booth M, Rossi F (2003). GNU Scientific Library Reference Manual. 2nd edition. Network Theory Ltd.
15. Heiser D (2006). "Microsoft Excel 2000 and 2003 Faults, Problems, Workarounds and Fixes." Computational Statistics & Data Analysis, 51(2), 1442-1443.
16. Kaiser J (2002). "Air Pollution Risks - Software Glitch Threw Off Mortality Estimates." Science, 296(5575), 1945-1947.
17. Keeling KB, Pavur RJ (2007). "A Comparative Study of the Reliability of Nine Statistical Software Packages." Computational Statistics & Data Analysis, 51(8), 3811-3831.
18. Kennedy WJ, Gentle JE (1980). Statistical Computing. Marcel Dekker, New York, NY.
19. Knight J (2002). "Statistical Error Leaves Pollution Data Up in the Air." Nature, 417(6890), 677-677.
20. Knüsel L (1995). "On the Accuracy of the Statistical Distributions in GAUSS." Computational Statistics & Data Analysis, 20(6), 699-702.
21. Knüsel L (1998). "On the Accuracy of Statistical Distributions in Microsoft Excel 97." Computational Statistics & Data Analysis, 26(3), 375-377.
22. Knüsel L (2005). "On the Accuracy of Statistical Distributions in Microsoft Excel 2003." Computational Statistics & Data Analysis, 48(3), 445-449.
23. Knuth DE (1998). The Art of Computer Programming, volume II/Seminumerical Algorithms. 3rd edition. Addison-Wesley.
24. Kruck SE (2006). "Testing Spreadsheet Accuracy Theory." Information and Software Technology, 48(3), 204-213.
25. Lindstrom RM, Asvavijnijkulchai C (1998). "Ensuring Accuracy in Spreadsheet Calculations." Fresenius Journal of Analytical Chemistry, 360(3-4), 374-375.
26. Marsaglia G (1995). "The Marsaglia Random Number CDROM, Including the Diehard Battery of Tests of Randomness." Master copy at http://stat.fsu.edu/pub/diehard/. Improved version at http://www.cs.hku.hk/~diehard/.
27. Matsumoto M, Nishimura T (1998)."Mersenne Twister: A 623-Dimensionally Equidistributed Uniform Pseudo-Random Number Generator." ACM Transactions on Modeling and Computer Simulation, 8(1), 3-30.
28. McCullough BD (1998). "Assessing the Reliability of Statistical Software: Part I." The American Statistician, 52(4), 358-366.
29. McCullough BD (1999). "Assessing the Reliability of Statistical Software: Part II." The American Statistician, 53(2), 149-159.
30. McCullough BD (2000). "Is It Safe to Assume that Software Is Accurate?" International Journal of Forecasting, 16(3), 349-357.
31. McCullough BD (2004)."Fixing Statistical Errors in Spreadsheet Software: The Cases of Gnumeric and Excel." Computational Statistics & Data Analysis Statistical Software Newsletter, pp. 1-10.
32. McCullough BD (2008a). "Microsoft Excel's 'Not the Wichmann-Hill' Random Number Generators." Computational Statistics & Data Analysis, 52(10), 4587-4593.
33. McCullough BD (2008b). "Special Section on Microsoft Excel 2007." Computational Statistics & Data Analysis, 52(10), 4568-4569.
34. McCullough BD, Heiser DA (2008). "On the Accuracy of Statistical Procedures in Microsoft Excel 2007." Computational Statistics & Data Analysis, 52(10), 4570-4578.
35. McCullough BD, Wilson B (1999). "On the Accuracy of Statistical Procedures in Microsoft Excel 97." Computational Statistics & Data Analysis, 31(1), 27-37.
36. McCullough BD, Wilson B (2002). "On the Accuracy of Statistical Procedures in Microsoft Excel 2000 and Excel XP." Computational Statistics & Data Analysis, 40(4), 713-721.
37. McCullough BD, Wilson B (2005). "On the Accuracy of Statistical Procedures in Microsoft Excel 2003." Computational Statistics & Data Analysis, 49(4), 1244-1252.
38. Microsoft Corporation (2007). Microsoft Office Excel 2007. URL http://office.microsoft.com/excel.
39. Nash JC (2006). "Spreadsheets in Statistical Practice - Another Look." The American Statistician, 60(3), 287-289.
40. Nash JC (2008). "Teaching Statistics with Excel 2007 and Other Spreadsheets." Computational Statistics & Data Analysis, 52(10), 4602-4606.
41. National Institute of Standards and Technology (1999). "Statistical Reference Datasets: Archives." URL http://www.itl.nist.gov/div898/strd/general/dataarchive.html.
42. Özkaya SI (1996). "An Excel Macro for Importing Log ASCII Standard (LAS) Files into Excel Worksheets." Computers & Geosciences, 22(1), 75-80.
43. Planamesa, Inc (2009). NeoOffice 3.0. URL http://www.NeoOffice.org/.
44. Powell SG, Baker KR, Lawson B (2009). "Impact of Errors in Operational Spreadsheets." Decision Support Systems, 47, 126-132.
45. R Development Core Team (2009). R: A Language and Environment for Statistical Computing. R Foundation for Statistical Computing, Vienna, Austria. ISBN 3-900051-07-0, URL http://www.R-project.org/.
46. Ripley BD (1987). Stochastic Simulation. John Wiley & Sons, New York, NY.
47. Ripley BD (1990). "Thoughts on Pseudorandom Number Generators." Journal of Computational and Applied Mathematics, 31, 153-163.
48. Roth J (2008). "Ergebnisse von Qualitätskontrollen der Individuellen Patientendosen in der Radioonkologie." Strahlentherapie und Onkologie, 184(10), 505-509.
49. Rukhin A, Soto J, Nechvatal J, Smid M, Barker E, Leigh S, Levenson M, Vangel M, Banks D, Heckert A, Dray J, Vo S (2008). A Statistical Test Suite for Random and Pseudorandom Number Generators for Cryptographic Applications. National Institute of Standards and Technology. NIST Special Publication 800-22rev1, URL http://csrc.nist.gov/groups/ST/toolkit/rng/.
50. Segaran T, Hammerbacher J (eds.) (2009). Beaultiful Data. O'Reilly.
51. Simon SD, Lesage JP (1989). "Assessing the Accuracy of ANOVA Calculations in Statistical Software." Computational Statistics & Data Analysis, 8(3), 325-332.
52. Su Y (2008). "It's Easy to Produce Chartjunk Using Microsoft Excel 2007 but Hard to Make Good Graphs." Computational Statistics & Data Analysis, 52(10), 4594-4601.
53. Sun Microsystems Inc (2009). OpenOffice.org Calc 3.0.1. URL http://www.OpenOffice.org/.
54. The Gnumeric Team (2007). The Gnumeric Manual, Version 1.8. GNOME Documentation Project. URL http://projects.gnome.org/gnumeric/.
55. Vinod HD (2000). "Review of GAUSS for Windows, Including Its Numerical Accuracy." Journal of Applied Econometrics, 15(2), 211-220.
56. Wichmann BA, Hill ID (1982)."Algorithm AS 183: An Efficient and Portable Pseudo-Random Number Generator." Applied Statistics, 31(2), 188-190.
57. Wichmann BA, Hill ID (2006). "Generating Good Pseudo-Random Numbers." Computational Statistics & Data Analysis, 51(3), 1614-1622.
58. Xie XF, Zhang WJ, Yang ZL (2002). "Social Cognitive Optimization for Nonlinear Programming Problems." In Proceedings of the First International Conference on Machine Learning and Cybernetics, volume 2, pp. 779-783.
59. Yalta AT (2007). "The Numerical Reliability of GAUSS 8.0." The American Statistician, 61(3),262-268.
60. Yalta AT (2008). "The Accuracy of Statistical Distributions in Microsoft Excel 2007." Computational Statistics & Data Analysis, 52(10), 4579-4586.
61. Yalta AT, Yalta AY (2007). "GRETL 1.6.0 and Its Numerical Accuracy." Journal of Applied Econometrics, 22(4), 849-854.
62. Zhang WJ, Xie XF (2003). "DEPSO: Hybrid Particle Swarm with Differential Evolution Operator." In IEEE International Conference on Systems, Man and Cybernetics, volume 4, pp. 3816-3821.
63. Zoethout RWM, van Gerven JMA, Dumont GJH, Paltansing S, van Burgel ND, van der Linden M, Dahan A, Cohen AF, Schoemaker RC (2008). "A Comparative Study of Two Methods for Attaining Constant Alcohol Levels." British Journal of Clinical Pharmacology, 66(5), 674-681.