{"id":13956,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-exp\/"},"modified":"2021-02-26T08:47:03","modified_gmt":"2021-02-26T08:47:03","slug":"expondist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/expondist\/","title":{"rendered":"DISTR.EXP"},"content":{"rendered":"

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

La funci\u00f3n EXPONDIST en Microsoft Excel y DISTR.EXP en Google Sheets se utiliza para calcular la distribuci\u00f3n exponencial, crucial en an\u00e1lisis estad\u00edsticos que predicen el tiempo de espera hasta que ocurre un evento. Esta funci\u00f3n devuelve la probabilidad de que un evento suceda en un determinado intervalo de tiempo, asumiendo que los eventos se distribuyen de forma exponencial.<\/p>\n

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

=EXPONDIST(x, lambda, cumulativo)<\/code><\/pre>\n
y en Google Sheets:<\/p>\n
=DISTR.EXP(x, lambda, cumulativo)<\/code><\/pre>\n
    \n
  • x<\/strong>: el valor en el que se eval\u00faa la funci\u00f3n. Debe ser mayor o igual a 0.<\/li>\n
  • lambda<\/strong>: la tasa de ocurrencia de eventos o el par\u00e1metro de escala de la distribuci\u00f3n. Debe ser un valor positivo mayor a 0.<\/li>\n
  • cumulativo<\/strong>: un valor l\u00f3gico que especifica la forma de la funci\u00f3n. Si es VERDADERO, la funci\u00f3n devuelve la distribuci\u00f3n acumulativa; si es FALSO, devuelve la funci\u00f3n de densidad de probabilidad.<\/li>\n<\/ul>\n
    Ejemplos de Sintaxis<\/h2>\n
    Por ejemplo, para calcular la probabilidad de que un evento ocurra en menos de 3 minutos con una tasa de 2 eventos por minuto, la f\u00f3rmula en Excel ser\u00eda:<\/p>\n
    =EXPONDIST(3, 2, VERDADERO)<\/code><\/pre>\n
    En Google Sheets, ser\u00eda:<\/p>\n
    =DISTR.EXP(3, 2, VERDADERO)<\/code><\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    Evaluaci\u00f3n de Tiempos de Espera en un Centro de Llamadas<\/h3>\n
    Consideremos un centro de llamadas donde se quiere evaluar la probabilidad que los clientes esperen menos de 5 minutos. Con un lambda de 0.5 (un evento cada 0.5 minutos), la f\u00f3rmula ser\u00eda:<\/p>\n
    =EXPONDIST(5, 0.5, VERDADERO)<\/code><\/pre>\n
    Esta informaci\u00f3n permite a la gerencia planificar mejoras en el servicio al cliente basadas en datos concretos.<\/p>\n
    An\u00e1lisis de Fallas de Maquinaria<\/h3>\n
    En el contexto de una empresa que utiliza maquinaria pesada, es vital conocer el tiempo promedio antes de un fallo. Si una m\u00e1quina falla en promedio cada 200 horas, y se necesita saber la probabilidad de que funcione correctamente durante al menos 300 horas, la f\u00f3rmula adecuada ser\u00eda:<\/p>\n
    =EXPONDIST(300, 1\/200, FALSO)<\/code><\/pre>\n
    Este c\u00e1lculo es fundamental para programar mantenimientos y ajustar presupuestos, contribuyendo a una gesti\u00f3n eficiente de los recursos y la planificaci\u00f3n de la producci\u00f3n.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la distribuci\u00f3n exponencial<\/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-13956","post","type-post","status-publish","format-standard","hentry","category-compatibilidad"],"acf":[],"yoast_head":"\nFunci\u00f3n EXPONDIST (DISTR.EXP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n EXPONDIST (DISTR.EXP) 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\/expondist\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n EXPONDIST (DISTR.EXP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n EXPONDIST (DISTR.EXP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/expondist\/\" \/>\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:47:03+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 EXPONDIST (DISTR.EXP) 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\/expondist\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/expondist\/\",\"name\":\"Funci\u00f3n EXPONDIST (DISTR.EXP) 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:47:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n EXPONDIST (DISTR.EXP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/expondist\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/expondist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/expondist\/#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.EXP\"}]},{\"@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 EXPONDIST (DISTR.EXP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n EXPONDIST (DISTR.EXP) 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\/expondist\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n EXPONDIST (DISTR.EXP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n EXPONDIST (DISTR.EXP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/expondist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:47:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n EXPONDIST (DISTR.EXP) 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\/expondist\/","url":"https:\/\/functiontranslator.com\/es\/expondist\/","name":"Funci\u00f3n EXPONDIST (DISTR.EXP) 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:47:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n EXPONDIST (DISTR.EXP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/expondist\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/expondist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/expondist\/#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.EXP"}]},{"@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\/13956","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=13956"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13956\/revisions"}],"predecessor-version":[{"id":30017,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13956\/revisions\/30017"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13956"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}