On the accuracy of statistical procedures in Microsoft Excel 97

Computational Statistics and Data Analysis

Volumn 31, Issue 1, 1999, Pages 27-37

  McCullough, B D ^a   Wilson, Berry ^a  

^a FEDERAL COMMUNICATIONS COMMISSION   (United States)

Author keywords

DIEHARD; ELV; Numerical accuracy; Software testing; StRD

Indexed keywords

COMPUTER SOFTWARE; DATA REDUCTION; DATA STRUCTURES; ESTIMATION; PROGRAM DEBUGGING; RANDOM NUMBER GENERATION; RELIABILITY;

MICROSOFT EXCEL; NUMERICAL ACCURACY; SOFTWARE TESTING; STATISTICAL REFERENCE DATA SETS;

STATISTICAL METHODS;

COMPUTER PROGRAM;

EID: 0032707157     PISSN: 01679473     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0167-9473(99)00004-3     Document Type: Article

References (22)

1. Dwyer, J., Williams, K.B., 1996a. Testing random number generators. C / C++ Users J. 39-48.
2. Dwyer, J., Williams, K.B., 1996b. Testing random number generators, Part 2. C / C++ Users J. 57-66.
3. Gentle, J., 1998. Random Number Generation and Monte Carlo Methods. Springer, New York.
4. Hunka, S., 1997. ANOVA.NB, www.mathsource.com.
5. Knüsel, L. 1989. Computergestützte Berechnung Statisticher Verteilungen. Oldenburg, München-Wien [English versions of the program and documentation at www.stat.uni-muenchen.de / ̃knuesel / elv].
6. Knüsel L. On the accuracy of statistical distributions in Microsoft Excel 97. Comput. Statist. Data Anal. 26:1998;375-377.
7. Knuth, D., 1981. The Art of Computer Programming, vol. 2, Seminumerical Algorithms, 2nd ed., Addison-Wesley, Reading, MA.
8. Ling R.F. Comparison of several algorithms for computing sample means and variances. J. Amer. Statist. Assoc. 69:1974;859-866.
9. Longley J.W. An appraisal of computer programs for the electronic computer from the point of view of the user. J. Amer. Statist. Assoc. 62:1967;819-841.
10. Marsaglia G. Monkey tests for random number generators. Comput. Math. Appl. 26:1993;1-10.
11. Marsaglia, G., 1996. DIEHARD: A battery of tests of randomness. http: // stat.fsu.edu / pub / diehard.
12. McCullough B.D. Asssessing the reliability of statistical software: Part I. The Amer. Statist. 52:1998;358-366.
13. McCullough, B.D., 1999a. Asssessing the reliability of statistical software: part II. The Amer. Statist., forthcoming.
14. McCullough, B.D., 1999b. The reliability of econometric software: Eviews, LIMDEP, SHAZAM and TSP. J. Appl. Econom., forthcoming.
15. Press, W.H., Teukolsky, S.A., Vetterling, W.T., Flannery, B.R., 1992. Numerical Recipes in Fortran, 2nd ed. Cambridge University Press, New York.
16. Rogers, J., Filliben, J., Gill, L., Guthrie, W., Lagergren, E., Vangel, M., 1998. StRD: statistical reference datasets for assessing the numerical accuracy of statistical software. NIST TN# 1396, National Institute of Standards and Technology, USA.
17. Sawitzki G. Testing numerical reliability of data analysis systems. Comput. Statist. Data Anal. 18:1994;269-286.
18. Sawitzki G. Report on the reliability of data analysis systems. Comput. Statist. Data Anal. (SSN). 18:1994;289-301.
19. Thisted, R.A. 1988. Elements of Statistical Computing. Chapman & Hall, London.
20. Wilkinson, L., 1985. Statistics Quiz. IL. SYSTAT, Evanston.
21. Wilkinson, L., 1994. Practical guidelines for testing statistical software. In: Dirschedl, P., Ostermann, R. (Eds.), Computational Statistics. Physica-Verlag, Berlin, pp. 111-124.
22. Wolfram, S. 1996, Mathematica 3.0 User's Guide. Cambridge University Press, New York.