Documentation/Calc Functions/HYPGEOMDIST

Function name:
HYPGEOMDIST

Category:
Statistical Analysis

Summary:
Calculates values from either the probability mass function or the cumulative distribution function for the hypergeometric distribution of a sequence. The hypergeometric distribution is a discrete probability distribution that describes the probability of a particular number of successes in a sequence of draws from a finite population without replacement.

Syntax:
HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative])

Returns:
Returns a real number which is the hypergeometric distribution value for the given arguments. It ranges from 0 to 1, i.e. [0,1].

Arguments:
X is a non-negative integer value or a reference to the cell containing that value which is the number of successes achieved in the random sample.

NSample is a non-negative integer value or a reference to the cell containing that value which is the size of the random sample.

Successes is a non-negative integer value or a reference to the cell containing that value which is the number of possible successes in the total population.

NPopulation is a non-negative integer value or a reference to the cell containing that value which is the size of the total population.

Cumulative specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The probability density function is the default if no value is specified for this parameter.


 * Given arguments must satisfy both these conditions:

0 <= X <= NSample <= NPopulation

0 <= Successes <= NPopulation

or else the function will return an error value.

Additional details:
The formula for HYPGEOMDIST is:

If Cumulative is FALSE, HYPGEOMDIST returns the probability mass function

If Cumulative is TRUE, HYPGEOMDIST returns the cumulative distribution function

where:

is COMBIN(n,x)

x = X n = NSample M = Successes N = NPopulation
 * For more details about the hypergeometric distribution, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/HYPGEOM.DIST HYPGEOM.DIST]

ODF standard:
Section 6.18.37, part 2

Equivalent Excel functions:
None