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.
Syntax
SELECT [wctStatistics].[wct].[CRITBINOM] (
<@Trials, int,>
,<@Probability_s, float,>
,<@Alpha, float,>)
Arguments
@Trials
is the number of Bernoulli trials. @Trials is an expression of type float or of a type that can be implicitly converted to float.
@Probability_s
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.
@Alpha
is the criterion value. @Alpha is an expression of type float or of a type that can be implicitly converted to float.
Return Types
float
Remarks
· 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
Examples
select wct.CRITBINOM(100,.3,.7)
This produces the following result
----------------------
32
(1 row(s) affected)