# BETAINV

## Content

This function calculates the inverse of the cumulative beta distribution function.

## Syntax

`BETAINV( prob, alpha, beta, lower, upper )`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *prob* | Probability of the distribution |
| *alpha* | Alpha parameter of the distribution |
| *beta* | Beta parameter of the distribution |
| *lower* | [Optional] Lower bound of the interval for x; 0 if omitted |
| *upper* | [Optional] Upper bound of the interval for x; 1 if omitted |

## Remarks

If you omit values for *upper* and *lower*, the calculation uses the standard cumulative beta distribution so that *lower* is zero and *upper* is one.

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`BETAINV(0.75,B3,C3,2,4)`

`BETAINV(0.75,R3C2,R3C3,2,4)`

`BETAINV(0.75,9,12,2,4)` gives the result 3.0011968805