{"id":14075,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-log-norm\/"},"modified":"2021-02-26T08:53:22","modified_gmt":"2021-02-26T08:53:22","slug":"lognormdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/lognormdist\/","title":{"rendered":"DISTR.LOG.NORM"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

La funci\u00f3n DISTR.LOG.NORM, tambi\u00e9n conocida como LOGNORMDIST en ingl\u00e9s, disponible tanto en Microsoft Excel como en Google Sheets, se utiliza para calcular la funci\u00f3n de distribuci\u00f3n acumulativa logar\u00edtmico-normal. Esta distribuci\u00f3n es relevante cuando los valores de una variable, una vez logaritmizados, siguen una distribuci\u00f3n normal. Es especialmente \u00fatil en an\u00e1lisis financieros para modelar precios de acciones que no pueden ser negativos, adem\u00e1s de otros muchos campos de aplicaci\u00f3n. <\/p>\n

Sintaxis y Ejemplos de Uso<\/h2>\n

La sintaxis de la funci\u00f3n DISTR.LOG.NORM es la siguiente: <\/p>\n

DISTR.LOG.NORM(x, media, desviaci\u00f3n_est\u00e1ndar, [cumulativo])<\/code><\/pre>\n
    \n
  • x<\/b> – Valor al que se le calcula la distribuci\u00f3n.<\/li>\n
  • media<\/b> – Media de los logaritmos naturales de la distribuci\u00f3n.<\/li>\n
  • desviaci\u00f3n_est\u00e1ndar<\/b> – Desviaci\u00f3n est\u00e1ndar de los logaritmos naturales de la distribuci\u00f3n.<\/li>\n
  • cumulativo<\/b> (opcional) – Un valor l\u00f3gico que especifica el tipo de funci\u00f3n de distribuci\u00f3n a retornar: TRUE (valor predeterminado) para la funci\u00f3n de distribuci\u00f3n acumulativa; FALSE para la funci\u00f3n de densidad de probabilidad.<\/li>\n<\/ul>\n
    Ejemplo 1:<\/p>\n
      =DISTR.LOG.NORM(4, 3.5, 1.2) <\/code> <\/p>\n
     Este ejemplo devuelve la probabilidad acumulativa de que una variable aleatoria log-normal, con una media logar\u00edtmica de 3.5 y una desviaci\u00f3n est\u00e1ndar de 1.2, sea menor o igual a 4. <\/p>\n
    Ejemplo 2:<\/p>\n
      =DISTR.LOG.NORM(5, 3, 1, FALSO) <\/code> <\/p>\n
     Este caso calcula la densidad de probabilidad en x = 5 para una distribuci\u00f3n log-normal con una media logar\u00edtmica de 3 y una desviaci\u00f3n est\u00e1ndar de 1. <\/p>\n
    Casos Pr\u00e1cticos de Aplicaci\u00f3n<\/h2>\n
    Caso 1: Modelado de Precios de Acciones<\/h3>\n
     Supongamos que necesitamos estimar la probabilidad de que el precio de una acci\u00f3n, que se modela como una distribuci\u00f3n log-normal, exceda los $50. La media de los logaritmos de los precios hist\u00f3ricos es 3.6 y la desviaci\u00f3n est\u00e1ndar es 0.8. <\/p>\n
      1 - DISTR.LOG.NORM(50, 3.6, 0.8) <\/code> <\/pre>\n
     Esta operaci\u00f3n utiliza el complemento de la funci\u00f3n de distribuci\u00f3n acumulativa para determinar la probabilidad de que el precio de la acci\u00f3n sea superior a $50. <\/p>\n
    Caso 2: Evaluaci\u00f3n de Inversiones en Bienes Ra\u00edces<\/h3>\n
     Consideremos un inversor que eval\u00faa el rendimiento esperado de una propiedad cuyo valor sigue una distribuci\u00f3n log-normal. Si el valor esperado logar\u00edtmico es 4.2 y la desviaci\u00f3n est\u00e1ndar logar\u00edtmica es 0.5, calculamos la probabilidad de que la propiedad se revalorice m\u00e1s del 10% en un a\u00f1o. <\/p>\n
      Valor actual = 100 Valor deseado = 100 * 1.1 Probabilidad de aumento > 10% = 1 - DISTR.LOG.NORM(110, 4.2, 0.5) <\/code> <\/pre>\n
     Este an\u00e1lisis ayuda a los inversores a tomar decisiones basadas en probabilidades modeladas sobre la apreciaci\u00f3n esperada de la propiedad. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la distribuci\u00f3n logar\u00edtmico-normal acumulativa<\/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-14075","post","type-post","status-publish","format-standard","hentry","category-compatibilidad"],"acf":[],"yoast_head":"\nFunci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) 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\/lognormdist\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/lognormdist\/\" \/>\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:53:22+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 LOGNORMDIST (DISTR.LOG.NORM) 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\/lognormdist\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/lognormdist\/\",\"name\":\"Funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) 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:53:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/lognormdist\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/lognormdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/lognormdist\/#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.LOG.NORM\"}]},{\"@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 LOGNORMDIST (DISTR.LOG.NORM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) 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\/lognormdist\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/lognormdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:53:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) 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\/lognormdist\/","url":"https:\/\/functiontranslator.com\/es\/lognormdist\/","name":"Funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) 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:53:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n LOGNORMDIST (DISTR.LOG.NORM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/lognormdist\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/lognormdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/lognormdist\/#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.LOG.NORM"}]},{"@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\/14075","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=14075"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14075\/revisions"}],"predecessor-version":[{"id":30168,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14075\/revisions\/30168"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}