# BETA.INV function

The BETA.INV function returns the value of the inverse beta distribution function for a given probability.

## Parts of a BETA.INV function

`BETA.INV(probability, alpha, beta, lower_bound, upper_bound)`

 Part Description Notes `probability` The probability at which to evaluate the function. Must be between 0 and 1, inclusive. `alpha` The first shape parameter of the distribution. Must be positive. `beta` The second shape parameter of the distribution. Must be positive. `lower_bound` Lower bound of the original beta distribution’s domain. Default value is 1. `upper-bound` Upper bound of the original beta distributions’s domain. Default value is 1.

## Sample formulas

```BETA.INV(0.65,1.234,7,1,3) BETA.INV(0.3,5,1) BETA.INV(A4,3,2,-1,1)```

## Example

If you want to know the value of inverse cumulative beta function at probability 0.13, parameterize it by alpha = 5, beta = 1, and domain [-1, 1].

 A B C D E F G 1 Formula Probability Alpha Beta Lower bound Upper bound Result 2 `=BETA.INV(0.13, 5, 1, -1, 1)` 0.13 5 1 -1 1 0.33

## Related functions

BETA.DIST: The BETA.DIST function returns the probability of a given value as defined by the beta distribution function.