[R] Rounding problem R vs Excel

[Alexander Ploner]

> 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