Returns the inverse of the gamma cumulative distribution for the specified probability, alpha and beta parameters.
Sample Usage
GAMMA.INV(0.5,4,2)
GAMMA.INV(A2,A3,A4)
Syntax
GAMMA.INV(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
GAMMA.INV(0.5,4,2) returns a value of 7.3441.
GAMMA.INV(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 GAMMA.INV or GAMMAINV to perform this function.