# Google Sheets HYPGEOMDIST Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/hypgeomdist-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The HYPGEOMDIST function calculates the probability of a given number of successes in a hypergeometric distribution. ``` HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the HYPGEOMDIST you need in plain EnglishGenerate Formula ## Parameters **`num_successes`**:\ The number of successful outcomes in the sample drawn from the population. **`num_draws`**:\ The total number of draws or samples taken from the population. **`successes_in_pop`**:\ The total number of successful outcomes in the entire population. **`pop_size`**:\ The total size of the population from which the sample is drawn. ## What is HYPGEOMDIST? The *HYPGEOMDIST* function in Google Sheets is a statistical function used to calculate the hypergeometric distribution. This distribution is useful in scenarios where you are sampling without replacement from a finite population. The HYPGEOMDIST function can help you determine the probability of a certain number of successes in a sample drawn from a population containing a specific number of successes. In simpler terms, HYPGEOMDIST allows you to find the probability of obtaining a specific number of successes in a sample when you know the total number of successes in the population. ## A Practical Example Imagine you are conducting a quality control test on a batch of products. You have a total of 20 products, of which 5 are defective. You want to know the probability of finding exactly 2 defective products when you randomly select 5 products from the batch. ### Parameters: - Total population size (N): 20 - Total number of successes in the population (K): 5 (defective products) - Sample size (n): 5 (products selected) - Number of successes in the sample (k): 2 (defective products found) ## HYPGEOMDIST Formula To achieve this, you would use the HYPGEOMDIST function as follows: ``` =HYPGEOMDIST(2, 5, 5, 20) ``` In this formula: - `2` is the number of successes in the sample (defective products found). - `5` is the sample size (total products selected). - `5` is the total number of successes in the population (defective products). - `20` is the total population size (total products). ## Result of the Formula When you apply the HYPGEOMDIST formula, it will return the probability of finding exactly 2 defective products in your sample of 5. The output might look like this: ``` 0.227 ``` This means there is approximately a 22.7% chance of finding exactly 2 defective products when you randomly select 5 from the batch. ## Why Use HYPGEOMDIST? HYPGEOMDIST is beneficial because it provides a way to calculate probabilities in scenarios where sampling is done without replacement. This is particularly useful in quality control, risk assessment, and any situation where you need to understand the likelihood of specific outcomes based on a finite population. ## Key Takeaways: - **HYPGEOMDIST**: A statistical function that calculates the hypergeometric distribution probability. - **Sampling Without Replacement**: Ideal for scenarios where you are selecting items from a finite population. - **Practical Applications**: Useful in quality control, risk assessment, and scenarios requiring probability calculations based on limited data. - **Understanding Probabilities**: Helps in making informed decisions based on the likelihood of various outcomes. HYPGEOMDIST is an essential function for anyone working with statistical analysis in Google Sheets, providing a powerful way to understand probabilities in finite populations. Happy analyzing! ## Example use case You have a table with 100 total items, 30 of which are defective. Using HYPGEOMDIST, you can calculate the probability of finding exactly 5 defective items in a sample of 10. This helps in quality control assessments and decision-making processes. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Unprotect Google Sheets](https://betteranalyst.com/google-sheets/how-to-unprotect-google-sheets) - [How To Wrap Text In Google Sheets](https://betteranalyst.com/google-sheets/how-to-wrap-text-in-google-sheets) - [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting) - [How To Add A Column In Google Sheets](https://betteranalyst.com/google-sheets/how-to-add-a-column-in-google-sheets) - [How To Alphabetize In Google Sheets](https://betteranalyst.com/google-sheets/how-to-alphabetize-in-google-sheets) - [How To Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) - [How To Calculate Percentage In Google Sheets](https://betteranalyst.com/google-sheets/how-to-calculate-percentage-in-google-sheets) - [How To Combine Two Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-combine-two-columns-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.