GAMMA.INV functionThe GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability, alpha, and beta parameters.
Parts of a GAMMA.INV formula
GAMMA.INV(probability, alpha, beta)
Part
Description
Notes
probability
The input to the inverse gamma distribution function.
Must be between 0 and 1.
alpha
The shape of the gamma distribution.
Must be positive.
The sign of significance is ignored.
beta
The scale of the gamma distribution.
Must be positive.
Sample formulas
GAMMA.INV(0.65, 4, 2)
GAMMA.INV(C3, 3, 2)
Note
You can use GAMMAINV or GAMMA.INV to perform this function.
Example
A
B
1
Formula
Result
2
=GAMMA.INV(0.3, 5, 1)
3.633609083
Related function
GAMMA.DIST: The GAMMA.DIST function calculates the gamma distribution, a 2-parameter continuous probability distribution.