Updated: 31 July 2015
Use HYPGEOM_INV to calculate the quantiles of the hypergeometric distribution. The hypergeometric distribution is generally described using colored balls in an urn. Given an urn containing N balls of which K are white (and N-K are black), the hypergeometric distribution calculates the probability of drawing k white balls from a sample of n without replacement (meaning that once a ball is removed from the urn it is not put back).
the probability value to be evaluated. @P must be of a type float or of type that intrinsically converts to float.
the size of the sample. @Number_sample must be of a type float or of type that intrinsically converts to float.
the number of successes in the population. @Population_s must be of a type float or of type that intrinsically converts to float.
the size of the population. @Number_population must be of a type float or of a type that intrinsically converts to float.
· @Number_sample, @Population_s, and @Number_population are truncated; only the integer part is used.
· 0 = @P = 1
· 0 = @Population_s
· 0 < @Number_sample
· 0 < @Number_population
· @Population_s = @Number_population.
In an urn with 1000 balls of which 300 are white we want to calculate the number of while balls we should expect in a random sample of 25 balls 95% of the time.
) as HYPGEOM_INV
This produces the following result
In other words, in a random sample of 25 balls, we would expect to have no more than 11 white balls 95% of the time.