Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

HYPGEOM.DIST

Returns the hypergeometric distribution probability.

Sample Usage

HYPGEOM.DIST(4,12,20,40)
HYPGEOM.DIST(4,12,20,40)

Syntax

HYPGEOMDIST(successes, draws, total_successes, population)

  • successes - The desired number of successes.
  • draws. - The number of permitted draws.
  • total_successes - The total number of successes in the population.
  • population - The total size of the population.

Examples

HYPGEOM.DIST(4,12,20,40) returns a value of 0.1092