HYPGEOM.DIST function
HYPGEOM.DIST(SampleSuccessCount, SampleSize, PopulationSuccessCount,
PopulationSize, IsCumulative) HYPGEOM.DIST(SampleSuccessCount; SampleSize; PopulationSuccessCount;
PopulationSize; IsCumulative)
SampleSuccessCount
Number or { Number }
The number of successes in the sample.
SampleSize
Number or { Number }
The size of the sample.
PopulationSuccessCount
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.