On the accuracy of statistical procedures in Microsoft Excel 97

被引：74

作者：

McCullough, BD ^{[1
]}

Wilson, B ^{[1
]}

机构：

[1] FCC, Washington, DC 20554 USA

来源：

COMPUTATIONAL STATISTICS & DATA ANALYSIS | 1999年 / 31卷 / 01期

关键词：

DIEHARD; ELV; numerical accuracy; software testing; StRD;

D O I：

10.1016/S0167-9473(99)00004-3

中图分类号：

TP39 [计算机的应用];

学科分类号：

081203 ; 0835 ;

摘要：

The reliability of statistical procedures in Excel are assessed in three areas: estimation (both linear and nonlinear); random number generation; and statistical distributions (e.g., for calculating p-values). Excel's performance in all three areas is found to be inadequate. Persons desiring to conduct statistical analyses of data are advised not to use Excel. (C) 1999 Elsevier Science B.V. All rights reserved.

引用

页码：27 / 37

页数：11

共 22 条

[1]

DWYER J, 1996, C C PLUS PLUS USERS, P57

[2]

DWYER J, 1996, C C PLUS PLUS US JUN, P39

[3]

Gentle J.E., 1998, RANDOM NUMBER GENERA

[4]

HUNKA S, 1997, ANOVA NB