This function returns the inverse of the gamma cumulative distribution.
Syntax
GAMMAINV(p,alpha,beta)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| p | Probability |
| alpha | Alpha parameter of the distribution |
| beta | Beta parameter of the distribution |
Remarks
This function calculates the inverse of the F probability distribution, so if p = GAMMADIST(x,...), then GAMMAINV(p,...) = x.
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
GAMMAINV(A3,3,4)
GAMMAINV(0.8902,R3C8,R3C9)
GAMMAINV(0.75,2,3) gives the result 8.0779035867
Version Available
This function is available in product version 1.0 or later.
See Also
GAMMADIST | GAMMALN | Statistical Functions