The accuracy of statistical distributions in Microsoft®Excel 2007

Authors:
A. Talha Yalta
Affiliations:
TOBB University of Economics and Technology, Sogutozu Caddesi No: 43, Sogutozu, 06560, Ankara, Turkey
Venue:
Computational Statistics & Data Analysis
Year:
2008

Citing 7
Cited 6

On the accuracy of the statistical distributions in GAUSS

Computational Statistics & Data Analysis
On the accuracy of statistical distributions in Microsoft Excel 97

Computational Statistics & Data Analysis
On the accuracy of statistical procedures in Microsoft Excel 97

Computational Statistics & Data Analysis
On the reliability of Microsoft Excel XP for statistical purposes

Computational Statistics & Data Analysis
On the accuracy of statistical procedures in microsoft Excel 2000 and Excel XP

Computational Statistics & Data Analysis
A comparative study of the reliability of nine statistical software packages

Computational Statistics & Data Analysis
On the accuracy of statistical procedures in Microsoft Excel 2003

Computational Statistics & Data Analysis

Editorial: Special section on Microsoft Excel 2007

Computational Statistics & Data Analysis
Teaching statistics with Excel 2007 and other spreadsheets

Computational Statistics & Data Analysis
How accurate are the extremely small P-values used in genomic research: An evaluation of numerical libraries

Computational Statistics & Data Analysis
Polynomial Trendline function flaws in Microsoft Excel

Computational Statistics & Data Analysis
Should Economists Use Open Source Software for Doing Research?

Computational Economics
Quantitative thermodynamic predication of interactions between nucleic acid and non-nucleic acid species using Microsoft excel

Computer Methods and Programs in Biomedicine

Quantified Score

Hi-index	0.03

Visualization

Abstract

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.