Message-ID: <JJEBKFOIJAKFKJKPEKIFCEHMCCAA.Alexander.Ploner@mep.ki.se>
Date: 2003-06-04T13:40:09Z
From: Alexander Ploner
Subject: Rounding problem R vs Excel
In-Reply-To: <940250A9EB37A24CBE28D858EF077749136DC3@ws-bco-mse3.milky-way.battelle.org>
> I don't have the reference, but a biologist friend of mine
> once showed me a refereed journal article that purported
> to demonstrate numerical errors made by MSExcel. This
> would have been Excel97 or Excel2000... In any case, the
> journal's scope was biological in nature and the article
> was of interest since Excel is heavily used in that community.
@ARTICLE{McCull99,
AUTHOR = {McCullough, B. and Wilson, B.},
TITLE = {On the Accuracy of Statistical Procedures in Microsoft Excel
97},
JOURNAL = "Comp. Stat. \& Data Anal.",
VOLUME = 31,
NUMBER = 1,
YEAR = 1999,
PAGES = {27-37}
}
I seem to remember that there was a follow-up article (note?) in CSDA
regarding the persistence of the problems in Excel 2000.
alex
Alexander.Ploner at mep.ki.se
Phone: 46-8-524-82329
Fax : 46-8-314975
Medical Epidemiology & Biostatistics
Karolinska Institutet,
P.O. Box 281, SE-171 77 Stockholm