The 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
GAMMAINVorGAMMA.INVto 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.
