Excel functions / Statistics
GAMMA.DIST function
The gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
Syntax
=GAMMA.DIST(x, alpha, beta, cumulative)
Arguments
x: The value, 0 or more.alpha: The shape of the distribution.beta: Its scale. With 1 it is the standard gamma distribution.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.
When to use it
GAMMA.DIST works with the gamma distribution, for values that cannot be negative and lean to the right, such as waiting times and claim sizes.
Examples
Below 10 with alpha 9 and beta 2
A B C D E 1 x alpha beta 2 10.00001131 9 2 0.0681 In E2:
=GAMMA.DIST(A2, B2, C2, TRUE)→ 0.0681
Common mistakes
- Scale or rate. Beta is the scale. Some textbooks use a rate, which is 1 divided by beta.
GAMMA.DIST 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.DIST
- Danish: GAMMA.FORDELING
- Dutch: GAMMA.VERD.N
- Finnish: GAMMA.JAKAUMA
- French: LOI.GAMMA.N
- German: GAMMA.VERT
- Hungarian: GAMMA.ELOSZL
- Italian: DISTRIB.GAMMA.N
- Norwegian: GAMMA.FORDELING
- Polish: ROZKŁ.GAMMA
- Portuguese (Brazil): DIST.GAMA
- Portuguese (Portugal): DIST.GAMA
- Russian: ГАММА.РАСП
- Spanish: DISTR.GAMMA.N
- Swedish: GAMMA.FÖRD
- Turkish: GAMA.DAĞ
Also written as GAMMADIST.
Try GAMMA.DIST in the playground
Related functions
- GAMMA.INV: The value below which a given share of a gamma distribution falls.
- EXPON.DIST: The exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
- GAMMA: The gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!