Formulas and Functions

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
BETADIST
The BETADIST function returns the cumulative beta distribution probability value.
BETADIST(x-value, alpha, beta, x-lower, x-upper)
 x-value: The x value at which you want to evaluate the function. x-value is a number
value and must be in the range 0 to 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
=BETADIST(0.5, 1, 2, 0.3, 2) returns 0.221453287197232.
=BETADIST(1, 1, 2, 0, 1) returns 1.
=BETADIST(0.1, 2, 2, 0, 2) returns 0.00725.
Related Topics
For related functions and additional information, see:
“BETAINV” on page 237
“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
236 Chapter 10 Statistical Functions