Excel 2000 error in computing Poisson

[John Baker]

Knowledge base article 828130 describes bug in Excel
calculation of Poisson. Does anyone have a simple way to
compute Poisson for values 100 to 2000 and 1000, like
Poisson(200,1000,false)?

It seems like Microsoft may not be planning on fixing the
bug for Excel 2000 and for Mac OSX, only for Excel 2003.

 

[Barry N. Wainwright]

Knowledge base article 828130 describes bug in Excel
calculation of Poisson. Does anyone have a simple way to
compute Poisson for values 100 to 2000 and 1000, like
Poisson(200,1000,false)?

It seems like Microsoft may not be planning on fixing the
bug for Excel 2000 and for Mac OSX, only for Excel 2003.

It is likely that the fix will propagate down to the mac, since the mac
shares much of the calculation engine with the windows version.

Given the sensitivity of this core piece of code in Excel, you can
understand MS's cautious approach in firing off 'quick fixes' to bugs in the
engine, but this does not mean they consider the bugs unimportant!

--
Barry Wainwright
Microsoft MVP (see http://mvp.support.microsoft.com for details)
Seen the Entourage FAQ pages? - Check them out:
<http://www.entourage.mvps.org/toc.html>

Please post responses to this newsgroup. If I ask you to contact me
off-list, remove '.INVALID' from email address before replying.

 

[JE McGimpsey]

Knowledge base article 828130 describes bug in Excel
calculation of Poisson. Does anyone have a simple way to
compute Poisson for values 100 to 2000 and 1000, like
Poisson(200,1000,false)?

It seems like Microsoft may not be planning on fixing the
bug for Excel 2000 and for Mac OSX, only for Excel 2003.

See Jerry Lewis' answer in microsoft.public.excel.misc:

news:40151936.4080901@no_e-mail.com

 

[John Baker]

Thanks all! It looks like VB is the answer for now anyway.