Returns the hypergeometric distribution.
HYPGEOMDIST(X; NSample; Successes; NPopulation)
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.
=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.