HYPGEOM.DIST

Calculates the probability of getting a specific number of successes in a sample drawn without replacement, therefore chosen with equal likelihood, from a finite population.

Syntax:

HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)

sample_s is required, and is the number of successes in the sample.

number_sample is required, and is the size of the sample.

population_s is required, and is the number of successes in the population.

number_pop is required, and is the population size.

cumulative is required, and is a logical value:

TRUE: Returns the cumulative distribution function (the probability of getting at most sample_s successes).   

FALSE: Returns the probability mass function (the probability of getting exactly sample_s successes).

Example:

If sample_s contains 2, number_sample contains 3, population_s contains 5, number_pop contains 10 and cumulative contains FALSE:

HYPGEOM.DIST(2, 3, 5, 10, FALSE)

returns 0.416666667

This example finds the probability of drawing exactly 2 red marbles, when you randomly draw 3 marbles without replacement, from a bowl containing 10 marbles (5 red and 5 blue).