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

Description de la fonction LOI.NORMALE.INVERSE<\/h2>\n

La fonction LOI.NORMALE.INVERSE est cruciale dans le domaine de la mod\u00e9lisation statistique. Elle permet de d\u00e9terminer un seuil ou une valeur critique au sein d’une distribution normale. Cette fonction trouve fr\u00e9quemment son application dans des domaines tels que la finance, l’assurance qualit\u00e9 et la recherche scientifique, o\u00f9 il est n\u00e9cessaire d’estimer des seuils de risque, des limites de sp\u00e9cification ou d’autres param\u00e8tres fond\u00e9s sur une probabilit\u00e9 d\u00e9termin\u00e9e.<\/p>\n

Syntaxe et exemples<\/h2>\n

Voici la syntaxe de la fonction LOI.NORMALE.INVERSE dans Excel :<\/p>\n

=LOI.NORMALE.INVERSE(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 correspondant \u00e0 la valeur normale inverse d\u00e9sir\u00e9e, qui 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, qui doit \u00eatre un nombre positif.<\/li>\n<\/ul>\n
    Exemple :<\/strong> Pour trouver la valeur correspondant au 90e percentile (probabilit\u00e9 de 0,9) d’une distribution normale ayant une moyenne de 100 et un \u00e9cart-type de 15, utilisez :<\/p>\n
    =LOI.NORMALE.INVERSE(0,9; 100; 15)<\/code><\/pre>\n
    Cela donne environ 119,6, indiquant que 90% des valeurs sont inf\u00e9rieures \u00e0 119,6 dans cette distribution normale.<\/p>\n
    Applications pratiques<\/h2>\n
    La fonction LOI.NORMALE.INVERSE peut \u00eatre utilis\u00e9e dans une vari\u00e9t\u00e9 de contextes, comme d\u00e9montr\u00e9 ci-dessous :<\/p>\n
    D\u00e9termination de seuils de cr\u00e9dit<\/h2>\n
    Un \u00e9tablissement financier souhaitant \u00e9tablir des seuils de cr\u00e9dit pour minimiser les risques pourra s’appuyer sur cette fonction. Si la distribution des scores de cr\u00e9dit des clients est normalement distribu\u00e9e avec une moyenne de 680 et un \u00e9cart-type de 50, le seuil pour les 5% des clients les plus \u00e0 risque se calcule ainsi :<\/p>\n
    =LOI.NORMALE.INVERSE(0,05; 680; 50)<\/code><\/pre>\n
    Le r\u00e9sultat, environ 608, pourrait \u00eatre le seuil de cr\u00e9dit en dessous duquel les clients sont jug\u00e9s hautement risqu\u00e9s.<\/p>\n
    Contr\u00f4le qualit\u00e9 en production<\/h2>\n
    Un fabricant de pi\u00e8ces automobiles, cherchant \u00e0 garantir que 99% des pi\u00e8ces r\u00e9pondent \u00e0 un crit\u00e8re dimensionnel sp\u00e9cifique, pourrait se servir de cette fonction. Si la longueur des pi\u00e8ces suit une distribution normale avec une moyenne de 200 mm et un \u00e9cart-type de 2 mm, il trouverait la longueur maximale acceptable pour 99% des pi\u00e8ces comme suit :<\/p>\n
    =LOI.NORMALE.INVERSE(0,99; 200; 2)<\/code><\/pre>\n
    Ce calcul montre que les pi\u00e8ces devraient mesurer moins de 203,5 mm pour que 99% d\u2019entre elles r\u00e9pondent aux sp\u00e9cifications. Cette information est cruciale pour le r\u00e9glage des machines ou les inspections de qualit\u00e9.<\/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":[315],"tags":[],"class_list":["post-6686","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction NORMINV (LOI.NORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NORMINV (LOI.NORMALE.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\/norminv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NORMINV (LOI.NORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NORMINV (LOI.NORMALE.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\/norminv\/\" \/>\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:00+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NORMINV (LOI.NORMALE.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\/norminv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/norminv\/\",\"name\":\"Fonction NORMINV (LOI.NORMALE.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:11:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NORMINV (LOI.NORMALE.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/norminv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/norminv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/norminv\/#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.NORMALE.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 NORMINV (LOI.NORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NORMINV (LOI.NORMALE.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\/norminv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NORMINV (LOI.NORMALE.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NORMINV (LOI.NORMALE.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/norminv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NORMINV (LOI.NORMALE.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\/norminv\/","url":"https:\/\/functiontranslator.com\/fr\/norminv\/","name":"Fonction NORMINV (LOI.NORMALE.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:11:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NORMINV (LOI.NORMALE.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/norminv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/norminv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/norminv\/#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.NORMALE.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\/6686","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=6686"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6686\/revisions"}],"predecessor-version":[{"id":29697,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6686\/revisions\/29697"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}