ADVERTISEMENT

Excel: BetaDist Function

---

In Excel, the BetaDist function returns the cumulative beta probability density function.

The syntax for the BetaDist function is:

BetaDist( x, alpha, beta, lower_bound, upper_bound )

x is the value between A and B.

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:

=BetaDist(3, 7.5, 9, 1, 4)	would return 0.960370937
=BetaDist(7.5, 8, 9, 5, 10)	would return 0.598190307