The HYPGEOMDIST function in Google Sheets calculates the probability of drawing a specific number of successes in a fixed number of draws from a finite population, without replacement. It's the legacy version of HYPGEOM.DIST and is widely used in quality control and sampling analysis. Dive into our comprehensive guide to learn how it works.
Parameters
num_successes: The number of successes in the sample.num_draws: The number of draws (sample size).successes_in_pop: The number of successes in the total population.pop_size: The total population size.
Step-by-Step Tutorial
- Calculating a hypergeometric probability:
- Example:
=HYPGEOMDIST(2, 5, 10, 50) - Result: approximately
0.2686, the probability of drawing exactly 2 successes in 5 draws from a population of 50 with 10 successes.
- Example:
Use Cases and Scenarios
- Quality Control Sampling: Calculate the probability of finding a certain number of defective items in a sample pulled without replacement.
- Lottery and Card Game Analysis: Compute probabilities for drawing specific combinations from a finite set.
- Survey Sampling: Estimate the likelihood of selecting a certain number of members from a subgroup within a population.
Related Functions
HYPGEOM.DIST: The modern version ofHYPGEOMDISTwith an added cumulative option.BINOM.DIST: Returns the individual term binomial distribution probability, used for sampling with replacement.