Updated: 9 August 2010

Use BETADIST to calculate the beta cumulative probability density function.

Where

B_{x}(*α,β*) is the incomplete beta function and

SELECT [wctStatistics].[wct].[BETADIST] (

<@X, float,>

,<@P, float,>

,<@Q, float,>

,<@A, float,>

,<@B, float,>)

is any real number. *@X *is an expression of type **float** or of a type that can be implicitly converted to **float**. *@X* is the value between @P and @Q at which to evaluate the function

is any real number. *@P *is an expression of type **float** or of a type that can be implicitly converted to **float**. *@A* is a parameter to the distribution

is any real number. *@Q *is an expression of type **float** or of a type that can be implicitly converted to **float**. *@Q* is a parameter to the distribution

is any real number. *@A *is an expression of type **float** or of a type that can be implicitly converted to **float**. *@A* is the lower bound to the distribution. If you enter NULL, *@A* defaults to zero

is any real number. *@B *is an expression of type **float** or of a type that can be implicitly converted to **float**. *@B* is the upper bound to the distribution. If you enter NULL *@B* defaults to to zero.

float

· If *@X* ≤ 0, BETADIST will return an error.

· If *@P* ≤ 0 or *@Q* ≤ 0, BETADIST will return an error

· If *@X*< *@A* or *@X* > *@B* or *@A* = *@B*, BETADIST will return an error.

· If you enter NULL for *@A* and *@B*, BETADIST will use zero and one.

select wct.BETADIST(7,5,10,6,8)

This produces the following result

----------------------

0.91021728515625

(1 row(s) affected)