81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

HYPGEOMDIST()

Description

Calculates 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.

How To Use in Sheets

HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)

External Links

Google Sheet HYPGEOMDIST Hypergeometric Distribution using ARRAYFORMULA COMBIN Data Validation

This video shows the use of ARRAYFORMULA, COMBIN, and Data Validation to generate the data set and trendline of HYPGEOMDIST function.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.