Documentation/Calc Functions/HYPGEOMDIST

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

HYPGEOMDIST

Category:

Statistical Analysis

Summary:

Returns the hypergeometric distribution.

Syntax:

HYPGEOMDIST(X; NSample; Successes; NPopulation)

Returns:

Arguments:

X is the number of results achieved in the random sample.

NSample is the size of the random sample.

Successes is the number of possible results in the total population.

NPopulation is the size of the total population.

Additional details:

Examples:

=HYPGEOMDIST(2;2;90;100) yields 0.81. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: