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.

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
15308068880515963694
true
Search Help Center
true
true
true
true
true
35
false
false