[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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.

A, B, or 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]