BETADIST
Syntax:
BETADIST ( x , alpha , beta [ , [ A ] , [ B ] ] )
Description: Computes the cumulative beta probability density function.
Arguments:
Name |
Type |
Description |
---|---|---|
x |
number |
The value between A and B at which to evaluate the function. |
alpha |
number |
A parameter of the distribution. |
beta |
number |
A parameter of the distribution. |
A |
number |
The lower bound to the interval of x. If omitted, the lower bound is 0. |
B |
number |
The upper bound to the interval of x. If omitted, the upper bound is 1. |
Return Type and Value: number – The cumulative beta probability density function.
However, if
alpha or beta ≤ 0,
#NUM!
is returned.x < A, x > B, or A = B,
#NUM!
is returned.
example: