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.