Excel functions / Statistics
GAMMA.INV function
The value below which a given share of a gamma distribution falls.
Syntax
=GAMMA.INV(probability, alpha, beta)
Arguments
probability: A probability, between 0 and 1.alpha: The shape of the distribution.beta: Its scale.
When to use it
GAMMA.INV gives the value below which a share of a gamma distribution falls.
Examples
Undo GAMMA.DIST
A B C D E 1 p alpha beta 2 0.068094 9 2 10.0000 In E2:
=GAMMA.INV(A2, B2, C2)→ 10.0000
Common mistakes
- Probability 1. A probability of 1 has no finite answer: #NUM!.
GAMMA.INV in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: GAMMA.INV
- Danish: GAMMA.INV
- Dutch: GAMMA.INV.N
- Finnish: GAMMA.JAKAUMA.KÄÄNT
- French: LOI.GAMMA.INVERSE.N
- German: GAMMA.INV
- Hungarian: GAMMA.INVERZ
- Italian: INV.GAMMA.N
- Norwegian: GAMMA.INV
- Polish: ROZKŁ.GAMMA.ODWR
- Portuguese (Brazil): INV.GAMA
- Portuguese (Portugal): INV.GAMA
- Russian: ГАММА.ОБР
- Spanish: INV.GAMMA
- Swedish: GAMMA.INV
- Turkish: GAMA.TERS
Also written as GAMMAINV.
Try GAMMA.INV in the playground
Related functions
- GAMMA.DIST: The gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.