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.