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.
Description
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 yet. Stay tuned!