Updated: 31 July 2010

Use BINOMINV to calculate the value of number of success in the binomial distribution given the cumulative distribution function.

The cumulative distribution function is:

SELECT [wctStatistics].[wct].[BINOMINV] (

<@P, float,>

,<@Trials, float,>

,<@Probability_s, float,>)

is the value of the cumulative distribution function. @*P *is an expression of type **float** or of a type that implicitly converts to **float**.

is the number of independent trials. @*Trials *is an expression of type **float** or of a type that implicitly converts to **float**.

is the probability of success in each trial. @*Probability_s *is an expression of type **float** or of a type that implicitly converts to **float**.

float

· *@P* must be greater than or equal to zero and less than or equal to 1 (0 ≤ *@P* ≤ 1).

· *@Probability_s* must be greater than or equal to zero and less than or equal to 1 (0 ≤ *@Probability_s* ≤ 1).

· *@Trials* must be greater than or equal to 1 (*@Trials* ≥ 1).

· *@Trials *is truncated to zero decimal places.

Calculate of the cumulative distribution function:

SELECT wct.BINOMDIST(6,10,0.5,'True')

This produces the following result

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

0.828125

(1 row(s) affected)

Calculate the inverse of the cumulative distribution function:

SELECT wct.BINOMINV(0.828125,10,0.5)

This produces the following result

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

6

(1 row(s) affected)