HYPGEOMDIST function
Summary
Returns the hypergeometric distribution
Syntax
HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)
The HYPGEOMDIST function syntax has the following arguments:
• Sample_s Required. The number of successes in the sample.
• Number_sample Required. The size of the sample.
• Population_s Required. The number of successes in the population.
• Number_pop Required. The population size.
• Sample_s Required. The number of successes in the sample.
• Number_sample Required. The size of the sample.
• Population_s Required. The number of successes in the population.
• Number_pop Required. The population size.
Example
=HYPGEOM.DIST(A2,A3,A4,A5,TRUE)
=HYPGEOM.DIST(A2,A3,A4,A5,FALSE)
=HYPGEOM.DIST(A2,A3,A4,A5,FALSE)