HYPGEOM.DIST()/HYPGEOMDIST()

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

Arguments

  • 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial