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

X

Number Number

The value at which to evaluate the function.

Alpha

Number Number

A parameter to the distribution.

Beta

Number Number

A parameter to the distribution.

IsCumulative

Logical Logical

TRUE to return the probability that a value is at most the value of the X parameter (the cumulative distribution function). FALSE to return the height of the distribution's curve at that value (the probability density function), which is useful for plotting the distribution but is not itself a probability.

A

Number Number (optional)

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

B

Number Number (optional)

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

Returns

Number 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.

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell