HYPGEOM.DIST
Returns the hypergeometric distribution
Syntax
HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)
Parameters
- 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
- cumulative: Required. TRUE for cumulative, FALSE for probability mass
Example
=HYPGEOM.DIST(1, 4, 8, 20, TRUE)