Accuracy of funtions in VBA and Excel

[Howard Kaikow]

Are there any studies of the accuracy of the algorithms used by VBA
functions and by Excel functions?

--
http://www.standards.com/; Programming and support for Word macros,
including converting from WordBasic to VBA; Technical reviewing; Standards;
Product functional/design/specifications
------------------------------------------------

[Marc Schwartz]

"Howard Kaikow" <kai...@standards.com> wrote in message
news:amjdoe$iep$1...@pyrite.mv.net...

> Are there any studies of the accuracy of the algorithms used by VBA
> functions and by Excel functions?

http://www.npl.co.uk/ssfm/ssfm1/validate/testing/excel.html

http://www.elsevier.nl/gej-ng/10/15/38/37/25/27/article.pdf

http://www.pages.drexel.edu/~bdm25/ (Several papers on Excel listed)

http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf

http://hesweb1.med.virginia.edu/biostat/teaching/clinicians/excel.hazards.tx
t

http://www.agresearch.cri.nz/Science/Statistics/exceluse1.htm

This is likely to be incomplete, but should be a start. From memory, the
"majority" of the issues are with the continuous distributions. From past
personal experience, the discrete functions do well, but seem to fail when
larger datasets are used (ie. n > 1000) in many cases.

HTH.

Marc

[Howard Kaikow]

Thanx.

Those will be a good start.

--
http://www.standards.com/; Programming and support for Word macros,
including converting from WordBasic to VBA; Technical reviewing; Standards;
Product functional/design/specifications
------------------------------------------------

"Marc Schwartz" <MSchwartz@-REMOVE.TO.REPLY-mn.rr.com> wrote in message
news:FXkj9.16160$8K4.1...@twister.rdc-kc.rr.com...