The accuracy of statistical distributions in Microsoft® Excel 2007

被引：30

作者：

Yalta, A. Talha ^{[1
]}

机构：

[1] TOBB Univ Econ & Technol, TR-06560 Ankara, Turkey

来源：

COMPUTATIONAL STATISTICS & DATA ANALYSIS | 2008年 / 52卷 / 10期

关键词：

D O I：

10.1016/j.csda.2008.03.005

中图分类号：

TP39 [计算机的应用];

学科分类号：

081203 ; 0835 ;

摘要：

We provide an assessment of the statistical distributions in Microsoft (R) Excel versions 97 through 2007 along with two competing spreadsheet programs, namely Gnumeric 1.7.11 and OpenOffice.org Calc 2.3.0. We find that the accuracy of various statistical functions in Excel 2007 range from unacceptably bad to acceptable but significantly inferior in comparison to alternative implementations. In particular, for the binomial, Poisson, inverse standard normal, inverse beta, inverse student's t, and inverse F distributions, it is possible to obtain results with zero accurate digits as shown with numerical examples. (C) 2008 Elsevier B.V. All rights reserved.

引用

页码：4579 / 4586

页数：8

共 50 条

[1] On the accuracy of statistical distributions in Microsoft Excel 2003
Knüsel, L
COMPUTATIONAL STATISTICS & DATA ANALYSIS, 2005, 48 (03) : 445 - 449
[2] On the accuracy of statistical procedures in Microsoft Excel 2007
McCullough, B. D.
Heiser, David A.
COMPUTATIONAL STATISTICS & DATA ANALYSIS, 2008, 52 (10) : 4570 - 4578
[3] On the accuracy of statistical distributions in Microsoft Excel 97
Knusel, L
COMPUTATIONAL STATISTICS & DATA ANALYSIS, 1998, 26 (03) : 375 - 377
[4] On the accuracy of statistical distributions in Microsoft Excel 97
Knusel, Leo
Computational Statistics and Data Analysis, 1998, 26 (03): : 375 - 377
[5] On the accuracy of statistical procedures in Microsoft Excel 2010
Melard, Guy
COMPUTATIONAL STATISTICS, 2014, 29 (05) : 1095 - 1128
[6] On the accuracy of statistical procedures in Microsoft Excel 2003
McCullough, BD
Wilson, B
COMPUTATIONAL STATISTICS & DATA ANALYSIS, 2005, 49 (04) : 1244 - 1252
[7] On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP
McCullough, BD
Wilson, B
COMPUTATIONAL STATISTICS & DATA ANALYSIS, 2002, 40 (04) : 713 - 721
[8] On the accuracy of statistical procedures in Microsoft Excel 97
McCullough, BD
Wilson, B
COMPUTATIONAL STATISTICS & DATA ANALYSIS, 1999, 31 (01) : 27 - 37
[9] On the accuracy of statistical procedures in Microsoft Excel 2010
Guy Mélard
Computational Statistics, 2014, 29 : 1095 - 1128
[10] Microsoft Office 2007之Excel 2007
刘丞志
个人电脑, 2007, (10) : 175 - 179

← 1 2 3 4 5 →