GAMMADIST (gamma distribution)

<< Click to Display Table of Contents >>

GAMMADIST (gamma distribution)

Note: GAMMADIST is supplemented by the new identical function GAMMA.DIST, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

GAMMADIST(X, Alpha, Beta, Cumulative)

Description:

This returns the probabilities of a gamma distributed random number.

X is the value whose probability is to be calculated. X must be ≥ 0.

Alpha and Beta are shape parameters of the function. They both have to be greater than zero.

You use the logical value Cumulative to specify which type of function will be returned:

FALSE: The probability density function is returned.

TRUE: The cumulative distribution function is returned.

See also:

GAMMA.DIST, GAMMA.INV/GAMMAINV, GAMMA, GAMMALN