This function returns the inverse of the gamma cumulative distribution.
GAMMA.INV(p,alpha,beta)
This function has these arguments:
| Argument | Description |
|---|---|
| p | Probability |
| alpha | Alpha parameter of the distribution |
| beta | Beta parameter of the distribution |
This function calculates the inverse of the F probability distribution, so if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. The standard gamma distribution is returned if beta = 1.
Accepts numeric data for all arguments. Returns numeric data.
GAMMA.INV(A3,3,4)
GAMMA.INV(0.8902,R3C8,R3C9)
GAMMA.INV(0.75,2,3) gives the result 8.077903586669088
This function is available in Spread for Windows Forms 11.0 or later.