Syntax. HYPGEOM.DIST(sample_s,number_sample,population_s,number_ population,cumulative)

Definition. This function returns the probabilities of a hypergeometric distributed random variable. HYPGEOM.DIST() calculates the probability of a certain number of observations in a sample.

The following information is required:

  • Number of successes in the sample

  • Size of the sample

  • Number of possible successes in the population

  • Size of the population

  • Logical value for the function


  • sample_s (required). The number of successes in the sample

  • number_sample (required). The size of the sample

  • population_s (required). The number of successes in the population

  • number_population (required). The size of the population

  • cumulative (required) ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.