Documentation/Calc Functions/BETADIST

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

BETADIST

Category:

Statistical Analysis

Summary:

Returns a value of the probability density function or the cumulative distribution function for the beta distribution.

Syntax:

BETADIST(Number; Alpha; Beta [; Start [; End [; Cumulative]]])

Returns:

Returns a real number which is the beta function value for the given arguments. The function returns either a probability density function or cumulative distribution function which has a non-negative range, i.e. [0, +∞).

Arguments:

Number is a real number or a reference to the cell containing that number which has to be between Start and End at which to evaluate the function.

Alpha is a real number or a reference to the cell containing that number which is a parameter to the distribution.

Beta is a real number or a reference to the cell containing that number which is a parameter to the distribution.

Start is a real number or a reference to the cell containing that number which is the lower bound for Number.

End is a real number or a reference to the cell containing that number which is the upper bound for Number.

Cumulative can be 0 or False to calculate the probability density function. It can be any other value or True or omitted to calculate the cumulative distribution function.

  • If either of Alpha or Beta is negative or zero then the function returns an error value.
  • If either Number is not between Start and End or Start is greater than End the function returns an error value.
  • If Start is not specified, the default value 0 is used.
  • If End is not specified, the default value 1 is used.

Additional details:

For more details on Beta distribution, visit Wikipedia.

Examples:

Formula Description Returns
=BETADIST(0.75;3;4) returns beta probability density distribution(default) 0.96240234375
=BETADIST(2;3;4;1;3;TRUE()) returns beta cumulative distribution for true passed in Cumulative 0.65625
=BETADIST(-3.5,3,3,-4,-3,1) returns beta cumulative distribution 0.5
=BETADIST(0.75;-3;4) Alpha and Beta cannot be negative or zero so the function returns an error value Err:502

Related LibreOffice functions:

BETA.INV

BETA.DIST

BETAINV

ODF standard:

Section 6.18.7, part 2

Equivalent Excel functions:

BETADIST