Documentation/Calc Functions/GAMMADIST

Function name:
GAMMADIST

Category:
Statistical Analysis

Summary:
Calculates the value of the probability density function or the cumulative distribution function for the gamma distribution.

Syntax:
GAMMADIST(Number; Alpha; Beta[; C])

Returns:
Returns a real number which is a value of the probability density function or the cumulative distribution function for the Gamma distribution. Its value ranges from 0 to 1, i.e. [0,1].

Arguments:
Number is a real number or a reference to the cell containing that number for which the gamma distribution is to be calculated.

Alpha is a real number or a reference to the cell containing that number which is the alpha (shape) parameter for the gamma distribution.

Beta is a real number or a reference to the cell containing that number which is the beta (rate) parameter for the gamma distribution.

C can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function. By default, its value is 0.


 * If either of Alpha or Beta is negative or zero then the function returns an error value.
 * If Number is negative then the function returns an error value.

Additional details:
If C is FALSE, GAMMADIST returns 0 if x=0, an error value if x<0 and the probability density function value
 * The formula for GAMMADIST is:

If C is TRUE, GAMMADIST returns 0 if x=0, an error value if x<0 and the cumulative distribution function value
 * For more details on gamma distribution, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/GAMMA.INV GAMMA.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/GAMMA.DIST GAMMA.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/GAMMAINV GAMMAINV]

ODF standard:
Section 6.18.31, part 2

Equivalent Excel functions:
GAMMADIST