BETA.DIST function

BETA.DIST(X, Alpha, Beta, IsCumulative, A?, B?) BETA.DIST(X; Alpha; Beta; IsCumulative; A?; B?)

X

Number or { Number }

The value at which to evaluate the function.

Alpha

Number or { Number }

A parameter to the distribution.

Beta

Number or { Number }

A parameter to the distribution.

IsCumulative

Logical or { Logical }

TRUE, which calculates the cumulative distribution function. The value FALSE, which would have calculated the probability density function, is not supported.

A

Number or { Number } (optional)

A lower bound for the x parameter. If omitted, the lower bound is assumed to be 0.

B

Number or { Number } (optional)

An upper bound for the x parameter. If omitted, the upper bound is assumed to be 1.

Returns

Number or { Number }

A value for a beta distribution.

Returns the cumulative distribution function or the probability density function of a beta distribution. The beta distribution is a family of continuous probability distributions, where the alpha and beta parameters control the shape of the distribution. The x parameter is the number at which the beta distribution is evaluated.

Example

BETA.DIST(1, 5, 3, TRUE, -2, 4)BETA.DIST(1; 5; 3; TRUE; -2; 4)

Returns roughly 0.23.