GAMMA.DIST (gamma distribution)

<< Click to Display Table of Contents >>

GAMMA.DIST (gamma distribution)

Syntax:

GAMMA.DIST(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.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.

Additional info:

The inverse function is GAMMA.INV

See also:

GAMMADIST, GAMMA.INV/GAMMAINV, GAMMA, GAMMALN