Statistical - HYPGEOM.DIST Function

Description

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

Use HYPGEOM.DIST 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

HYPGEOM.DIST (sample_s, number_sample, population_s, number_pop, cumulative)

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
Cumulative

A logical value that determines the form of the function.

If cumulative is TRUE, then HYPGEOM.DIST returns the cumulative distribution function.

If cumulative is FALSE, HYPGEOM.DIST returns the probability mass function.

 Required

Notes

  • The equation for the hypergeometric distribution is −

    $$P\left ( X=x \right )=\frac{\begin{pmatrix} M\\ x\end{pmatrix}\begin{pmatrix} N-M\\ n-x\end{pmatrix}}{\begin{pmatrix} N\\ n\end{pmatrix}}$$

    Where −

    x = sample_s

    n = number_sample

    M = population_s

    N = number_pop

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

  • All arguments are truncated to integers.

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

  • HYPGEOM.DIST returns the #NUM! error value

    • If sample_s < 0 or sample_s > the lesser of number_sample

    • If sample_s > population_s

    • If sample_s > (number_sample - number_pop + population_s)

    • If number_sample ≤ 0 or > number_pop

    • If population_s ≤ 0 or > number_pop

    • If number_pop ≤ 0

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Hypgeom.Dist Function
advanced_excel_statistical_functions.htm
Advertisements