HYPGEOM.DIST
Category: Statistical Function.
Description: Returns the hypergeometric distribution.
HYPGEOM.DIST returns the probability of a given number of sample successes, given the sample size, population successes and population size.
Syntax: HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)
The HYPGEOM.DIST function syntax has the following arguments:
Sample_s: number of successes in the sample.
Number_sample: size of the sample.
Population_s: number of successes in the population.
Number_pop: population size.
Cumulative: logical value that determines the form of the function.
-
If cumulative is TRUE, HYPGEOM.DIST returns the cumulative distribution function.
-
If cumulative is FALSE, HYPGEOM.DIST returns the probability mass function.