
Hi,
When I try using InverseGamma.CDF and the inbuilt excel forumla I could see difference in values.
Ex:InverseGamma.CDF(2,3,4) has different value then that of Excel inbuilt formula Gamma.Inv(4,2,3, true).
Can you provide if anything needs to be done for the same.
Thanks for your help in advance.


Coordinator
Dec 30, 2013 at 12:58 PM

Hi
Gamma and InverseGamma are different distributions. To my understanding Excel does not support the inverse gamma distribution.
If you're looking for the inverse CDF of the gamma distribution though (Excel: GAMMAINV), I've just added Gamma.InvCDF that will be part of the next alpha release and should work as expected (but again parametrized with rate instead of scale when using the
static functions).
Since there have been quite a few Excelrelated queries I've also added a new static
ExcelFunctions class that provides Excelcompatible functions, e.g.
ExcelFunctions.GAMMAINV .
Thanks,
Christoph



Hi,
Can you let us know when would the alpha release be available.
Regards,
Krishnaprasad J.


Coordinator
Dec 31, 2013 at 7:49 AM

Hi,
It is already available, in the
NuGet gallery.
Thanks,
Christoph

