BETADIST

Description Computes the cumulative beta distribution.

Syntax BETADIST(x, alpha, beta [, A] [, B])

Argument Description

x The value at which the function will be evaluated. It must be a number larger than A and smaller than B.

alpha The parameter to the beta function. It must be a number greater than zero.

beta A second parameter to the beta function. It must be a number greater than zero.

[A] Optional. The lower bound to the interval of x. It must be a number smaller than x and B. If this argument is omitted, 0 is used.

[B] Optional. The upper bound to the interval of x. It must be a number larger than x and A. If this argument is omitted, 1 is used.

Argument	Description
x	The value at which the function will be evaluated. It must be a number larger than A and smaller than B.
alpha	The parameter to the beta function. It must be a number greater than zero.
beta	A second parameter to the beta function. It must be a number greater than zero.
[A]	Optional. The lower bound to the interval of x. It must be a number smaller than x and B. If this argument is omitted, 0 is used.
[B]	Optional. The upper bound to the interval of x. It must be a number larger than x and A. If this argument is omitted, 1 is used.

Equation where

Examples This function returns 0.999023437:

BETADIST(0.5, 1, 10)

This function returns 0.000976563:

BETADIST(0.5, 10, 1)

This function returns 1:

BETADIST(0.5, 1000, 2000)

This function returns 0.685470581:

BETADIST(2, 8, 10, 1, 3)