Accuracy of funtions in VBA and Excel

1 view
Skip to first unread message

Howard Kaikow

unread,
Sep 21, 2002, 11:35:08 PM9/21/02
to
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

unread,
Sep 22, 2002, 11:01:57 AM9/22/02
to
"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

unread,
Sep 22, 2002, 11:11:42 AM9/22/02
to
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...

Reply all
Reply to author
Forward
0 new messages