Please use this identifier to cite or link to this item: https://hdl.handle.net/20.500.11851/7596
Title: The accuracy of statistical distributions in Microsoft (R) Excel 2007
Authors: Yalta, Abdullah Talha
Keywords: [No Keywords]
Issue Date: 2008
Publisher: Elsevier Science Bv
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. (C) 2008 Elsevier B.V. All rights reserved.
URI: https://doi.org/10.1016/j.csda.2008.03.005
https://hdl.handle.net/20.500.11851/7596
ISSN: 0167-9473
Appears in Collections:İktisat Bölümü / Department of Economics
Scopus İndeksli Yayınlar Koleksiyonu / Scopus Indexed Publications Collection
WoS İndeksli Yayınlar Koleksiyonu / WoS Indexed Publications Collection

Show full item record

CORE Recommender

SCOPUSTM   
Citations

34
checked on Jul 13, 2022

WEB OF SCIENCETM
Citations

32
checked on Jul 14, 2022

Page view(s)

16
checked on Aug 15, 2022

Google ScholarTM

Check

Altmetric


Items in GCRIS Repository are protected by copyright, with all rights reserved, unless otherwise indicated.