Returns the inverse of the gamma cumulative distribution for the specified probability, alpha and beta parameters.
Sample Usage
GAMMAINV(0.5,4,2)
GAMMAINV(A2,A3,A4)
Syntax
GAMMAINV(probability, alpha, beta)
- probability - The probability at which to evaluate the function.
- alpha - A parameter to the distribution.
- beta - A parameter to the distribution.
Examples
GAMMAINV(0.5,4,2) returns a value of 7.3441.
GAMMAINV(A2,A3,A4) returns the inverse of the gamma cumulative distribution for the probability, alpha, and beta arguments in A2, A3 and A4.
Notes
- You can use GAMMAINV or GAMMA.INV to perform this function.