Updated: 9 August 2010

Use BETAI to calculate the incomplete beta function. The incomplete beta function is defined by:

SELECT [wctStatistics].[wct].[BETAI] (

<@A, float,>

,<@B, float,>

,<@X, float,>)

is any real number greater than or equal to zero. *@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 greater than or equal to zero. *@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.

is any real number greater than or equal to zero and less than or equal to one. *@X *is an expression of type **float** or of a type that can be implicitly converted to **float**.

float

· If *@A* ≤ 0 or *@B* ≤ 0, BETAI returns an error.

· If *@X* < 0 or *@X* > 1, BETAI returns an error.

· *@X* = 0 or *@X* = 1, BETAI = *@X*

· BETAI(@A, @B, @X) = BETADIST(@X, @A, @B, 0, 1)

select wct.BETAI(1, 5, .45)

This produces the following result

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

0.9496715625

(1 row(s) affected)

select wct.BETADIST(.45,1,5,0,1)

This produces the following result

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

0.9496715625

(1 row(s) affected)