{"id":6651,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-lognormale-inverse-n\/"},"modified":"2021-02-26T08:09:59","modified_gmt":"2021-02-26T08:09:59","slug":"lognorm-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/","title":{"rendered":"LOI.LOGNORMALE.INVERSE.N"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction LOI.LOGNORMALE.INVERSE.N<\/code> dans Microsoft Excel et LOGNORM.INV<\/code> dans Google Sheets est utilis\u00e9e pour calculer la valeur inverse de la distribution log-normale. Cette fonction est fr\u00e9quemment utilis\u00e9e en finance, en assurance et en ing\u00e9nierie pour mod\u00e9liser des distributions de valeurs qui croissent de mani\u00e8re exponentielle.<\/p>\n

Syntaxe<\/h2>\n

La syntaxe de la fonction diff\u00e8re l\u00e9g\u00e8rement entre Excel et Google Sheets :<\/p>\n

    \n
  • Excel<\/strong>: LOI.LOGNORMALE.INVERSE.N(probabilit\u00e9, moy_log, \u00e9cart_type_log)<\/code><\/li>\n
  • Google Sheets<\/strong>: LOGNORM.INV(probability, mean, standard_deviation)<\/code><\/li>\n<\/ul>\n

    O\u00f9 :<\/p>\n

      \n
    • probabilit\u00e9<\/code> (ou probability<\/code>) repr\u00e9sente la probabilit\u00e9 associ\u00e9e \u00e0 la valeur log-normale inverse souhait\u00e9e, qui doit se situer entre 0 et 1 (exclus).<\/li>\n
    • moy_log<\/code> (ou mean<\/code>) d\u00e9signe la moyenne des logarithmes de la distribution.<\/li>\n
    • \u00e9cart_type_log<\/code> (ou standard_deviation<\/code>) repr\u00e9sente l’\u00e9cart type des logarithmes de la distribution.<\/li>\n<\/ul>\n

      Exemples de syntaxe<\/h2>\n
       \/\/ Dans Microsoft Excel =LOI.LOGNORMALE.INVERSE.N(0.5, 4, 1.2) \/\/ Dans Google Sheets =LOGNORM.INV(0.5, 4, 1.2) <\/code> <\/pre>\n
      Pratique: Calcul du seuil de rentabilit\u00e9<\/h2>\n
      Supposons que vous souhaitez estimer le seuil de rentabilit\u00e9 d’un nouveau produit dont les co\u00fbts de production suivent une distribution log-normale avec une moyenne de 3,5 et un \u00e9cart type de 0,8.<\/p>\n
       \/\/ Calcul du seuil de rentabilit\u00e9 au 50e percentile =LOI.LOGNORMALE.INVERSE.N(0.5, 3.5, 0.8) <\/code> <\/pre>\n
      Cette formule fournit la valeur moyenne du co\u00fbt n\u00e9cessaire pour atteindre le 50e percentile, offrant une estimation fiable de la valeur la plus probable pour le seuil de rentabilit\u00e9.<\/p>\n
      Application en gestion de risque<\/h2>\n
      Dans le domaine de la gestion des risques, notamment pour les projets d’ing\u00e9nierie ou de construction, il est crucial de pouvoir estimer les co\u00fbts extr\u00eames potentiels qui pourraient largement d\u00e9passer la moyenne.<\/p>\n
       \/\/ Estimation du co\u00fbt maximal dans les pires 5% des cas =LOI.LOGNORMALE.INVERSE.N(0.95, 3.5, 0.8) <\/code> <\/pre>\n
      Ce calcul permet d’identifier un co\u00fbt qui ne sera d\u00e9pass\u00e9 que dans les 5% des cas les plus on\u00e9reux, facilitant ainsi la pr\u00e9paration de dispositifs financiers de contingence ad\u00e9quats par les gestionnaires de projet.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie l\u2019inveRse de la fonction de distRibution suivant une loi lognoRmale cumul\u00e9e<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[315],"tags":[],"class_list":["post-6651","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) 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\/lognorm-inv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/\" \/>\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:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) 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\/lognorm-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/\",\"name\":\"Fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) 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:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiques\",\"item\":\"https:\/\/functiontranslator.com\/fr\/statistiques\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LOI.LOGNORMALE.INVERSE.N\"}]},{\"@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 LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) 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\/lognorm-inv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) 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\/lognorm-inv\/","url":"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/","name":"Fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) 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:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction LOGNORM.INV (LOI.LOGNORMALE.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/lognorm-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/lognorm-inv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Statistiques","item":"https:\/\/functiontranslator.com\/fr\/statistiques\/"},{"@type":"ListItem","position":3,"name":"LOI.LOGNORMALE.INVERSE.N"}]},{"@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\/6651","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=6651"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6651\/revisions"}],"predecessor-version":[{"id":29662,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6651\/revisions\/29662"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}