Skip to main content

GAMMA.INV function

The GAMMA.INV function is one of the statistical functions. It is used to return the inverse of the gamma cumulative distribution.

Syntax​

GAMMA.INV(probability, alpha, beta)

The GAMMA.INV function has the following arguments:

ArgumentDescription
probabilityThe probability associated with the gamma distribution. A numeric value greater than 0 but less than 1.
alphaThe first parameter of the distribution, a numeric value greater than 0.
betaThe second parameter of the distribution, a numeric value greater than 0. If beta is 1, the function returns the standard gamma distribution.

Notes​

How to apply the GAMMA.INV function.

Examples​

The figure below displays the result returned by the GAMMA.INV function.

GAMMA.INV Function