RE: [R] Rounding problem R vs Excel

About this list Date view Thread view Subject view Author view Attachment view

From: Alexander Ploner (Alexander.Ploner@mep.ki.se)
Date: Wed 04 Jun 2003 - 23:40:09 EST


Message-id: <JJEBKFOIJAKFKJKPEKIFCEHMCCAA.Alexander.Ploner@mep.ki.se>


> 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@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

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help


About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Tue 01 Jul 2003 - 09:11:52 EST