HYPGEOM.DIST
Formulas / HYPGEOM.DISTCalculate 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?
What is the hypergeometric distribution?
What kind of data is used with the HYPGEOM.DIST function?
How is the data sampled?
