Formulas > =HYPGEOM.DIST()
How to Use HYPGEOM.DIST() in Google Sheets
Description
How To Actually Use HYPGEOM.DIST() in Sheets
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
Try HYPGEOM.DIST yourself
In cells A1 to A4, enter the values for num_successes, num_draws, successes_in_pop, and pop_size respectively. Use the HYPGEOM.DIST formula in cell B1 to calculate the distribution probability.
Hints (2)
-
Remember to set the last argument to FALSE for the probability mass function.
-
Ensure your input values are correctly placed in the specified cells.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the HYPGEOM.DIST() formula:
Generate a HYPGEOM.DIST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses HYPGEOM.DIST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a HYPGEOM.DIST() formula