HYPGEOMDIST

Syntax:

HYPGEOMDIST ( sample-successes , number-sample , population-successes ,
number-population )

Description: Computes the hypergeometric distribution; that is, the probability of a given number of sample successes, given the sample size, population successes, and population size.

Mathematical Formula:

where:

x = sample-successes
n = number-sample
M = population-successes
N = number-population

Arguments:

Name	Type	Description
sample-successes	number	The number of successes in the sample, truncated to integer.
number-sample	number	The size of the sample, truncated to integer.
population-successes	number	The number of successes in the population, truncated to integer.
number-population	number	The population size, truncated to integer.

 

Return Type and Value: number – The hypergeometric distribution.

However, if

• sample-successes < 0 or sample-successes is greater than the lesser of number-sample and population-successes, #NUM! is returned.

• sample-successes is less than the larger of 0 or (number-sample - number-population + population-successes), #NUM! is returned.

• number-sample ≤ 0 or number-sample > number-population, #NUM! is returned.

• population-successes ≤ 0 or population-successes > number-population, #NUM! is returned.

• number-population ≤ 0, #NUM! is returned.

[Example:

HYPGEOMDIST(1,4,8,20) results in 0.363261

end example]