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-successesn = number-sampleM = population-successesN = 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.