Updated: 9 August 2010

Use CRITBINOM to calculate the smallest value for the cumulative binomial distribution that is greater than or equal to a criterion value.

SELECT [wctStatistics].[wct].[CRITBINOM] (

<@Trials, int,>

,<@Probability_s, float,>

,<@Alpha, float,>)

is the number of Bernoulli trials. *@Trials *is an expression of type **float** or of a type that can be implicitly converted to **float**.

is the number of successes in each trial. *@Probability_s *is an expression of type **float** or of a type that can be implicitly converted to **float**.

is the criterion value. *@Alpha *is an expression of type **float** or of a type that can be implicitly converted to **float**.

float

· If *@Trials* ≤ 0, CRITBINOM returns an error.

· If *@Probability_s* ≤ 0 or *@Probability_s* ≥ 1, CRITBINOM returns an error

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

· If *@Alpha *≤ 0 or *@Alpha* ≥ 1, CRITBINOM returns an error

select wct.CRITBINOM(100,.3,.7)

This produces the following result

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

32

(1 row(s) affected)