Author: Oscar Cronquist Article last updated on October 24, 2018

The GAMMA.DIST function calculates the gamma often used in queuing analysis (probability statistics) that may have a skewed distribution.

This function was introduced in Excel 2010 and has replaced the GAMMADIST function.

Formula in cell C7:

=GAMMA.DIST(C3,C4,C5,C6)

Excel Function Syntax

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

Arguments

x Required.
alpha Required.
beta Required. 1 returns the standard gamma distribution.
cumulative Required. A boolean value.
TRUE - cumulative distribution function
FALSE - probability density function

Comments

The GAMMA.DIST function returns

  • #VALUE! error value if alpha, beta or x is non-numeric.
  • #NUM! error value if:
    • x < 0 (zero)
    • alpha <= 0 (zero)
    • beta <= 0 (zero)

The equation to calculate the gamma probabiltiy density function:

The standard gamma probability function: