HYPGEOM.DIST

The HYPGEOM.DIST function in Google Sheets is a statistical function that calculates the probability of drawing a certain number of successes in a specified number of draws, from a population containing a specific number of successes.

Function Syntax and Parameters

Syntax: HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)

Parameters:

• num_successes: The number of successes in the population.
• num_draws: The number of draws or observations.
• successes_in_pop: The number of successes in the population.
• pop_size: The population size.

Step-by-Step Tutorial

1. Using HYPGEOM.DIST to calculate probability:
   • Example: =HYPGEOM.DIST(3, 5, 10, 20)
   • Result: The probability of drawing exactly 3 successes in 5 draws from a population of 10 successes and 20 total elements.

Use Cases and Scenarios

1. Quality Control: Determine the probability of finding a certain number of defective items in a sample.
2. Medical Research: Calculate the probability of observing a specific number of patients with a particular condition in a clinical trial.
3. Survey Analysis: Analyze the likelihood of selecting a certain number of participants with a specific characteristic in a survey.

Related Functions

• HYPGEOM.DIST.RANGE: Calculate the probability distribution for a range of values.

Related Articles

• Understanding Probability Distributions in Google Sheets
• How to Use Statistical Functions in Google Sheets