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.