GAMMA.INV function
GAMMA.INV returns the value at which the gamma distribution reaches a given cumulative probability. It is the inverse of GAMMA.DIST and may return #N/A for extreme inputs.
Example
Read it as a sentence: find the gamma distribution value for a probability taken from D1 (which is empty, so counted as 0) with shape 3 and scale 2.
Excel shows 0
D
1
Data
Syntax
GAMMA.INV(probability, alpha, beta)
-
probability(required) - Cumulative probability between 0 and 1.
-
alpha(required) - Shape parameter.
-
beta(required) - Scale parameter.
Returns: The x value whose gamma cumulative probability equals the input.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=GAMMA.INV(0.5,3,2) | 5.348120627 | Working example |
=GAMMA.INV("0.5",3,2) | 5.348120627 | Text-number in first arg |
=GAMMA.INV({0.5,0.5},3,2) | 5.348120627 | Array in first arg (lifts, spills) |
=GAMMA.INV(0,3,2) | 0 | Probability 0 |
=GAMMA.INV(Data!D1,3,2) | 0 | Blank cell as first arg |
=GAMMA.INV("abc",3,2) | #VALUE! | Non-numeric text in first arg |
=GAMMA.INV(NA(),3,2) | #N/A | Error in first arg |
=GAMMA.INV(1,3,2) | #NUM! | Probability 1 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Iterative, so extreme inputs can give #N/A.
- beta is a scale, as in GAMMA.DIST.
Where it works
- Excel
- GAMMA.INV arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .