HYPGEOM.DIST function

HYPGEOM.DIST(sampleNumberOfSuccesses, sampleSize, populationNumberOfSuccesses, populationSize, isCumulative) HYPGEOM.DIST(sampleNumberOfSuccesses; sampleSize; populationNumberOfSuccesses; populationSize; isCumulative)

sampleNumberOfSuccesses — Number or { Number }

The number of successes in the sample.

sampleSize — Number or { Number }

The size of the sample.

populationNumberOfSuccesses — Number or { Number }

The number of successes in the population.

populationSize — Number or { Number }

The population size.

isCumulative — Logical or { Logical }

FALSE to calculate the probability mass function and TRUE to calculate the cumulative distribution function.

Returns — Number or { Number }

A value for a hypergeometric distribution.

Returns a value for a hypergeometric distribution.

Example

HYPGEOM.DIST(2, 3, 3, 6, FALSE)HYPGEOM.DIST(2; 3; 3; 6; FALSE)

Returns 0.45. If an urn contains 3 red balls and 3 green balls, the probability that 2 red balls will be selected after 3 draws without replacement is 27 / 60 = 0.45.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.