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

Want to practice GAMMA.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=GAMMA.DIST(x, alpha, beta, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe value; can't be negative.
alphaYesThe shape; must be greater than 0.
betaYesThe scale; must be greater than 0.
cumulativeYesTRUE 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.

B5fx=GAMMA.DIST(10,B2,B3,TRUE)
AB
1MeasureValue
2Jobs (alpha)3
3Hours per job (beta)2
4Mean total6
5Done within 10 h0.8753
=GAMMA.DIST(10,B2,B3,TRUE) Explain

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

Kyle Stott

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.