David A. Paul wrote:> 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.An excellent source of information about the incompetence of Excel as a statistical package can be found on Jonathan Cryer's web page at http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf Some incredible howlers from their ``help'' pages are given, as are a number of useful references. (None from the biological literature however. If David Paul could dig up the reference mentioned by his biologist friend, it would be useful.) cheers, Rolf Turner rolf at math.unb.ca
Hej, just about excel -- excel 97 includ a kind of flying game (or what ever it should be called). There was a landscape you could fly above, and in the middle of it there were a screen with different names (authors?). You had to put the cursor on a particular cell and click a particular icon, AFAIR, in order to start the game. I have not hear about it later but I have tried it myself. That program is just full of surprises. Ott
At 10:43 2003-06-04 -0300, you wrote:>David A. Paul wrote: > > > 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.Here is another reference on Excel "features": http://www.rucares.org/Course/Excel.ppv Note that this presentation runs with PowerPoint 97 and the viewer in more recent versions, but that more recent versions of PowerPoint are not really compatible. Knut M. Wittkowski, PhD,DSc ------------------------------------------ The Rockefeller University, GCRC 1230 York Ave #121B, Box 322, NY,NY 10021 +1(212)327-7175, +1(212)327-8450 (Fax) kmw at rockefeller.edu http://www.rucares.org/statist/