/
GAMMADIST
GAMMADIST
Syntax
GAMMADIST( <number>, <number>, <number>; <boolean>)
Description
Returns the gamma distribution for a certain value with given parameters alpha and beta.
or
Returns the gamma density function or the cumulative distribution function for the gamma distribution. This function is frequently used to measure the degree of diversity between two data sets.
The function arguments are:
- x: The value for which the distribution should be computed (NUMERIC)
- Alpha: The alpha parameter (shape) of the exponential distribution (NUMERIC)
- Beta: The alpha parameter (scale) of the exponential distribution (NUMERIC)
- Cumulative: Constant indicating the form of the function. If true then the cumulative distribution function is used. If false then the probability mass function is used. (BOOLEAN)
Cumulative/Boolean | Logical argument which defines the type of distribution to be calculated |
---|---|
True | uses the cumulative distribution function |
False | uses the probability density function |
Examples
GAMMADIST(#input!VALUE; #input!ALPHA; #input!BETA; false)
VALUE | ALPHA | BETA | Cumulative value | GAMMADIST returns |
---|---|---|---|---|
6 | 3 | 2 | false | 0.112 |
6 | 3 | 2 | true | 0.5768 |
Common Errors
#NUM! | - | Occurs if either:
|
#VALUE! | - | Occurs if the argument type isn't numeric |
, multiple selections available,
Related content
GAMMADIST
GAMMADIST
More like this
GAMMADIST
GAMMADIST
More like this
EXPONDIST
EXPONDIST
More like this
WEIBULLDIST
WEIBULLDIST
More like this
EXPONDIST
EXPONDIST
More like this
WEIBULLDIST
WEIBULLDIST
More like this