The HYPGEOMDIST function calculates the probability of a specified number of successes in a sample drawn from a finite population without replacement.


=HYPGEOMDIST(Number_s, Population_s, Number_s, Population_successes)

Number_s The number of successes in the sample.
Population_s The population size.
Number_s The number of successes in the population.
Population_successes The size of the population successes.


When you're dealing with scenarios involving sampling without replacement and want to gauge the likelihood of achieving a specific number of successes, the HYPGEOMDIST function in Excel steps in to lend a hand. Be it analyzing quality control data or estimating the success rate of a marketing campaign, HYPGEOMDIST proves to be a valuable tool for making informed decisions and predictions. The function calculates the probability of a particular number of successes occurring in a sample drawn from a population without replacement, based on specified inputs regarding the population size, successes in the population, sample size, and successes in the sample. By utilizing this function, you can gain insights into the probabilities of various outcomes in sampling situations where each selection influences subsequent selections. HYPGEOMDIST equips you with the means to model and assess sampling scenarios accurately, aiding your decision-making processes with its probabilistic insights.


Suppose you have a population of 1000 items, including 200 defective ones. If you randomly select 20 items without replacement, what is the probability of getting 4 defective items? The HYPGEOMDIST formula would be: =HYPGEOMDIST(4, 200, 20, 1000)

Consider a deck of 52 playing cards, where 12 cards are face cards (Jacks, Queens, Kings). If you draw 5 cards without replacement, what is the probability of obtaining 2 face cards? The HYPGEOMDIST formula would be: =HYPGEOMDIST(2, 12, 5, 52)


How does the HYPGEOMDIST function differ from other probability functions in Excel?

The HYPGEOMDIST function specifically deals with sampling without replacement from a finite population, focusing on the probability of a set number of successes in the sample. In contrast, functions like BINOM.DIST and POISSON.DIST cater to different types of probability distributions and scenarios.

Can the HYPGEOMDIST function handle scenarios with large population sizes?

Yes, the HYPGEOMDIST function can accommodate scenarios with relatively large population sizes, provided the inputs are correctly structured to reflect the sampling situation accurately. It excels in analyzing situations where each selection from the population influences the subsequent selections.

What insights can be gained from using the HYPGEOMDIST function?

By utilizing the HYPGEOMDIST function, you can derive probabilities related to specific success outcomes in sampling situations without replacement. These insights can aid in decision-making processes, risk assessments, and predictive modeling where understanding the likelihood of certain outcomes is crucial.

Related functions