Compatibility - HYPGEOMDIST Function

The HYPGEOMDIST function replaces the HYPGEOM.DIST function in Excel 2010.

Description

The function returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size.

Use HYPGEOMDIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.

Syntax

HYPGEOMDIST (sample_s,number_sample,population_s,number_pop)

Arguments

Argument Description Required/ Optional
Sample_s The number of successes in the sample. Required
Number_sample The size of the sample. Required
Population_s The number of successes in the population. Required
Number_pop The population size. Required

Notes

  • The equation for the hypergeometric distribution is −

    $$P(X=x) = h(x;n,M,N) = \frac{\binom{M}{x}\binom{N-M}{n-x}}{\binom{N}{n}}$$

    Where −

    x = sample_s

    n = number_sample

    M = population_s

    N = number_population

  • HYPGEOMDIST is used in sampling without replacement from a finite population.

  • All arguments are truncated to integers.

  • If any argument is nonnumeric, HYPGEOMDIST returns the #VALUE! error value.

  • If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOMDIST returns the #NUM! error value.

  • If sample_s is less than the larger of 0 or (number_sample - number_population + population_s), HYPGEOMDIST returns the #NUM! error value.

  • If number_sample ≤ 0 or number_sample > number_population, HYPGEOMDIST returns the #NUM! error value.

  • If population_s ≤ 0 or population_s > number_population, HYPGEOMDIST returns the #NUM! error value.

  • If number_population ≤ 0, HYPGEOMDIST returns the #NUM! error value.

Example

HYPGEOMDIST Function
advanced_excel_compatibility_functions.htm
Advertisements