[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
BETADIST ( x , alpha , beta [ , [ A ] , [ B ] ] )
Description: Computes the cumulative beta probability density function.
Arguments:
|
Name |
Type |
Description |
|
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:
BETADIST(0.5,1,2) results in 0.75
BETADIST(0.5,1,2,-4.5,7.3) results in 0.66791152
BETADIST(0.5,1,2,,2.3) results in 0.387523629
end example]