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

Today, we’ll explore the NEGBINOMDIST function, a robust statistical tool available in both MS Excel and Google Sheets. This function is essential for computing the negative binomial distribution, which is the probability of a specified number of failures occurring before a predetermined number of successes, based on the given success probability for each trial.<\/p>\n

Syntax<\/h2>\n

The syntax for the NEGBINOMDIST function is as follows:<\/p>\n

NEGBINOMDIST(number_f, number_s, probability_s, cumulative)<\/code><\/pre>\n
    \n
  • number_f<\/code>: This is the number of failures for which the probability will be calculated.<\/li>\n
  • number_s<\/code>: This is the threshold number of successes that must be reached.<\/li>\n
  • probability_s<\/code>: This represents the probability of a success in each individual trial.<\/li>\n
  • cumulative<\/code>: A Boolean value that specifies the function mode. If set to TRUE, which is the default setting, the function will return the cumulative distribution function. If FALSE, it returns the probability mass function.<\/li>\n<\/ul>\n
    Examples<\/h2>\n
    Calculating Negative Binomial Distribution Probability<\/h2>\n
    Let’s examine how the NEGBINOMDIST function can be applied in both MS Excel and Google Sheets with an example.<\/p>\n
    MS Excel<\/h2>\n
    Imagine you are tasked with finding the probability of encountering 3 failures before achieving 5 successes, within 10 trials, with each trial having a success probability of 0.3.<\/p>\n\n\n\n
    number_f<\/th>\nnumber_s<\/th>\nprobability_s<\/th>\nResult<\/th>\n<\/tr>\n
    3<\/td>\n5<\/td>\n0.3<\/td>\n=NEGBINOMDIST(3, 5, 0.3, TRUE)<\/td>\n<\/tr>\n<\/table>\n
    This formula will yield the probability of accruing 3 failures before the 5th success transpires over 10 trials with a 0.3 chance of success in each trial.<\/p>\n
    Google Sheets<\/h2>\n
    The application looks identical in Google Sheets:<\/p>\n\n\n\n
    number_f<\/th>\nnumber_s<\/th>\nprobability_s<\/th>\nResult<\/th>\n<\/tr>\n
    3<\/td>\n5<\/td>\n0.3<\/td>\n=NEGBINOMDIST(3, 5, 0.3, TRUE)<\/td>\n<\/tr>\n<\/table>\n
    Similarly, this function will compute the probability of observing 3 failures before 5 successes across 10 trials, each with a success probability of 0.3, in Google Sheets.<\/p>\n
    This overview guides you through using the NEGBINOMDIST function to determine negative binomial distributions in both MS Excel and Google Sheets, making it an invaluable resource for anyone conducting statistical analyses or working with probabilities.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns the negative binomial 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-324","post","type-post","status-publish","format-standard","hentry","category-compatibility"],"acf":[],"yoast_head":"\nExcel NEGBINOMDIST Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel NEGBINOMDIST 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\/negbinomdist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel NEGBINOMDIST Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel NEGBINOMDIST function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/negbinomdist\/\" \/>\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:35:29+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel NEGBINOMDIST 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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/negbinomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/negbinomdist\/\",\"name\":\"Excel NEGBINOMDIST 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:35:29+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel NEGBINOMDIST function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/negbinomdist\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/negbinomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/negbinomdist\/#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\":\"NEGBINOMDIST\"}]},{\"@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 NEGBINOMDIST Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel NEGBINOMDIST 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\/negbinomdist\/","og_locale":"en_US","og_type":"article","og_title":"Excel NEGBINOMDIST Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel NEGBINOMDIST function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/negbinomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:35:29+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel NEGBINOMDIST Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/negbinomdist\/","url":"https:\/\/functiontranslator.com\/en\/negbinomdist\/","name":"Excel NEGBINOMDIST 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:35:29+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel NEGBINOMDIST function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/negbinomdist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/negbinomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/negbinomdist\/#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":"NEGBINOMDIST"}]},{"@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\/324","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=324"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/324\/revisions"}],"predecessor-version":[{"id":3215,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/324\/revisions\/3215"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}