Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server CRITBINOM function


 
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)


Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service