{"id":227,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/hypgeomdist\/"},"modified":"2021-02-13T11:34:24","modified_gmt":"2021-02-13T11:34:24","slug":"hypgeomdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/hypgeomdist\/","title":{"rendered":"HYPGEOMDIST"},"content":{"rendered":"

Today, we’ll explore the HYPGEOMDIST function, a statistical formula used both in Excel and Google Sheets for calculating the probability of achieving a certain number of successes within a sample size from a given population that has a specific number of successes.<\/p>\n

How does it work?<\/h2>\n

The syntax for the HYPGEOMDIST function in Excel and Google Sheets is detailed below:<\/p>\n

=HYPGEOMDIST(sample_s, number_sample, population_s, number_pop, cumulative)<\/code><\/pre>\n
    \n
  • sample_s<\/code>: Represents the number of successes in the sample.<\/li>\n
  • number_sample<\/code>: Indicates the total number of observations in the sample.<\/li>\n
  • population_s<\/code>: Specifies the number of successes in the entire population.<\/li>\n
  • number_pop<\/code>: Describes the total population size.<\/li>\n
  • cumulative<\/code>: This logical argument determines the function’s output. If set to TRUE, the function provides the cumulative distribution function; if FALSE, it returns the probability mass function. This parameter is optional.<\/li>\n<\/ul>\n
    Examples of tasks where HYPGEOMDIST can be applied:<\/h2>\n
    Example 1:<\/strong> Calculate the likelihood of drawing 2 aces from 5 cards out of a standard 52-card deck, which includes 4 aces.<\/p>\n\n\n\n
    sample_s<\/th>\nnumber_sample<\/th>\npopulation_s<\/th>\nnumber_pop<\/th>\ncumulative<\/th>\nFormula<\/th>\nResult<\/th>\n<\/tr>\n
    2<\/td>\n5<\/td>\n4<\/td>\n52<\/td>\nFALSE<\/td>\n=HYPGEOMDIST(2, 5, 4, 52, FALSE)<\/td>\n0.1264<\/td>\n<\/tr>\n<\/table>\n
    The probability of drawing 2 aces when selecting 5 cards from a standard deck of 52 cards is approximately 0.1264, or 12.64%.<\/p>\n
    Example 2:<\/strong> Assess the cumulative probability of obtaining no more than 3 heads when flipping a fair coin 5 times.<\/p>\n\n\n\n
    sample_s<\/th>\nnumber_sample<\/th>\npopulation_s<\/th>\nnumber_pop<\/th>\ncumulative<\/th>\nFormula<\/th>\nResult<\/th>\n<\/tr>\n
    0-3<\/td>\n5<\/td>\n2<\/td>\n2<\/td>\nTRUE<\/td>\n=HYPGEOMDIST(3, 5, 2, 2, TRUE)<\/td>\n0.9688<\/td>\n<\/tr>\n<\/table>\n
    Thus, the cumulative probability of getting up to 3 heads when flipping a fair coin 5 times is about 0.9688 or 96.88%.<\/p>\n
    As demonstrated in the examples, the HYPGEOMDIST function can be invaluable for various scenarios where you need to calculate probabilities based on specific samples and populations. Be sure to adjust the input values as necessary for your specific application.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns the hypergeometric distribution<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[205],"tags":[],"class_list":["post-227","post","type-post","status-publish","format-standard","hentry","category-compatibility"],"acf":[],"yoast_head":"\nExcel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel HYPGEOMDIST function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/hypgeomdist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel HYPGEOMDIST function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/hypgeomdist\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:34:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/hypgeomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/hypgeomdist\/\",\"name\":\"Excel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:34:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel HYPGEOMDIST function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/hypgeomdist\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/hypgeomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/hypgeomdist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibility\",\"item\":\"https:\/\/functiontranslator.com\/en\/compatibility\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HYPGEOMDIST\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel HYPGEOMDIST function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/hypgeomdist\/","og_locale":"en_US","og_type":"article","og_title":"Excel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel HYPGEOMDIST function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/hypgeomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:34:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/hypgeomdist\/","url":"https:\/\/functiontranslator.com\/en\/hypgeomdist\/","name":"Excel HYPGEOMDIST Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:34:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel HYPGEOMDIST function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/hypgeomdist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/hypgeomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/hypgeomdist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Compatibility","item":"https:\/\/functiontranslator.com\/en\/compatibility\/"},{"@type":"ListItem","position":3,"name":"HYPGEOMDIST"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=227"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/227\/revisions"}],"predecessor-version":[{"id":3118,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/227\/revisions\/3118"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}