Owner manual

Chapter 10 Statistical Functions 259

GAMMADIST

The GAMMADIST function returns the gamma distribution in the specied form.

GAMMADIST(non-neg-x-value, alpha, beta, form-type)

Â non-neg-x-value: The value at which you want to evaluate the function. non-neg-x-

value is a number value that must be greater than or equal to 0.

Â alpha: One of the shape parameters of the distribution. alpha is a number value

and must be greater than 0.

Â beta: One of the shape parameters of the distribution. beta is a number value and

must be greater than 0.

Â form-type: A value that indicates which form of the exponential function to provide.

cumulative form (TRUE or 1): Return the value of the cumulative distribution

function form.

probability density form (FALSE or 0): Return the value of the probability density

function form.

Examples

=GAMMADIST(0.8, 1, 2, 1) returns 0.329679953964361 (the cumulative distribution form).

=GAMMADIST(0.8, 1, 2, 0) returns 0.33516002301782 (the probability density form).