GAMMA.INV(probability, alpha, beta)

Returns the probability of getting greater than a particular value in a gamma distribution.

probabilityThe probability associated with the distribution.
alphaThe first parameter to the distribution.
betaThe second parameter to the distribution.

Remarks

* Added in Excel 2010.
* This function replaces the GAMMAINV function.
* The gamma distribution is a continuous distribution.
* For the Microsoft documentation refer to support.office.com

 A
1=GAMMA.INV(0.068094,9,2) = 10.00
2=GAMMA.INV(0.5,4,2) = 7.34
3=GAMMA.INV(0.068,4,2) = 3.04
4=GAMMA.INV(GAMMADIST(7,5,1,TRUE),5,1) = 7.00
5=GAMMA.INV(GAMMADIST(0.5,4,2,TRUE),4,2) = 0.50
6=GAMMA.INV(0.5,4,2) = 7.34
7=GAMMA.INV(0.5,-9,2) = #NUM!
8=GAMMA.INV(-2,9,2) = #NUM!
9=GAMMA.INV(-2,"some text",2) = #VALUE!

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top