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.
