Google Sheets HYPGEOM.DIST Function: Syntax, Examples & Tips

num_successes:
The number of successful outcomes in the sample drawn from the population.

num_draws:
The total number of draws or samples taken from the population.

successes_in_pop:
The total number of successful outcomes in the entire population.

pop_size:
The total size of the population from which the sample is drawn.

What is HYPGEOM.DIST?

The HYPGEOM.DIST function in Google Sheets is a statistical function used to calculate the hypergeometric distribution. This distribution describes the probability of drawing a specific number of successes in a certain number of draws, without replacement, from a finite population. It is particularly useful in scenarios where you want to determine the likelihood of a certain outcome in a sample drawn from a larger group.

In simpler terms, HYPGEOM.DIST helps you find the probability of getting a specific number of successes in a sample when you know the total number of successes in the population.

A Practical Example

Imagine you are conducting a quality control check on a batch of products, and you want to determine the probability of finding a certain number of defective items in a sample.

Population Details:

• Total items in the batch: 50
• Total defective items: 10

Sample Details:

• Sample size: 5
• Number of defective items you want to find in the sample: 2

HYPGEOM.DIST Formula

To calculate the probability of finding exactly 2 defective items in your sample of 5, you would use the HYPGEOM.DIST function as follows:

=HYPGEOM.DIST(2, 5, 10, 50, FALSE)

In this formula:

• 2 is the number of successes (defective items) you want to find in the sample.
• 5 is the sample size.
• 10 is the total number of successes in the population (defective items).
• 50 is the total population size.
• FALSE indicates that you want the probability mass function (PMF) rather than the cumulative distribution function (CDF).

Result of the Formula

When you apply the HYPGEOM.DIST formula, it will return the probability of finding exactly 2 defective items in your sample of 5. The output might look something like this:

0.227

This means there is a 22.7% chance of finding exactly 2 defective items in your sample.

Why Use HYPGEOM.DIST?

HYPGEOM.DIST is beneficial because it allows you to perform precise probability calculations for scenarios involving sampling without replacement. This is particularly useful in quality control, risk assessment, and any situation where you need to understand the likelihood of specific outcomes in a finite population.

Key Takeaways:

• HYPGEOM.DIST: A statistical function that calculates the hypergeometric distribution for a given number of successes in a sample.
• Sampling Without Replacement: Ideal for scenarios where items are not replaced after being drawn from a population.
• Probability Calculation: Helps in determining the likelihood of specific outcomes, which is crucial for decision-making in various fields.
• Common Use Cases: Useful in quality control, risk analysis, and any situation involving finite populations and sampling.

HYPGEOM.DIST is an essential function for anyone working with statistics in Google Sheets, providing a powerful way to analyze probabilities and make informed decisions based on data.

Happy analyzing!