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.

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
35
false
false