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

Introducci\u00f3n a la funci\u00f3n de distribuci\u00f3n inversa Beta<\/h2>\n

La funci\u00f3n DISTR.BETA.INV en Microsoft Excel y Google Sheets se utiliza para calcular el inverso de la funci\u00f3n de distribuci\u00f3n acumulativa beta. Esta herramienta es de gran relevancia en estad\u00edstica para estimar par\u00e1metros en modelos de distribuciones asim\u00e9tricas y es ideal para modelar variables aleatorias que se limitan entre 0 y 1, como porcentajes, proporciones o probabilidades.<\/p>\n

Sintaxis y ejemplos pr\u00e1cticos<\/h2>\n

La sintaxis para la funci\u00f3n DISTR.BETA.INV en ambas plataformas es:<\/p>\n

DISTR.BETA.INV(probabilidad, alfa, beta, [A], [B])<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • probabilidad<\/strong>: Es la probabilidad asociada al valor deseado de la distribuci\u00f3n beta.<\/li>\n
  • alfa<\/strong>: Representa el par\u00e1metro alfa de la distribuci\u00f3n, y debe ser un n\u00famero mayor que 0.<\/li>\n
  • beta<\/strong>: Representa el par\u00e1metro beta de la distribuci\u00f3n, tambi\u00e9n un n\u00famero mayor que 0.<\/li>\n
  • A<\/strong> (opcional): Define el l\u00edmite inferior de la distribuci\u00f3n, cuyo valor por defecto es 0.<\/li>\n
  • B<\/strong> (opcional): Define el l\u00edmite superior de la distribuci\u00f3n, cuyo valor por defecto es 1.<\/li>\n<\/ul>\n
    Ejemplo de uso:<\/strong><\/p>\n
    Para determinar el valor que corresponde al percentil 90 (probabilidad = 0.9) de una distribuci\u00f3n beta con alfa = 2 y beta = 5 en Excel o Google Sheets, ingresar\u00edamos:<\/code><\/pre>\n
     =DISTR.BETA.INV(0.9, 2, 5, 0, 1)<\/code> <\/p>\n
    Esto devolver\u00eda aproximadamente 0.556, indicando que el 90% de la distribuci\u00f3n est\u00e1 acumulado antes de este punto.<\/p>\n
    Aplicaciones pr\u00e1cticas<\/h2>\n
    Evaluaci\u00f3n de resultados en pruebas<\/h2>\n
    Considere un caso donde un educador necesita discernir el rendimiento superior de estudiantes en una prueba modelada con una distribuci\u00f3n beta, cuyas puntuaciones tienden a ser asim\u00e9tricas:<\/p>\n
    Para identificar la puntuaci\u00f3n que distingue al top 10% de los estudiantes con una distribuci\u00f3n de alfa = 3 y beta = 2, utilizar\u00edamos:<\/code><\/pre>\n
     =DISTR.BETA.INV(0.9, 3, 2)<\/code> <\/p>\n
    Esto podr\u00eda retornar un valor de 0.78, mostrando que los estudiantes con puntuaci\u00f3n de 0.78 o superior est\u00e1n en el top 10% de su clase.<\/p>\n
    Modelado de la satisfacci\u00f3n del cliente<\/h2>\n
    En estudios de mercado es \u00fatil emplear la distribuci\u00f3n beta inversa para modelar la satisfacci\u00f3n del cliente, especialmente para productos con altos niveles de satisfacci\u00f3n o insatisfacci\u00f3n. Por ejemplo:<\/p>\n
    Si alfa = 4 y beta = 3 modelan la satisfacci\u00f3n respecto a un nuevo producto y se busca el percentil 25, la f\u00f3rmula ser\u00eda:<\/code><\/pre>\n
     =DISTR.BETA.INV(0.25, 4, 3)<\/code> <\/p>\n
    El resultado podr\u00eda ser 0.4, indicando que el 25% de los clientes califican su satisfacci\u00f3n por debajo de este nivel.<\/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":[542],"tags":[],"class_list":["post-13834","post","type-post","status-publish","format-standard","hentry","category-compatibilidad"],"acf":[],"yoast_head":"\nFunci\u00f3n BETAINV (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 BETAINV (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\/betainv\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n BETAINV (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 BETAINV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/betainv\/\" \/>\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:34+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 BETAINV (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\/betainv\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/betainv\/\",\"name\":\"Funci\u00f3n BETAINV (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:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n BETAINV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/betainv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/betainv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/betainv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilidad\",\"item\":\"https:\/\/functiontranslator.com\/es\/compatibilidad\/\"},{\"@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 BETAINV (DISTR.BETA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n BETAINV (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\/betainv\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n BETAINV (DISTR.BETA.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n BETAINV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/betainv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:42:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n BETAINV (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\/betainv\/","url":"https:\/\/functiontranslator.com\/es\/betainv\/","name":"Funci\u00f3n BETAINV (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:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n BETAINV (DISTR.BETA.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/betainv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/betainv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/betainv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Compatibilidad","item":"https:\/\/functiontranslator.com\/es\/compatibilidad\/"},{"@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\/13834","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=13834"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13834\/revisions"}],"predecessor-version":[{"id":29899,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13834\/revisions\/29899"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}