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.

example: