Updated: 9 August 2010
Use HYPGEOMDISTP to calculate the lower cumulative distribution of the hypergeometric function. The formula is:
Where
k is the number of successes in the sample
N is the size of the sample
m is the number of successes in the population
n is the population size
Syntax
SELECT [wctStatistics].[wct].[HYPGEOMDISTP] (
<@Sample_s, float,>
,<@Number_sample, float,>
,<@Population_s, float,>
,<@Number_population, float,>)
Arguments
@Sample_s
is the number of successes in the sample. @Sample_s is an expression of type float or of a type that can be implicitly converted to float.
@Number_sample
is the size of the sample. @Number_sample is an expression of type float or of a type that can be implicitly converted to float.
@Population_s
is the number of successes in the population. @Population_s is an expression of type float or of a type that can be implicitly converted to float.
@Number_population
is the population size. @Number_population is an expression of type float or of a type that can be implicitly converted to float.
Return Types
float
Remarks
· If @Sample_s < 0 or @Sample_s > MIN(@Number_sample, @Population_s), HYPGEOMDISTP returns an error.
· If @Sample_s < MAX(0, @Number_sample-@Number_population+@Population_s), HYPGEOMDISTP returns an error.
· If @Number_sample ≤ 0 or @Number_sample > @Number_population, HYPGEOMDISTP returns an error.
· If @Population_s ≤ 0 or @Population_s > @Number_populations, HYPGEOMDISTP returns an error.
· If @Number_population ≤ 0, HYPGEOMDISTP returns an error.
Examples
SELECT wct.HYPGEOMDISTP(20,900,45,2000)
This produces the following result
----------------------
0.532069788839458
(1 row(s) affected)