# 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