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 |
| 2 | =GAMMA.INV(0.3, 5, 1) |
Related function
- GAMMA.DIST: The GAMMA.DIST function calculates the gamma distribution, a 2-parameter continuous probability distribution.