{"id":13990,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-gamma-inv\/"},"modified":"2021-02-26T08:49:20","modified_gmt":"2021-02-26T08:49:20","slug":"gamma-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/gamma-inv\/","title":{"rendered":"DISTR.GAMMA.INV"},"content":{"rendered":"<h2>Descripci\u00f3n y Sintaxis de la Funci\u00f3n de Inversa Gamma<\/h2>\n<p>La funci\u00f3n DISTR.GAMMA.INV (en Excel) y GAMMA.INV (en Google Sheets) sirve para calcular el cuantil de la distribuci\u00f3n gamma inversa. Esta funci\u00f3n es especialmente \u00fatil en estad\u00edstica para inferir un valor de una variable aleatoria que sigue una distribuci\u00f3n gamma, dado un nivel de probabilidad acumulada.<\/p>\n<p><strong>Sintaxis en Microsoft Excel:<\/strong><br \/> <code>DISTR.GAMMA.INV(probabilidad, alfa, beta)<\/code><\/p>\n<p><strong>Sintaxis en Google Sheets:<\/strong><br \/> <code>GAMMA.INV(probabilidad, alfa, beta)<\/code><\/p>\n<p>Donde:<\/p>\n<ul>\n<li><strong>probabilidad<\/strong> &#8211; Es la probabilidad asociada con la inversa de la distribuci\u00f3n gamma. Este valor debe estar entre 0 y 1.<\/li>\n<li><strong>alfa<\/strong> &#8211; El par\u00e1metro de forma de la distribuci\u00f3n gamma, que debe ser un n\u00famero positivo.<\/li>\n<li><strong>beta<\/strong> &#8211; El par\u00e1metro de escala de la distribuci\u00f3n gamma, que tambi\u00e9n debe ser positivo.<\/li>\n<\/ul>\n<h2>Ejemplos Pr\u00e1cticos de Aplicaci\u00f3n<\/h2>\n<h3>Caso 1: C\u00e1lculo de un umbral de vida \u00fatil<\/h3>\n<p>Consideremos un componente electr\u00f3nico cuya vida \u00fatil se distribuye seg\u00fan una gamma con par\u00e1metros alfa = 2 y beta = 5. Si queremos determinar el tiempo m\u00ednimo de vida \u00fatil que supera el 90% de los componentes, usar\u00edamos:<\/p>\n<pre> <code>=DISTR.GAMMA.INV(0.9, 2, 5)<\/code> <!-- En Excel --> <code>=GAMMA.INV(0.9, 2, 5)<\/code> <!-- En Google Sheets --> <\/pre>\n<p>La f\u00f3rmula devuelve el tiempo m\u00ednimo en el que al menos el 90% de los componentes deber\u00edan fallar, de acuerdo con el modelo gamma especificado.<\/p>\n<h3>Caso 2: Evaluaci\u00f3n de riesgos en gesti\u00f3n de proyectos<\/h3>\n<p>En la gesti\u00f3n de proyectos, se puede usar la distribuci\u00f3n gamma para modelar el tiempo hasta la ocurrencia de un determinado riesgo. Suponiendo que los par\u00e1metros alfa y beta son 3 y 4 respectivamente, y deseamos conocer el tiempo de ocurrencia del riesgo que no supera el 75% de los casos, proceder\u00edamos as\u00ed:<\/p>\n<pre> <code>=DISTR.GAMMA.INV(0.75, 3, 4)<\/code> <!-- En Excel --> <code>=GAMMA.INV(0.75, 3, 4)<\/code> <!-- En Google Sheets --> <\/pre>\n<p>Esta funci\u00f3n nos indica el punto en el tiempo en que el 75% de las ocurrencias de riesgo ya se habr\u00edan presentado, lo cual es \u00fatil para planificar estrategias de mitigaci\u00f3n apropiadas.<\/p>\n<p>Este tipo de funciones son de gran utilidad en \u00e1reas como la ingenier\u00eda, la investigaci\u00f3n cient\u00edfica y la gesti\u00f3n de riesgos, donde es crucial modelar tiempos y evaluar probabilidades.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devuelve la funci\u00f3n inversa de la distribuci\u00f3n gamma acumulativa<\/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-13990","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) 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-inv\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/gamma-inv\/\" \/>\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:20+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.INV (DISTR.GAMMA.INV) 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-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/gamma-inv\/\",\"name\":\"Funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) 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:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/gamma-inv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/gamma-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/gamma-inv\/#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.INV\"}]},{\"@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.INV (DISTR.GAMMA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) 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-inv\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/gamma-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:49:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) 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-inv\/","url":"https:\/\/functiontranslator.com\/es\/gamma-inv\/","name":"Funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) 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:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n GAMMA.INV (DISTR.GAMMA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/gamma-inv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/gamma-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/gamma-inv\/#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.INV"}]},{"@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\/13990","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=13990"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13990\/revisions"}],"predecessor-version":[{"id":30049,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13990\/revisions\/30049"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}