# Documentation/Calc Functions/BETAINV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

BETAINV

## Category:

Statistical Analysis

## Summary:

Returns the inverse of the cumulative beta probability density function.

## Syntax:

BETAINV(**Number**; **Alpha**; **Beta** [; **Start** [; **End**]])

## Returns:

Returns a real number such that if Number = BETADIST(P;A;B;S;E;TRUE()), then BETAINV(Number;A;B;S;E) = P.

## Arguments:

**Number** is a real number or a reference to the cell containing that number which is the probability associated with the beta distribution function so it is between 0(inclusive) and 1(inclusive).

**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 the result of this function.

**End** is a real number or a reference to the cell containing that number which is the upper bound for the result of this function.

- If either of
**Alpha**or**Beta**is negative or zero then the function returns an error value. - If
**Start**is greater than**End**the function returns an error value. - If
**Number**is less than 0 or greater than 1, then 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 Inverted Beta distribution, visit **Wikipedia**.

## Examples:

Formula | Description | Returns |
---|---|---|

=BETAINV(0.5;5;10) | The function calculates the inverse of the cumulative beta probability density function | 0.325751155286213 |

=BETAINV(0.5;3;4;3;4) | The function calculates the inverse of the cumulative beta probability density function. This can be alternatively considered as =BETADIST(3.42140719069071;3;4;3;4;TRUE()) gives 0.5 | 3.42140719069071 |

=BETAINV(3.5,3,4,3,4) | The Number is not between 0 and 1 so the function returns an error value |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

BETAINV