SheetFX
≡
<< Go back to all functions

HYPGEOMDIST

The HYPGEOMDIST function in Google Sheets is a statistical tool used to calculate the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.

Function Syntax and Parameters

Syntax: HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)

Parameters:

  • num_successes: The number of successful outcomes in the population.
  • num_draws: The number of draws taken from the population.
  • successes_in_pop: The total number of successes in the general population.
  • pop_size: The size of the population.

Step-by-Step Tutorial

  1. Using HYPGEOMDIST to calculate probability:
    • Example: =HYPGEOMDIST(2, 5, 10, 20)
    • Result: 0.019047619

Use Cases and Scenarios

  1. Quality Control: Assess the probability of finding a certain number of defective items in a sample.
  2. Biological Research: Determine the probability of selecting a specific number of mutated genes in a population.
  3. Survey Analysis: Calculate the probability of obtaining a specific response in a sample survey.

Related Articles