trying to prove out negbinomdist

Wed Jun 3 12:49:01 UTC 2020

Hi,
This might be an unusual question for this site.  But I cannot prove out the negative binomial distribution, by so called hard coding the function per LibreOffice docs….a jpg of that function is attached.  Does anyone have a clue. Though I will add…Microsoft Excel has the same problem.   I did search for its corresponding code in C++/H in libreoffice source…but that didn't help either…

=negbinomdist(1;14.4;.92)

=(FACT(1+14.4-1)/(FACT(1)*FACT(14.4-1)))*(power(.92;14.4)*power(1-.92;1))

Nick

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20200603/ecd005ee/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: negbinomdist.jpg
Type: image/jpeg
Size: 55334 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20200603/ecd005ee/attachment-0001.jpg>