HYPGEOMDIST Function in Excel: Syntax, Examples and Free Practice
HYPGEOMDIST is an Excel Compatibility function. Legacy hypergeometric distribution — kept for compatibility with older files.
HYPGEOMDIST syntax
Arguments
sample_s: The number of successes in the samplenumber_sample: The size of the samplepopulation_s: The number of successes in the populationnumber_pop: The size of the population
When to use HYPGEOMDIST
HYPGEOMDIST is kept mainly for opening older files built in earlier versions of Excel.
Practice HYPGEOMDIST online, free
Open the live Excel-style spreadsheet and try HYPGEOMDIST yourself. No Excel install or sign-up needed to start.
Practice HYPGEOMDIST now →More Compatibility functions
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
Frequently asked questions
What does the HYPGEOMDIST function do in Excel?
Legacy hypergeometric distribution — kept for compatibility with older files.
What is the syntax of HYPGEOMDIST in Excel?
The syntax is =HYPGEOMDIST(sample_s, number_sample, population_s, number_pop). sample_s: The number of successes in the sample; number_sample: The size of the sample; population_s: The number of successes in the population; number_pop: The size of the population.
Where can I practice HYPGEOMDIST online for free?
Open the free live spreadsheet on Cellgrids and try HYPGEOMDIST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts