BETA.DIST (beta distribution)

<< Click to Display Table of Contents >>

BETA.DIST (beta distribution)

Syntax:

BETA.DIST(X, Alpha, Beta, Cumulative [, A, B])

Description:

Returns the (cumulative) beta distribution function.

X is the value to be evaluated.

Alpha and Beta are shape parameters of the function. They both have to be greater than zero.

Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative distribution function of the beta distribution is calculated. By entering the value FALSE, the density function of the beta distribution is calculated.

A and B (optional) are the lower and upper bound to the interval. If they are omitted, A is set to 0 and B is set to 1 (thus leading to a normal distribution).

X must be in the range A to B.

Note:

The BETA.DIST function supplements the previous BETADIST function with the additional argument Cumulative.

Compatibility notes:

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

Annotation:

The inverse function is BETA.INV

See also:

BETADIST, BETA.INV/BETAINV