Statistical

GAMMA.DIST Function in Excel

Returns the gamma distribution.

Syntax

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

Arguments

  • x (required): Value to evaluate
  • alpha (required): Shape parameter
  • beta (required): Scale parameter
  • cumulative (required): TRUE for CDF, FALSE for PDF

Examples

  • =GAMMA.DIST(2, 3, 2, TRUE) - Gamma CDF - Result: 0.323

GAMMA.DIST for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • #NUM! if parameters invalid

Use cases

  • Reliability analysis
  • Queuing theory
  • Statistical modeling

Frequently asked questions

  • What is the GAMMA function in Excel? GAMMA returns the gamma function value, a mathematical function that extends factorials to real numbers. It's fundamental in statistics, probability theory, and advanced mathematical calculations.
  • How is GAMMA related to factorials? For positive integers, GAMMA(n) = (n-1)!. So GAMMA(5) = 4! = 24. This extends factorials to non-integer values, useful in advanced statistical distributions.
  • When do I use the GAMMA function? Use GAMMA in advanced statistical calculations, probability distributions (like gamma and beta distributions), and mathematical modeling where factorial-like operations are needed for non-integers.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.