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

Description de la fonction<\/h2>\n

La fonction LOI.LOGNORMALE.INVERSE<\/code> dans Excel et la fonction \u00e9quivalente LOGINV<\/code> dans Google Sheets permettent de d\u00e9terminer l’inverse de la distribution log-normale. Ces outils sont essentiels pour les analyses statistiques, en particulier dans les domaines de la finance et de l’assurance, o\u00f9 les mod\u00e8les de distribution des taux de croissance sont fr\u00e9quemment log-normaux.<\/p>\n

Syntaxe :<\/p>\n

LOI.LOGNORMALE.INVERSE(probabilit\u00e9; moy_log; \u00e9cart_type_log)<\/code><\/pre>\n
    \n
  • probabilit\u00e9<\/code> correspond \u00e0 la probabilit\u00e9 associ\u00e9e \u00e0 la distribution log-normale, devant \u00eatre strictement entre 0 et 1 (non inclus).<\/li>\n
  • moy_log<\/code> repr\u00e9sente la moyenne logarithmique de la distribution.<\/li>\n
  • \u00e9cart_type_log<\/code> indique l’\u00e9cart-type logarithmique de la distribution.<\/li>\n<\/ul>\n
    Exemples d’utilisation courante<\/h2>\n
    Voici des sc\u00e9narios illustrant l’utilisation de cette fonction :<\/p>\n
    Sc\u00e9nario 1 : Estimation de seuils de revenu<\/h2>\n
    Imaginons qu’une entreprise souhaite d\u00e9terminer le seuil de revenu sup\u00e9rieur pour les 10% des meilleures ventes, en admettant que les revenus suivent une distribution log-normale avec une moyenne log de 3 et un \u00e9cart-type log de 1.<\/p>\n
     =LOI.LOGNORMALE.INVERSE(0.9; 3; 1)<\/code> <\/pre>\n
    Ce calcul permet de conna\u00eetre le revenu au-del\u00e0 duquel se placent les 10% des ventes les plus \u00e9lev\u00e9es. Cette analyse peut aider l’entreprise \u00e0 d\u00e9finir des objectifs de vente ou \u00e0 \u00e9laborer des strat\u00e9gies de marketing cibl\u00e9es.<\/p>\n
    Sc\u00e9nario 2 : Mod\u00e9lisation de la dur\u00e9e de vie des produits<\/h2>\n
    Dans le secteur manufacturier, il est courant de mod\u00e9liser la dur\u00e9e de vie des produits. Si l’on suppose que cette dur\u00e9e suit une distribution log-normale avec une moyenne log de 4 et un \u00e9cart-type log de 0.5, un responsable de maintenance pourrait vouloir savoir apr\u00e8s combien de temps 5% des \u00e9quipements commenceront \u00e0 pr\u00e9senter des d\u00e9faillances :<\/p>\n
     =LOI.LOGNORMALE.INVERSE(0.05; 4; 0.5)<\/code> <\/pre>\n
    Cette information est cruciale pour la planification des maintenances pr\u00e9ventives ou pour prendre des d\u00e9cisions li\u00e9es au renouvellement des \u00e9quipements.<\/p>\n
    Commentaires suppl\u00e9mentaires<\/h2>\n
    Il est crucial d’utiliser correctement la fonction LOI.LOGNORMALE.INVERSE<\/code> ou LOGINV<\/code> pour r\u00e9aliser des pr\u00e9dictions pr\u00e9cises avec des donn\u00e9es suivant une distribution log-normale. Les param\u00e8tres de la moyenne et de l’\u00e9cart type doivent \u00eatre calcul\u00e9s sur le logarithme des valeurs mesur\u00e9es originellement pour obtenir des r\u00e9sultats valides. De plus, il est important de s’assurer que la probabilit\u00e9 entr\u00e9e reste bien entre 0 et 1 pour \u00e9viter des erreurs de calcul.<\/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":[317],"tags":[],"class_list":["post-6648","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction LOGINV (LOI.LOGNORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction LOGINV (LOI.LOGNORMALE.INVERSE) 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\/loginv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction LOGINV (LOI.LOGNORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction LOGINV (LOI.LOGNORMALE.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/loginv\/\" \/>\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:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction LOGINV (LOI.LOGNORMALE.INVERSE) 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\/loginv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/loginv\/\",\"name\":\"Fonction LOGINV (LOI.LOGNORMALE.INVERSE) 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:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction LOGINV (LOI.LOGNORMALE.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/loginv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/loginv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/loginv\/#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.INVERSE\"}]},{\"@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 LOGINV (LOI.LOGNORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction LOGINV (LOI.LOGNORMALE.INVERSE) 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\/loginv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction LOGINV (LOI.LOGNORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction LOGINV (LOI.LOGNORMALE.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/loginv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction LOGINV (LOI.LOGNORMALE.INVERSE) 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\/loginv\/","url":"https:\/\/functiontranslator.com\/fr\/loginv\/","name":"Fonction LOGINV (LOI.LOGNORMALE.INVERSE) 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:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction LOGINV (LOI.LOGNORMALE.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/loginv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/loginv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/loginv\/#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.INVERSE"}]},{"@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\/6648","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=6648"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6648\/revisions"}],"predecessor-version":[{"id":29659,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6648\/revisions\/29659"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}