# How to Use BETA.INV function in Google Sheets in 2020?

BETA.INV functionThe 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.3,5,1)
BETA.INV(A4,3,2,-1,1)BETA.INV(0.65,1.234,7,1,3)

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.

Categories Uncategorized