{"id":6650,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-lognormale\/"},"modified":"2021-02-26T08:09:57","modified_gmt":"2021-02-26T08:09:57","slug":"lognormdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/lognormdist\/","title":{"rendered":"LOI.LOGNORMALE"},"content":{"rendered":"

La fonction LOGNORMDIST<\/strong> dans Microsoft Excel et LOI.LOGNORMALE<\/strong> dans Google Sheets sont utilis\u00e9es pour calculer la distribution log-normale d’une variable al\u00e9atoire. Si une variable x est log-normalement distribu\u00e9e, cela signifie que le logarithme de x suit une distribution normale. Cette fonction est fr\u00e9quemment utilis\u00e9e dans les domaines de la finance, de l’\u00e9conomie et de l’ing\u00e9nierie pour mod\u00e9liser des variables qui ne prennent pas de valeurs n\u00e9gatives et dont la distribution pr\u00e9sente une large dispersion.<\/p>\n

Description du syst\u00e8me et syntaxe<\/h2>\n
    \n
  • Excel:<\/strong> LOGNORMDIST(x, moy_log, \u00e9cart_type_log)<\/li>\n
  • Google Sheets:<\/strong> LOI.LOGNORMALE(x, moy_log, \u00e9cart_type_log, cumulative)<\/li>\n<\/ul>\n

    Ces formules incluent :<\/p>\n

      \n
    • x<\/code> : la valeur pour laquelle la distribution est \u00e9valu\u00e9e. C’est la variable dont vous souhaitez conna\u00eetre la probabilit\u00e9 cumulative ou la densit\u00e9 de probabilit\u00e9.<\/li>\n
    • moy_log<\/code> : la moyenne du logarithme naturel de la distribution.<\/li>\n
    • \u00e9cart_type_log<\/code> : l’\u00e9cart-type du logarithme naturel de la distribution.<\/li>\n
    • cumulative<\/code> : un argument bool\u00e9en dans Google Sheets qui d\u00e9termine si la fonction doit retourner la distribution cumulative (TRUE) ou la densit\u00e9 de probabilit\u00e9 (FALSE).<\/li>\n<\/ul>\n

      Exemples :<\/strong><\/p>\n

        =LOGNORMDIST(150, 5, 1) \/\/ Utilisation dans Excel =LOI.LOGNORMALE(150, 5, 1, TRUE) \/\/ Utilisation dans Google Sheets pour la distribution cumulative <\/code> <\/pre>\n
      Applications pratiques<\/h2>\n
      1. Mod\u00e9lisation de revenus<\/h2>\n
      Consid\u00e9rez un scenario o\u00f9 vous \u00eates consultant financier et vous devez \u00e9valuer la probabilit\u00e9 qu’un investissement d\u00e9passe un certain retour, en sachant que les rendements suivent une distribution log-normale.<\/p>\n
        \/\/ Supposons que les rendements de l'investissement sont log-normalement distribu\u00e9s avec une moyenne de log-rendement de 4 et un \u00e9cart-type de 0.4 =LOGNORMDIST(200, 4, 0.4) \/\/ Excel =LOI.LOGNORMALE(200, 4, 0.4, TRUE) \/\/ Google Sheets <\/code> <\/pre>\n
      Cela permet de calculer la probabilit\u00e9 que l’investissement rapporte moins de 200. Pour obtenir la probabilit\u00e9 de d\u00e9passer ce montant, soustrayez cette valeur de 1.<\/p>\n
      2. Estimation de la dur\u00e9e de vie des produits<\/h2>\n
      Imaginez que vous \u00eates ing\u00e9nieur qualit\u00e9 cherchant \u00e0 estimer la dur\u00e9e de vie probable d’appareils \u00e9lectrom\u00e9nagers lors de tests de stress.<\/p>\n
        \/\/ Si la dur\u00e9e de vie des appareils est suppos\u00e9e suivre une distribution log-normale avec une moyenne de 3.5 et un \u00e9cart-type de 0.7 =LOGNORMDIST(5, 3.5, 0.7) \/\/ Excel =LOI.LOGNORMALE(5, 3.5, 0.7, TRUE) \/\/ Google Sheets <\/code> <\/pre>\n
      Cette commande fournira la probabilit\u00e9 que l’appareil cesse de fonctionner avant 5 ans.<\/p>\n
       This revised HTML content provides a clear and professional explanation of how to work with the log-normal distribution functions in Excel and Google Sheets, maintaining HTML tags for organization and readability.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe continue suivant une loi lognoRmale<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[317],"tags":[],"class_list":["post-6650","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction LOGNORMDIST (LOI.LOGNORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/lognormdist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction LOGNORMDIST (LOI.LOGNORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/lognormdist\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:09:57+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/lognormdist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/lognormdist\/\",\"name\":\"Fonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:09:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction LOGNORMDIST (LOI.LOGNORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/lognormdist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/lognormdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/lognormdist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilit\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/fr\/compatibilite\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LOI.LOGNORMALE\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction LOGNORMDIST (LOI.LOGNORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/lognormdist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction LOGNORMDIST (LOI.LOGNORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/lognormdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/lognormdist\/","url":"https:\/\/functiontranslator.com\/fr\/lognormdist\/","name":"Fonction LOGNORMDIST (LOI.LOGNORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:09:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction LOGNORMDIST (LOI.LOGNORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/lognormdist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/lognormdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/lognormdist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Compatibilit\u00e9","item":"https:\/\/functiontranslator.com\/fr\/compatibilite\/"},{"@type":"ListItem","position":3,"name":"LOI.LOGNORMALE"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6650"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6650\/revisions"}],"predecessor-version":[{"id":29661,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6650\/revisions\/29661"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}