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 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/BooleanLogical argument which defines the type of distribution to be calculated
Trueuses the cumulative distribution function
Falseuses the probability density function

Examples

GAMMADIST(#input!VALUE; #input!ALPHA; #input!BETA; false)

VALUE
ALPHA
BETACumulative valueGAMMADIST returns
632false0.112
632true0.5768

Common Errors

#NUM!-

Occurs if either:

  • The x value is less than 0
  • The numerator or denominator is less than 1
#VALUE!-Occurs if the argument type isn't numeric