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

Today, we’ll delve into a powerful statistical function known as GAMMADIST<\/strong>, available both in Microsoft Excel and Google Sheets. It is utilized for calculating the gamma distribution for a specific value.<\/p>\n

Syntax<\/h2>\n

The syntax for the GAMMADIST function is consistent across both Excel and Google Sheets:<\/p>\n

Excel and Google Sheets:<\/strong><\/p>\n

GAMMADIST(x, alpha, beta, cumulative)<\/code><\/pre>\n
    \n
  • x<\/code>: The value at which the distribution is evaluated.<\/li>\n
  • alpha<\/code>: The parameter of the distribution, often referred to as the “shape” parameter.<\/li>\n
  • beta<\/code>: Another parameter of the distribution, often known as the “rate” parameter.<\/li>\n
  • cumulative<\/code>: A logical (Boolean) value that specifies the function’s form. Set to TRUE for computing the cumulative distribution function, or FALSE for the probability density function.<\/li>\n<\/ul>\n
    Example Tasks<\/h2>\n
    Let’s examine some practical applications of the GAMMADIST function:<\/p>\n
    Calculating Probability Density Function<\/h2>\n
    For instance, to compute the probability density function at x = 2<\/code>, alpha = 3<\/code>, and beta = 2<\/code>:<\/p>\n
    Excel:<\/strong><\/p>\n\n\n\n
    x<\/th>\nalpha<\/th>\nbeta<\/th>\nPDF<\/th>\n<\/tr>\n
    2<\/td>\n3<\/td>\n2<\/td>\n=GAMMADIST(2, 3, 2, FALSE)<\/td>\n<\/tr>\n<\/table>\n
    Google Sheets:<\/strong><\/p>\n\n\n\n
    x<\/th>\nalpha<\/th>\nbeta<\/th>\nPDF<\/th>\n<\/tr>\n
    2<\/td>\n3<\/td>\n2<\/td>\n=GAMMADIST(2, 3, 2, FALSE)<\/td>\n<\/tr>\n<\/table>\n
    Calculating Cumulative Distribution Function<\/h2>\n
    In another scenario, to calculate the cumulative distribution function at x = 2<\/code>, alpha = 3<\/code>, beta = 2<\/code>:<\/p>\n
    Excel:<\/strong><\/p>\n\n\n\n
    x<\/th>\nalpha<\/th>\nbeta<\/th>\nCDF<\/th>\n<\/tr>\n
    2<\/td>\n3<\/td>\n2<\/td>\n=GAMMADIST(2, 3, 2, TRUE)<\/td>\n<\/tr>\n<\/table>\n
    Google Sheets:<\/strong><\/p>\n\n\n\n
    x<\/th>\nalpha<\/th>\nbeta<\/th>\nCDF<\/th>\n<\/tr>\n
    2<\/td>\n3<\/td>\n2<\/td>\n=GAMMADIST(2, 3, 2, TRUE)<\/td>\n<\/tr>\n<\/table>\n
    This overview demonstrates how to employ the GAMMADIST function in both Excel and Google Sheets for specific gamma distribution calculations. Always ensure that the parameters and values are correctly adjusted to meet your specific analytical needs.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns the gamma 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-208","post","type-post","status-publish","format-standard","hentry","category-compatibility"],"acf":[],"yoast_head":"\nExcel GAMMADIST Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel GAMMADIST 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\/gammadist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel GAMMADIST Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel GAMMADIST function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/gammadist\/\" \/>\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:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel GAMMADIST 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\/gammadist\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/gammadist\/\",\"name\":\"Excel GAMMADIST 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:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel GAMMADIST function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/gammadist\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/gammadist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/gammadist\/#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\":\"GAMMADIST\"}]},{\"@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 GAMMADIST Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel GAMMADIST 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\/gammadist\/","og_locale":"en_US","og_type":"article","og_title":"Excel GAMMADIST Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel GAMMADIST function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/gammadist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:34:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel GAMMADIST 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\/gammadist\/","url":"https:\/\/functiontranslator.com\/en\/gammadist\/","name":"Excel GAMMADIST 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:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel GAMMADIST function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/gammadist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/gammadist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/gammadist\/#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":"GAMMADIST"}]},{"@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\/208","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=208"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/208\/revisions"}],"predecessor-version":[{"id":3099,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/208\/revisions\/3099"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}