GAMMA.INV (Probability, Alpha, Beta) GAMMA.INV (Probability; Alpha; Beta)
Probability
Number Number
The probability associated with the distribution.
Alpha
Number Number
The shape parameter of the distribution.
Beta
Number Number
The scale parameter of the distribution.
Returns the inverse of the cumulative GAMMA.DIST function. Given a probability, this function returns the value at which the cumulative Gamma distribution equals that probability.
Example
GAMMA.INV (0.86, 1, 1)
GAMMA.INV (0,86; 1; 1)
Returns roughly 2.0.