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

La funci\u00f3n BETA.DIST<\/strong> en Microsoft Excel y DISTR.BETA<\/strong> en Google Sheets es una funci\u00f3n estad\u00edstica que calcula la funci\u00f3n de distribuci\u00f3n acumulativa para una distribuci\u00f3n beta especificada. Esta funci\u00f3n resulta esencial para el an\u00e1lisis de variaciones con un rango limitado de datos, como las tasas de defectos de productos o proporciones en estudios demogr\u00e1ficos.<\/p>\n

Descripci\u00f3n de la Sintaxis<\/h2>\n

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

BETA.DIST(x, alpha, beta, acumulado, [A], [B])<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • x<\/strong>: Es el valor que se eval\u00faa en la funci\u00f3n.<\/li>\n
  • alpha<\/strong> (alfa): Par\u00e1metro alfa de la distribuci\u00f3n, que debe ser mayor que 0.<\/li>\n
  • beta<\/strong> (beta): Par\u00e1metro beta de la distribuci\u00f3n, que debe ser mayor que 0.<\/li>\n
  • acumulado<\/strong>: Par\u00e1metro l\u00f3gico que define el tipo de funci\u00f3n devuelta; si es VERDADERO, se devuelve la funci\u00f3n de distribuci\u00f3n acumulativa; si es FALSO, se devuelve la funci\u00f3n de densidad de probabilidad.<\/li>\n
  • [A]<\/strong>: Es el l\u00edmite inferior de x; es opcional, y su valor predeterminado es 0.<\/li>\n
  • [B]<\/strong>: Es el l\u00edmite superior de x; es opcional, y su valor predeterminado es 1.<\/li>\n<\/ul>\n
    En Google Sheets la sintaxis es similar:<\/p>\n
    DISTR.BETA(x, alpha, beta, acumulado, [A], [B])<\/code><\/pre>\n
    Ejemplos Pr\u00e1cticos<\/h2>\n
    Aplicaci\u00f3n en Evaluaci\u00f3n de Proyectos<\/h2>\n
    Imaginemos que un analista de proyectos necesita calcular la probabilidad de completar un proyecto dentro del presupuesto, asumiendo que la tasa de \u00e9xito sigue una distribuci\u00f3n beta con par\u00e1metros alfa = 2 y beta = 5. Se desea saber la probabilidad de que el proyecto tenga un \u00e9xito del 60% o menos.<\/p>\n
    BETA.DIST(0.6, 2, 5, VERDADERO)<\/code><\/pre>\n
    La f\u00f3rmula anterior proporcionar\u00e1 la probabilidad acumulada de un \u00e9xito del 60% o menos seg\u00fan la distribuci\u00f3n beta establecida.<\/p>\n
    An\u00e1lisis en el Control de Calidad<\/h2>\n
    En el \u00e1mbito del control de calidad, un ingeniero desea determinar la probabilidad de que no m\u00e1s del 30% de las unidades producidas resulten defectuosas, dado que la proporci\u00f3n de unidades defectuosas sigue una distribuci\u00f3n beta con par\u00e1metros alfa = 3 y beta = 10.<\/p>\n
    BETA.DIST(0.3, 3, 10, VERDADERO)<\/code><\/pre>\n
    Esta expresi\u00f3n calcular\u00e1 la probabilidad de que no m\u00e1s del 30% de las unidades sean defectuosas, lo cual es crucial para mejorar y controlar la calidad del proceso de producci\u00f3n.<\/p>\n
    Estos ejemplos ilustran c\u00f3mo se puede emplear la funci\u00f3n BETA.DIST en distintos contextos empresariales y t\u00e9cnicos para evaluar probabilidades sobre la base de la distribuci\u00f3n beta, ofreciendo una herramienta poderosa para el an\u00e1lisis estad\u00edstico y la toma de decisiones.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la funci\u00f3n de distribuci\u00f3n beta 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-13833","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n BETA.DIST (DISTR.BETA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n BETA.DIST (DISTR.BETA) 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-dist\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n BETA.DIST (DISTR.BETA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n BETA.DIST (DISTR.BETA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/beta-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:42:32+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.DIST (DISTR.BETA) 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-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/beta-dist\/\",\"name\":\"Funci\u00f3n BETA.DIST (DISTR.BETA) 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:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n BETA.DIST (DISTR.BETA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/beta-dist\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/beta-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/beta-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.BETA\"}]},{\"@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.DIST (DISTR.BETA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n BETA.DIST (DISTR.BETA) 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-dist\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n BETA.DIST (DISTR.BETA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n BETA.DIST (DISTR.BETA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/beta-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:42:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n BETA.DIST (DISTR.BETA) 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-dist\/","url":"https:\/\/functiontranslator.com\/es\/beta-dist\/","name":"Funci\u00f3n BETA.DIST (DISTR.BETA) 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:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n BETA.DIST (DISTR.BETA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/beta-dist\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/beta-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/beta-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.BETA"}]},{"@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\/13833","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=13833"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13833\/revisions"}],"predecessor-version":[{"id":29898,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13833\/revisions\/29898"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}