GAMMAINV

Definition: GAMMAINV is a function that returns the inverse of the gamma cumulative distribution for a specified set of parameters.

Syntax: =GAMMAINV(probability, alpha, beta)

Situation: This formula is suitable when you need to find the inverse of the gamma cumulative distribution for a specified set of parameters.

Example: If you have a probability of 0.5 and parameters alpha=2 and beta=3, the inverse of the gamma distribution can be found using the formula =GAMMAINV(0.5, 2, 3), which returns 2.101.