GAMMA.DIST function
GAMMA.DIST returns the gamma distribution at a value, which models positive, skewed quantities such as waiting times or claim sizes. It replaces the older GAMMADIST.
Example
Read it as a sentence: find the cumulative gamma distribution at D1 (which is empty, so counted as 0) with shape 3 and scale 2.
Excel shows 0
D
1
Data
Syntax
GAMMA.DIST(x, alpha, beta, cumulative)
-
x(required) - Value at which to evaluate; not negative.
-
alpha(required) - Shape parameter.
-
beta(required) - Scale parameter; 1 gives the standard gamma.
-
cumulative(required) - TRUE for cumulative probability, FALSE for density.
Returns: The gamma distribution value at x.
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.DIST(4,3,2,TRUE) | 0.323323584 | Working example |
=GAMMA.DIST(4,3,2,FALSE) | 0.135335283 | Other cumulative flag |
=GAMMA.DIST(4,3,2,0) | 0.135335283 | Cumulative as 0 |
=GAMMA.DIST("4",3,2,TRUE) | 0.323323584 | Text-number in first arg |
=GAMMA.DIST({4,4},3,2,TRUE) | 0.323323584 | Array in first arg (lifts, spills) |
=GAMMA.DIST(Data!D1,3,2,TRUE) | 0 | Blank cell as first arg |
=GAMMA.DIST("abc",3,2,TRUE) | #VALUE! | Non-numeric text in first arg |
=GAMMA.DIST(NA(),3,2,TRUE) | #N/A | Error in first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- beta is a scale (not a rate), so a rate lambda needs 1/lambda.
- Replaces the older GAMMADIST.
Where it works
- Excel
- GAMMA.DIST 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 .