Hi again Sam, Sorry for not replying sooner. I have been ignoring everything for a while to work on the AMMP analysis tool and the continuing saga of migrating the legacy AMMP data. Our consultant has written some programs that take a VERY long time to run :(
Anyway, I now know Java and a certain amount of JSP. I hope to be able to get around to this soon. It is all a bit hard now with our data partially migrated. Prod me again in the near future if you haven't heard from me. Dave On Wed, Jun 04, 2003 at 04:54:26PM +0200, = Sam Clark = wrote: > Wow!! Not the first time MS products have done something > weird. Excel and Access and SQL Server all differ on how > they store dates internally, and this also leads to > problems - mainly in compatibility between them and their > date functions. Did quite a bit of reading on it a while > ago but can't dig up references now. > > David, I'm also wondering if you have a chance if you could > prep those data files I emailed you about a while ago. I'd > like to work our manuscript into something submittable in > the next few months. > > Thanks, > > - S. > > >Date: Wed, 4 Jun 2003 17:30:04 +0000 > >From: <[EMAIL PROTECTED]> > >Subject: [R] Rounding problem R vs Excel > >To: [EMAIL PROTECTED], [EMAIL PROTECTED], Nigel Unwin > <[EMAIL PROTECTED]>, [EMAIL PROTECTED], Greg Kabadi > <[EMAIL PROTECTED]> > > > >This discussion from the R-help mailing list might be of > interest to > >you folks. It was started when someone tried this in Excel: > > > >0.5 - 0.4 - 0.1 > > > >and > > > >(0.5 - 0.4 - 0.1) > > > >They give different results. Try formatting the cells to > 20 decimal > >places or multiplying the results in the next cells by > >1,000,000,000,000,000,000 > > > >Dave > > > > > 20-OP > >________________ > >Date: 04 Jun 2003 08:53:36 -0500 > >From: Marc Schwartz <[EMAIL PROTECTED]> > >Subject: RE: [R] Rounding problem R vs Excel > >To: "Paul, David �A" <[EMAIL PROTECTED]> > >Cc: [EMAIL PROTECTED], "'Duncan Murdoch'" > <[EMAIL PROTECTED]> > > > >On Wed, 2003-06-04 at 08:09, Paul, David A 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. > >> > >> -david paul > > > > > >There is a series of articles here: > > > >http://www.stat.uni-muenchen.de/~knuesel/elv/accuracy.html > > > > > >In addition, there are additional references on Excel > specifically: > > > > > >On the accuracy of statistical procedures in Microsoft > Excel 2000 and > >Excel XP > >B.D. McCullough and B. Wilson, (2002), Computational > Statistics & Data > >Analysis, 40, pp 713 - 721 > >http://www.elsevier.com/gej- > ng/10/15/38/85/51/28/abstract.html > > > > > >On the accuracy of statistical procedures in Microsoft > Excel ???97 > >B.D. McCullough and B. Wilson, (1999), Computational > Statistics & Data > >Analysis, 31, pp 27-37 > >http://www.elsevier.com/gej-ng/10/15/38/37/25/27/article.pdf > > > > > >Problems with using Microsoft Excel for statistics > >J.D. Cryer, (2001), presented at the Joint Statistical > Meetings, > >American Statistical Association, 2001, Atlanta Georgia > >at http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf > > > > > >Use of Excel for statistical analysis > >Neil Cox, (2000), AgResearch Ruakura > >at > http://www.agresearch.cri.nz/Science/Statistics/exceluse1.htm > > > > > >Using Excel for statistical data analysis > >Eva Goldwater, (1999), Univ. of Massachusetts Office of > Information > >Technology > >http://www.umass.edu/acco/statistics/handout/excel.html > > > > > >Statistical analysis using Microsoft Excel > >Jeffrey Simonoff, (2002) > >at > http://www.stern.nyu.edu/~jsimonof/classes/1305/pdf/excelreg. > pdf > > > > > >Testing the Intrinsic Functions of Excel > >National Physical Laboratory, UK > >http://www.npl.co.uk/ssfm/ssfm1/validate/testing/excel.html > > > > > > > >There are also some general articles on several stats > applications by > >McCullough. > > > >http://www.amstat.org/publications/tas/mccull-1.pdf > >http://www.amstat.org/publications/tas/mccull.pdf > > > > > >It has been some time since I looked at many of these > papers, but if my > >memory is correct, in general, not much has changed in > Excel since "97". > >However, from McCullough's most recent article: > > > >"The problems that rendered Excel 97 unfit for use as a > statistical > >package have not been fixed in either Excel 2000 or Excel > 2002 (also > >called "Excel XP"). Microsoft attempted to fix errors in > the standard > >normal random number generator and the inverse normal > function, and in > >the former case actually made the problem worse." > > > > > >Many of the above articles have an overlap on references, > some > >published, some are online resources or lecture notes. > > > > > >HTH, > > > >Marc Schwartz > > > >______________________________________________ > >[EMAIL PROTECTED] mailing list > >https://www.stat.math.ethz.ch/mailman/listinfo/r-help > [EMAIL PROTECTED] > mobile: +27 (0)73 154-2069 -- Dave Whiting Dar es Salaam, Tanzania ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
