This function returns the inverse of the gamma cumulative distribution.
GAMMAINV(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 = GAMMADIST(x,...), then GAMMAINV(p,...) = x.
Accepts numeric data for all arguments. Returns numeric data.
GAMMAINV(A3,3,4)
GAMMAINV(0.8902,R3C8,R3C9)
GAMMAINV(0.75,2,3) gives the result 8.0779035867