Formulas and Functions

Chapter 10 Statistical Functions 237
BETAINV
The BETAINV function returns the inverse of the given cumulative beta distribution
probability value.
BETAINV(probability, alpha, beta, x-lower, x-upper)
 probability: A probability associated with the distribution. probability is a number
value and must be greater than 0 and less than 1.
 alpha: One of the shape parameters of the distribution. alpha is a number value
and must be greater than 0.
 beta: One of the shape parameters of the distribution. beta is a number value and
must be greater than 0.
 x-lower: An optional lower limit or bound for the specied x value or probability.
x-lower is a number value and must be less than or equal to the specied x value or
probability. If omitted, 0 is used.
 x-upper: An optional upper limit or bound for the specied x value or probability.
x-upper is a number value and must be greater than or equal to the specied x value
or probability. If omitted, 1 is used.
Examples
=BETAINV(0.5, 1, 2, 0.3, 2) returns 0.797918471982869.
=BETAINV(0.99, 1, 2, 0, 1) returns 0.9.
=BETAINV(0.1, 2, 2, 0, 2) returns 0.391600211318183.
Related Topics
For related functions and additional information, see:
“BETADIST” on page 236
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41