Skip to Content

HYPGEOMDIST

Returns the hypergeometric distribution. Replaced by HYPGEOM.DIST.

Syntax

HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)

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

Example

=HYPGEOMDIST(1, 4, 8, 20)
Returns: NumberSince: Excel 2003