{"id":14267,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/dist-weibull\/"},"modified":"2021-02-26T09:01:41","modified_gmt":"2021-02-26T09:01:41","slug":"weibull","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/weibull\/","title":{"rendered":"DIST.WEIBULL"},"content":{"rendered":"<h2>Introducci\u00f3n a la distribuci\u00f3n Weibull en hojas de c\u00e1lculo<\/h2>\n<p>La distribuci\u00f3n Weibull es una funci\u00f3n de distribuci\u00f3n continua ampliamente utilizada en estad\u00edsticas y an\u00e1lisis de confiabilidad para modelar la vida \u00fatil de productos y materiales. En herramientas como Excel y Google Sheets, esta funci\u00f3n es esencial para calcular la probabilidad de que un evento suceda dentro de un intervalo de tiempo determinado, seg\u00fan par\u00e1metros de escala y forma espec\u00edficos.<\/p>\n<h2>Sintaxis y ejemplos de uso<\/h2>\n<p>La sintaxis de la funci\u00f3n de distribuci\u00f3n Weibull var\u00eda ligeramente entre Microsoft Excel y Google Sheets, pero la fundamentaci\u00f3n es la misma en ambos casos:<\/p>\n<ul>\n<li><strong>En Excel:<\/strong> <code>DIST.WEIBULL(x, alfa, beta, acumulado)<\/code><\/li>\n<li><strong>En Google Sheets:<\/strong> <code>DISTR.WEIBULL(x, alfa, beta, acumulado)<\/code><\/li>\n<\/ul>\n<p>Donde:<\/p>\n<ul>\n<li><strong>x<\/strong>: es el valor para el cual se quiere evaluar la funci\u00f3n.<\/li>\n<li><strong>alfa<\/strong>: es el par\u00e1metro de escala de la distribuci\u00f3n, debe ser positivo.<\/li>\n<li><strong>beta<\/strong>: es el par\u00e1metro de forma, tambi\u00e9n debe ser positivo.<\/li>\n<li><strong>acumulado<\/strong>: es un valor booleano (VERDADERO o FALSO) que indica si se debe retornar la funci\u00f3n de distribuci\u00f3n acumulativa (VERDADERO) o la funci\u00f3n densidad de probabilidad (FALSO).<\/li>\n<\/ul>\n<pre> <code>Ejemplo 1: Calcular la probabilidad de falla antes de 500 horas con alfa = 100 y beta = 1.5. F\u00f3rmula: =DIST.WEIBULL(500, 100, 1.5, VERDADERO)<\/code> <\/pre>\n<p>Este ejemplo calcula la probabilidad acumulada de que un producto falle antes de alcanzar las 500 horas.<\/p>\n<h2>Aplicaciones pr\u00e1cticas de la distribuci\u00f3n Weibull<\/h2>\n<h2>Escenario 1: An\u00e1lisis de vida \u00fatil de componentes electr\u00f3nicos<\/h2>\n<p>Consideremos una empresa que necesita estimar la vida \u00fatil de un componente electr\u00f3nico, cuyo tiempo hasta el fallo se modela mediante la distribuci\u00f3n Weibull con un par\u00e1metro de escala de 1200 horas y un par\u00e1metro de forma de 2.3.<\/p>\n<pre> <code>Para estimar la probabilidad de fallo antes de 1000 horas, usamos la f\u00f3rmula: =DIST.WEIBULL(1000, 1200, 2.3, VERDADERO)<\/code> <\/pre>\n<p>Este c\u00e1lculo es \u00fatil para planificar el mantenimiento preventivo o realizar estimaciones para garant\u00edas de productos.<\/p>\n<h2>Escenario 2: Evaluaci\u00f3n de la fiabilidad de materiales<\/h2>\n<p>En el sector de la construcci\u00f3n, comprender la fiabilidad de ciertos materiales bajo condiciones de tensi\u00f3n o con el tiempo es cr\u00edtico. Supongamos que deseamos evaluar la probabilidad de que un material espec\u00edfico dure m\u00e1s de 5000 horas, con par\u00e1metros alfa de 4000 horas y beta de 3.5.<\/p>\n<pre> <code>Se calcular\u00eda la probabilidad de que el material dure m\u00e1s all\u00e1 de 5000 horas con la f\u00f3rmula: =1 - DIST.WEIBULL(5000, 4000, 3.5,...)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Calcula la varianza en funci\u00f3n de toda la poblaci\u00f3n, incluidos n\u00fameros, texto y valores l\u00f3gicos<\/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-14267","post","type-post","status-publish","format-standard","hentry","category-compatibilidad"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n WEIBULL (DIST.WEIBULL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n WEIBULL (DIST.WEIBULL) 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\/weibull\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n WEIBULL (DIST.WEIBULL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n WEIBULL (DIST.WEIBULL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/weibull\/\" \/>\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-26T09:01:41+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 WEIBULL (DIST.WEIBULL) 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\/weibull\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/weibull\/\",\"name\":\"Funci\u00f3n WEIBULL (DIST.WEIBULL) 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-26T09:01:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n WEIBULL (DIST.WEIBULL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/weibull\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/weibull\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/weibull\/#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\":\"DIST.WEIBULL\"}]},{\"@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 WEIBULL (DIST.WEIBULL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n WEIBULL (DIST.WEIBULL) 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\/weibull\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n WEIBULL (DIST.WEIBULL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n WEIBULL (DIST.WEIBULL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/weibull\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T09:01:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n WEIBULL (DIST.WEIBULL) 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\/weibull\/","url":"https:\/\/functiontranslator.com\/es\/weibull\/","name":"Funci\u00f3n WEIBULL (DIST.WEIBULL) 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-26T09:01:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n WEIBULL (DIST.WEIBULL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/weibull\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/weibull\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/weibull\/#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":"DIST.WEIBULL"}]},{"@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\/14267","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=14267"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14267\/revisions"}],"predecessor-version":[{"id":30396,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14267\/revisions\/30396"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}