{"id":6687,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-normale-inverse-n\/"},"modified":"2021-02-26T08:11:01","modified_gmt":"2021-02-26T08:11:01","slug":"norm-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/norm-inv\/","title":{"rendered":"LOI.NORMALE.INVERSE.N"},"content":{"rendered":"

Introduction \u00e0 la fonction de distribution normale inverse<\/h2>\n

La fonction LOI.NORMALE.INVERSE.N (ou NORM.INV en anglais) dans Microsoft Excel et Google Sheets est un outil statistique puissant. Elle permet de d\u00e9terminer la valeur correspondant \u00e0 une probabilit\u00e9 donn\u00e9e pour une distribution normale sp\u00e9cifi\u00e9e. Cette fonction est couramment utilis\u00e9e dans les secteurs comme la finance, la recherche scientifique et l’ing\u00e9nierie, o\u00f9 l’analyse statistique est cruciale.<\/p>\n

Syntaxe et exemples d’utilisation<\/h2>\n

La syntaxe de la fonction est la suivante :<\/p>\n

 LOI.NORMALE.INVERSE.N(probabilit\u00e9; moyenne; \u00e9cart_type)<\/code> <\/pre>\n
Les param\u00e8tres sont d\u00e9finis comme suit :<\/p>\n
    \n
  • probabilit\u00e9<\/strong> : La probabilit\u00e9 associ\u00e9e \u00e0 la valeur inverse de la distribution normale. Cette valeur doit \u00eatre comprise entre 0 et 1.<\/li>\n
  • moyenne<\/strong> : La moyenne de la distribution normale.<\/li>\n
  • \u00e9cart_type<\/strong> : L’\u00e9cart type de la distribution normale. Cette valeur doit \u00eatre strictement positive.<\/li>\n<\/ul>\n
    Exemple d’application :<\/p>\n
     =LOI.NORMALE.INVERSE.N(0.85; 100; 15)<\/code> <\/pre>\n
    Dans cet exemple, la fonction d\u00e9termine la valeur de la variable pour une distribution normale avec une moyenne de 100 et un \u00e9cart type de 15, correspondant \u00e0 une probabilit\u00e9 cumulative de 85 %.<\/p>\n
    Applications pratiques<\/h2>\n
    Exemple 1 : D\u00e9termination de seuils en assurance qualit\u00e9<\/h2>\n
    Consid\u00e9rons une entreprise produisant des pi\u00e8ces dont les longueurs suivent une distribution normale, avec une moyenne de 10 cm et un \u00e9cart type de 0.5 cm. L’entreprise souhaite d\u00e9terminer la longueur minimale assurant que 95 % des pi\u00e8ces sont plus longues que ce seuil.<\/p>\n
     =LOI.NORMALE.INVERSE.N(0.05; 10; 0.5)<\/code> <\/pre>\n
    R\u00e9sultat : Cela indique la valeur minimale assurant que 95 % des pi\u00e8ces mesureront plus que ce seuil.<\/p>\n
    Exemple 2 : Finance et gestion des risques<\/h2>\n
    Un gestionnaire de portefeuille souhaite estimer le pire sc\u00e9nario de perte que son portefeuille pourrait conna\u00eetre au 10\u00e8me percentile, en supposant une distribution normale des rendements. Les rendements ont une moyenne de 5 % et un \u00e9cart type de 1.5 %.<\/p>\n
     =LOI.NORMALE.INVERSE.N(0.1; 0.05; 0.015)<\/code> <\/pre>\n
    R\u00e9sultat : La fonction fournit le rendement correspondant au 10\u00e8me percentile, une information cruciale pour \u00e9valuer et planifier face \u00e0 des sc\u00e9narios de march\u00e9 d\u00e9favorables.<\/p>\n
    En r\u00e9sum\u00e9, la fonction LOI.NORMALE.INVERSE.N est extr\u00eamement pr\u00e9cieuse pour analyser et prendre des d\u00e9cisions bas\u00e9es sur des mod\u00e8les de distribution statistique normale. Que ce soit pour fixer des seuils critiques en production ou pour la gestion des risques financiers, son utilisation peut significativement am\u00e9liorer la pr\u00e9vision et le contr\u00f4le de nombreux aspects essentiels des activit\u00e9s commerciales et scientifiques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie, pouR une pRobabilit\u00e9 donn\u00e9e, la valeuR d\u2019une vaRiable al\u00e9atoiRe suivant une loi noRmale<\/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-6687","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction NORM.INV (LOI.NORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NORM.INV (LOI.NORMALE.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\/norm-inv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NORM.INV (LOI.NORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NORM.INV (LOI.NORMALE.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\/norm-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:11:01+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NORM.INV (LOI.NORMALE.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\/norm-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/norm-inv\/\",\"name\":\"Fonction NORM.INV (LOI.NORMALE.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:11:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NORM.INV (LOI.NORMALE.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/norm-inv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/norm-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/norm-inv\/#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.NORMALE.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 NORM.INV (LOI.NORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NORM.INV (LOI.NORMALE.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\/norm-inv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NORM.INV (LOI.NORMALE.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NORM.INV (LOI.NORMALE.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/norm-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NORM.INV (LOI.NORMALE.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\/norm-inv\/","url":"https:\/\/functiontranslator.com\/fr\/norm-inv\/","name":"Fonction NORM.INV (LOI.NORMALE.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:11:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NORM.INV (LOI.NORMALE.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/norm-inv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/norm-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/norm-inv\/#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.NORMALE.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\/6687","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=6687"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6687\/revisions"}],"predecessor-version":[{"id":29698,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6687\/revisions\/29698"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}