Documentation/Calc Functions/BETA.DIST
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
BETA.DIST
Category:
Statistical Analysis
Summary:
Returns a value of the probability density function or the cumulative distribution function for the beta distribution.
Syntax:
BETA.DIST(Number; Alpha; Beta; Cumulative [; Start [; End]])
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 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 |
---|---|---|
=BETA.DIST(2;8;10;1;1;3) | returns beta cumulative distribution | 0.6854706 |
=BETA.DIST(2;8;10;0;1;3) | returns beta probability density distribution | 1.4837646 |
=BETA.DIST(-3.5,3,3,1,-4,-3) | returns beta cumulative distribution | 0.5 |
=BETA.DIST(2;0;-3;0;1;3) | Alpha and Beta should greater than 0 so the function returns an error value | Err:502 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
BETA.DIST