ADVERTISEMENT

Excel: BetaInv Function

---

In Excel, the BetaInv function returns the inverse of the cumulative beta probability density function.

The syntax for the BetaInv function is:

BetaInv( probability, alpha, beta, lower_bound, upper_bound )

probability is the probability for the beta distribution.

alpha is a distribution parameter.

beta is a distribution parameter.

lower_bound is optional. It is the lower bound to the interval of x. If this parameter is omitted, the BetaDist assumes that lower_bound is 0 and upper_bound is 1.

upper_bound is optional. It is the upper bound to the interval of x. If this parameter is omitted, the BetaDist assumes that lower_bound is 0 and upper_bound is 1.

Note:

If x < lower_bound, the BetaDist function will return the #NUM! error.

if x > upper_bound, the BetaDist function will return the #NUM! error.

If alpha <= 0, the BetaDist function will return the #NUM! error.

If beta <=0, the BetaDist function will return the #NUM! error.

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

=BetaInv(0.3, 7.5, 9, 1, 4)	would return 2.164759636
=BetaInv(0.75, 8, 9, 5, 10)	would return 7.761240005