论文信息 - On the accuracy of statistical procedures in Microsoft Excel 2003

On the accuracy of statistical procedures in Microsoft Excel 2003

Someof the problems that renderedExcel 97, Excel 2000 andExcel 2002 unfit for use as a statistical package have been fixed in Excel 2003, though some have not. Additionally, in fixing some errors, Microsoft introduced other errors. Excel’s new and improved random number generator, at default, is supposed to produce uniform numbers on the interval (0,1); but it also produces negative numbers. Excel 2003 is an improvement over previous versions, but not enough has been done that its use for statistical purposes can be recommended. © 2004 Elsevier B.V. All rights reserved.

B. D. McCullough | Berry Wilson

[1] Bruce D. McCullough,et al. On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP , 2002 .

[2] Bruce D. McCullough,et al. Assessing the Reliability of Statistical Software: Part I , 1998 .

[3] Takuji Nishimura,et al. Mersenne twister: a 623-dimensionally equidistributed uniform pseudo-random number generator , 1998, TOMC.

[4] Pierre L'Ecuyer,et al. Uniform random number generation , 1994, Ann. Oper. Res..

[5] B. D. McCullough,et al. The accurary of Mathematica 4 as a statistical package , 2000, Comput. Stat..

[6] Micah Altman,et al. Some Details of Nonlinear Estimation , 2004 .

[7] Leo Knüsel. On the accuracy of the statistical distributions in GAUSS , 1995 .

[8] Leo Kn usel. On the accuracy of statistical distributions in Microsoft Excel 2003 , 1998 .

[9] Jonathan D. Cryer,et al. Problems With Using Microsoft Excel for Statistics , 2001 .

[10] David Thomas,et al. The Art in Computer Programming , 2001 .

[11] I. D. Hill,et al. Correction: Algorithm AS 183: An Efficient and Portable Pseudo-Random Number Generator , 1982 .