| Article ID | Journal | Published Year | Pages | File Type |
|---|---|---|---|---|
| 417949 | Computational Statistics & Data Analysis | 2008 | 8 Pages |
Abstract
We provide an assessment of the statistical distributions in Microsoft® 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 tt, and inverse FF distributions, it is possible to obtain results with zero accurate digits as shown with numerical examples.
Related Topics
Physical Sciences and Engineering
Computer Science
Computational Theory and Mathematics
Authors
A. Talha Yalta,