Numerical accuracy issues in using excel for simulation studies

Proceedings - Winter Simulation Conference

Volumn 2, Issue , 2004, Pages 1513-1518

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

^a VIRGINIA POLYTECHNIC INSTITUTE AND STATE UNIVERSITY   (United States)

^b UNIVERSITY OF NORTH TEXAS   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; BENCHMARKING; COMPUTER SIMULATION; DATA REDUCTION; MARKOV PROCESSES; MATHEMATICAL MODELS; NUMERICAL METHODS; POISSON EQUATION; REGRESSION ANALYSIS; WEBSITES;

COMPUTATIONAL SOFTWARE; DATA SETS; NUMERICAL ACCURACY; STATISTICAL SOFTWARE PROGRAMS;

SPREADSHEETS;

EID: 17744388829     PISSN: 08917736     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (14)

1. Brown. 1999. A methodology for simulating biological systems using Microsoft Excel. Computer Methods and Programs in Biomedicine 58(2): 181-190.
2. Cryer, J. 2002. Problems with using Microsoft Excel for statistics. In Proceeding of the 2001 Joint Statistical Meetings, American Statistical Association. Alexandria, Virginia.
3. Greasley, A. 1998. An example of a discrete-event simulation on a spreadsheet. Simulation 70(3): 148-166.
4. Knusel, L. 2002. On the reliability of Microsoft Excel XP for statistical purposes. Computational Statistics and Data Analysis 39: 109-110.
5. Knusel, L. 2004. On the accuracy of statistical distributions in Microsoft Excel 2003. Computational Statistics and Data Analysis: To Appear.
6. Laverty, W. H., M. J. Miket, and I. W. Kelly. 2002. Simulation of hidden Markov models with EXCEL. Journal of the Royal Statistical Society Series D-The Statistician. Part 1 51: 31-40.
7. McCullough, B. D. 1998. Assessing the reliability of statistical software: Part I. The American Statistician 52: 358-366.
8. McCullough, B. D. 1999. Assessing the reliability of statistical software: Part II. The American Statistician 53: 149-159.
9. McCullough, B. D. and B. Wilson. 2002. On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP. Computational Statistics and Data Analysis 40: 713-721.
10. Sawitzki, G. 1994. Report on the reliability of data analysis systems. Computational Statistics and Data Analysis 18: 289-301.
11. Statacorp. 2001. Stata Statistical Software: Release 7.0. Stata Corporation, College Station, Texas.
12. Statcrunch. 2002. Statistical software for data analysis on the Web, Integrated Analytics LLC. Available online via 〈http://www.statcrunch. com〉 (accessed August 3, 2004)
13. Wilkinson, L. 1985. Statistics quiz: problems which reveal deficiencies in statistical programs. Evanston, Illinois: Systat Inc.
14. Yang, Y. H., K. Haddad, and C. W. Chow. 2001. Capacity planning using Monte Carlo simulation: an illustrative application of commonly available PC software. Managerial Finance 27(5): 33-54.