{"id":13988,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-gamma\/"},"modified":"2021-02-26T08:49:18","modified_gmt":"2021-02-26T08:49:18","slug":"gamma-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/gamma-dist\/","title":{"rendered":"DISTR.GAMMA"},"content":{"rendered":"

La funci\u00f3n GAMMA.DIST de Microsoft Excel y DISTR.GAMMA en Google Sheets se utilizan para calcular la distribuci\u00f3n gamma de una variable aleatoria, bas\u00e1ndose en par\u00e1metros espec\u00edficos. Esta herramienta es frecuentemente empleada en estad\u00edsticas para analizar variables que presentan distribuciones asim\u00e9tricas positivas, tales como los tiempos de espera hasta la ocurrencia de un evento espec\u00edfico.<\/p>\n

Descripci\u00f3n y Sintaxis<\/h2>\n

La sintaxis de la funci\u00f3n GAMMA.DIST en Excel es:<\/p>\n

GAMMA.DIST(x, alpha, beta, acumulado)<\/code><\/pre>\n
Los par\u00e1metros se definen de la siguiente manera:<\/p>\n
    \n
  • x:<\/strong> Valor al que se eval\u00faa la funci\u00f3n.<\/li>\n
  • alpha:<\/strong> Par\u00e1metro de forma de la distribuci\u00f3n.<\/li>\n
  • beta:<\/strong> Par\u00e1metro de tasa, tambi\u00e9n conocido como el inverso de la escala.<\/li>\n
  • acumulado:<\/strong> Valor l\u00f3gico que indica el tipo de funci\u00f3n: TRUE para obtener la funci\u00f3n de distribuci\u00f3n acumulativa, FALSE para la funci\u00f3n de densidad de probabilidad.<\/li>\n<\/ul>\n
    En Google Sheets, la funci\u00f3n es similar y se denomina DISTR.GAMMA:<\/p>\n
    DISTR.GAMMA(x, alpha, beta, acumulado)<\/code><\/pre>\n
    Ejemplos de Uso<\/h2>\n\n\n\n\n
    Funci\u00f3n<\/th>\nx<\/th>\nalpha<\/th>\nbeta<\/th>\nacumulado<\/th>\nResultado<\/th>\n<\/tr>\n
    GAMMA.DIST<\/td>\n2<\/td>\n5<\/td>\n3<\/td>\nFALSE<\/td>\n0.128<\/td>\n<\/tr>\n
    GAMMA.DIST<\/td>\n2<\/td>\n5<\/td>\n3<\/td>\nTRUE<\/td>\n0.023<\/td>\n<\/tr>\n<\/table>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    La funci\u00f3n GAMMA.DIST es extremadamente \u00fatil en diversos contextos pr\u00e1cticos, como se demuestra en los siguientes escenarios:<\/p>\n
    1. Modelar el Tiempo hasta la Falla de Equipos<\/h2>\n
    Imagine un ingeniero que necesita estimar el tiempo hasta que un componente cr\u00edtico de maquinaria puede fallar, utilizando datos hist\u00f3ricos. Los tiempos de falla frecuentemente se modelan con \u00e9xito usando una distribuci\u00f3n gamma.<\/p>\n
    \/\/ Datos conocidos: double x = 10; \/\/ Tiempo en cuesti\u00f3n double alpha = 3; \/\/ Forma, basada en datos hist\u00f3ricos double beta = 1.5; \/\/ Tasa, basada en datos hist\u00f3ricos bool acumulado = TRUE; \/\/ Funci\u00f3n acumulativa deseada \/\/ C\u00e1lculo en Excel: = GAMMA.DIST(10, 3, 1.5, TRUE)<\/code><\/pre>\n
    Este c\u00e1lculo proporcionar\u00e1 la probabilidad de que el componente falle antes de cumplir 10 horas.<\/p>\n
    2. An\u00e1lisis Financiero para Tiempos de Retorno de Inversiones<\/h2>\n
    En an\u00e1lisis financiero, en especial en proyectos de inversi\u00f3n de capital, es \u00fatil predecir cu\u00e1ndo se recuperar\u00e1 la inversi\u00f3n inicial. Si los retornos son asim\u00e9tricos y se modelan mejor con una distribuci\u00f3n gamma, esta funci\u00f3n puede ser de gran utilidad.<\/p>\n
    \/\/ Datos conocidos: double x = 5; \/\/ A\u00f1os hasta el retorno esperado double alpha = 2; \/\/ Forma, basada en estimaciones de flujo de caja double beta = 1; \/\/ Tasa, reflejando la volatilidad de los retornos bool acumulado = TRUE; \/\/ Inter\u00e9s en la funci\u00f3n acumulada \/\/ C\u00e1lculo en Excel: = GAMMA.DIST(5, 2, 1, TRUE)<\/code><\/pre>\n
    Este c\u00e1lculo indicar\u00e1 la probabilidad de recuperar la inversi\u00f3n en el plazo de 5 a\u00f1os.<\/p>\n
    Estos ejemplos ilustran c\u00f3mo las funciones GAMMA.DIST y DISTR.GAMMA pueden aplicarse en escenarios reales, aportando valiosas perspectivas mediante modelos de distribuci\u00f3n de datos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la distribuci\u00f3n gamma<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540],"tags":[],"class_list":["post-13988","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.DIST (DISTR.GAMMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\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\/es\/gamma-dist\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.DIST (DISTR.GAMMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/gamma-dist\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:49:18+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/gamma-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/gamma-dist\/\",\"name\":\"Funci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:49:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.DIST (DISTR.GAMMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/gamma-dist\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/gamma-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/gamma-dist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estad\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/es\/estadistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DISTR.GAMMA\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.DIST (DISTR.GAMMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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\/es\/gamma-dist\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.DIST (DISTR.GAMMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/gamma-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:49:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/gamma-dist\/","url":"https:\/\/functiontranslator.com\/es\/gamma-dist\/","name":"Funci\u00f3n GAMMA.DIST (DISTR.GAMMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:49:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.DIST (DISTR.GAMMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/gamma-dist\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/gamma-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/gamma-dist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Estad\u00edstica","item":"https:\/\/functiontranslator.com\/es\/estadistica\/"},{"@type":"ListItem","position":3,"name":"DISTR.GAMMA"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13988"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13988\/revisions"}],"predecessor-version":[{"id":30047,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13988\/revisions\/30047"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}