{"id":13835,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-beta-inv-2\/"},"modified":"2021-02-26T08:42:36","modified_gmt":"2021-02-26T08:42:36","slug":"beta-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/beta-inv\/","title":{"rendered":"DISTR.BETA.INV"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

La funci\u00f3n BETA.INV<\/code> en Excel y DISTR.BETA.INV<\/code> en Google Sheets se utiliza para calcular el inverso de la distribuci\u00f3n acumulativa beta. Esta funci\u00f3n resulta extremadamente \u00fatil en el campo de la estad\u00edstica para estimar par\u00e1metros que siguen una distribuci\u00f3n beta.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n es la siguiente:<\/p>\n

BETA.INV(probabilidad, alfa, beta, [A], [B])<\/code><\/pre>\n
D\u00f3nde:<\/p>\n
    \n
  • probabilidad<\/strong> – Es la probabilidad asociada con la distribuci\u00f3n beta inversa.<\/li>\n
  • alfa<\/strong> – Representa el par\u00e1metro alfa de la distribuci\u00f3n; debe ser un n\u00famero mayor que 0.<\/li>\n
  • beta<\/strong> – Denota el par\u00e1metro beta de la distribuci\u00f3n; tambi\u00e9n debe ser un n\u00famero mayor que 0.<\/li>\n
  • [A]<\/strong> – Valor m\u00ednimo que puede retornar la funci\u00f3n, opcional.<\/li>\n
  • [B]<\/strong> – Valor m\u00e1ximo que puede retornar la funci\u00f3n, opcional.<\/li>\n<\/ul>\n
    Ejemplo en Excel:<\/p>\n
    =BETA.INV(0.2, 2, 5) \/\/ Devuelve el valor de x para el cual la funci\u00f3n de distribuci\u00f3n acumulativa es 0.2, con par\u00e1metros alfa=2 y beta=5.<\/code><\/pre>\n
    Ejemplo en Google Sheets:<\/p>\n
    =DISTR.BETA.INV(0.2, 2, 5) \/\/ Similar al ejemplo de Excel, adaptado para Google Sheets.<\/code><\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    Esta funci\u00f3n puede ser empleada en distintos contextos como el an\u00e1lisis financiero o la investigaci\u00f3n m\u00e9dica. A continuaci\u00f3n, se presentan dos ejemplos pr\u00e1cticos de c\u00f3mo esta funci\u00f3n puede ser de utilidad:<\/p>\n
    Estimaci\u00f3n de par\u00e1metros en estudios m\u00e9dicos<\/h2>\n
    En un estudio sobre una nueva vacuna, la respuesta inmune podr\u00eda modelarse con una distribuci\u00f3n beta. Los investigadores podr\u00edan querer determinar el umbral inferior del 30% de respuesta inmune para una dosis espec\u00edfica, donde los par\u00e1metros de forma son alfa = 3 y beta = 2.<\/p>\n
    En Excel: =BETA.INV(0.3, 3, 2) En Google Sheets: =DISTR.BETA.INV(0.3, 3, 2)<\/code><\/pre>\n
    El resultado de ambas f\u00f3rmulas indicar\u00e1 el valor m\u00ednimo de respuesta inmune que se espera sea superado por el 30% de la poblaci\u00f3n estudiada.<\/p>\n
    Modelado de la satisfacci\u00f3n del cliente<\/h2>\n
    Una empresa podr\u00eda estar interesada en calcular el percentil 90 de satisfacci\u00f3n del cliente, donde los par\u00e1metros de la distribuci\u00f3n beta son alfa = 4 y beta = 3, y la escala de satisfacci\u00f3n va de 0 a 100.<\/p>\n
    En Excel: =BETA.INV(0.9, 4, 3, 0, 100) En Google Sheets: =DISTR.BETA.INV(0.9, 4, 3, 0, 100)<\/code><\/pre>\n
    Este c\u00e1lculo proporcionar\u00e1 un valor por debajo del cual se sit\u00faa el 90% de las evaluaciones de los clientes, permitiendo a la empresa evaluar si las estrategias de mejora en la satisfacci\u00f3n est\u00e1n siendo efectivas o si necesitan ajustes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la funci\u00f3n inversa de la funci\u00f3n de distribuci\u00f3n acumulativa de una distribuci\u00f3n beta especificada<\/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-13835","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n BETA.INV (DISTR.BETA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n BETA.INV (DISTR.BETA.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\/beta-inv\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n BETA.INV (DISTR.BETA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n BETA.INV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/beta-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:42:36+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 BETA.INV (DISTR.BETA.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\/beta-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/beta-inv\/\",\"name\":\"Funci\u00f3n BETA.INV (DISTR.BETA.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:42:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n BETA.INV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/beta-inv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/beta-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/beta-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.BETA.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 BETA.INV (DISTR.BETA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n BETA.INV (DISTR.BETA.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\/beta-inv\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n BETA.INV (DISTR.BETA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n BETA.INV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/beta-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:42:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n BETA.INV (DISTR.BETA.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\/beta-inv\/","url":"https:\/\/functiontranslator.com\/es\/beta-inv\/","name":"Funci\u00f3n BETA.INV (DISTR.BETA.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:42:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n BETA.INV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/beta-inv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/beta-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/beta-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.BETA.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\/13835","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=13835"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13835\/revisions"}],"predecessor-version":[{"id":29900,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13835\/revisions\/29900"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}