HYPGEOM.DIST

Formulas / HYPGEOM.DIST
Calculate the hypergeometric distribution.
=HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)
  • sample_s - the number of successes in the sample
  • number_sample - the size of the sample
  • population_s - the number of successes in the population
  • number_pop - the population size

Examples

  • =HYPGEOM.DIST(8,20,100,8,TRUE)

    The HYPGEOM.DIST function is used to calculate the cumulative probability of a sample and population in cells. For example, if you have a population of 100 people and a sample of 20 people, and you want to know the probability that at least 8 of those 20 people are from the population, you would use the HYPGEOM.DIST function. This will return the cumulative probability that at least 8 of the 20 people are from the population.

  • =HYPGEOM.DIST(10,10,200,10,TRUE)

    The HYPGEOM.DIST function can also be used to calculate the probability of a sample being drawn from a population. For example, if you have a population of 200 people and a sample of 10 people, and you want to know the probability that all 10 of those 10 people are from the population, you would use the HYPGEOM.DIST function. This will return the cumulative probability that all 10 of the 10 people are from the population.


Summary

The HYPGEOM.DIST function calculates the probability of a given number of sample successes given the sample size, population successes, and population size of a finite population and returns the hypergeometric distribution.

  • The HYPGEOM.DIST function is used to calculate the probability of a given number of sample successes when sampling from a finite population, given the sample size, population successes, and population size.
  • Each observation in a HYPGEOM.DIST sample must be a success or a failure.
  • HYPGEOM.DIST is the ideal function to use when dealing with a finite population.

Frequently Asked Questions

What is the HYPGEOM.DIST function?
The HYPGEOM.DIST function is a statistical function used to calculate the probability of a given number of successes in a sample, given the number of successes in the population, the number of sample successes in the population, and the population size.
What is the hypergeometric distribution?
The hypergeometric distribution is a statistical distribution used to calculate the probability of a given number of sample successes, given the number of successes in the population, the number of sample successes in the sample, and the population size.
What kind of data is used with the HYPGEOM.DIST function?
The HYPGEOM.DIST function is used with data that is finite and consists of observations that are either successes or failures.
How is the data sampled?
The data is sampled such that each subset of the population is chosen with equal likelihood.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV