GAMMA.DIST Function
Returns the gamma distribution — for skewed, positive quantities such as waiting times.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
The gamma distribution models positive, right-skewed amounts: total time for several jobs, rainfall, insurance claims. alpha (shape) and beta (scale) set its form; the mean is alpha × beta.
The time until the alpha-th random event, when events happen on average every beta units, follows a gamma distribution.
TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The value; can't be negative. |
| alpha | Yes | The shape; must be greater than 0. |
| beta | Yes | The scale; must be greater than 0. |
| cumulative | Yes | TRUE for the cumulative probability, FALSE for the density (height of the curve). |
Examples
Example 1 — Three repairs done within 10 hours?
Each repair takes on average 2 hours (exponentially distributed). The total for three repairs is gamma with alpha 3, beta 2.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Jobs (alpha) | 3 |
| 3 | Hours per job (beta) | 2 |
| 4 | Mean total | 6 |
| 5 | Done within 10 h | 0.8753 |
About an 88% chance all three are finished within 10 hours.
Common mistakes
- #NUM! x is negative, or alpha or beta is 0 or negative.
- Scale, not rate. Excel's beta is the scale (average time per event). If you know a rate, use 1 ÷ rate.
Notes
- GAMMA.DIST replaces the older GAMMADIST function.
- Related functions: GAMMA.INV, EXPON.DIST, CHISQ.DIST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.