GAMMAINV
Name
Gamma distribution
Description
Returns the inverse of the gamma cumulative distribution.
Syntax
GAMMAINV(p,alpha,beta)
Remarks
This function has the following 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.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
GAMMAINV(A3,3,4)
GAMMAINV(0.8902,R3C8,R3C9)
GAMMAINV(0.75,2,3)=8.0779035867