The GAMMAINV function returns the inverse gamma cumulative distribution. All arguments are number values.
GAMMAINV(probability, alpha, beta)
probability: The probability associated with the distribution. probability must be greater than 0 and less than 1.
alpha: One of the shape parameters of the distribution. alpha must be greater than 0.
beta: One of the shape parameters of the distribution. beta must be greater than 0.
Examples |
|---|
=GAMMAINV(0.8, 1, 2) returns 3.2188758248682. =GAMMAINV(0.8, 2, 1) returns 2.99430834700212. |