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

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

La fonction LOI.NORMALE.STANDARD.INVERSE<\/code> dans Excel et NORMSINV<\/code> dans Google Sheets est utilis\u00e9e pour calculer le quantile z correspondant \u00e0 une probabilit\u00e9 sp\u00e9cifique p au sein d\u2019une distribution normale standard. Cette distribution est caract\u00e9ris\u00e9e par une moyenne de z\u00e9ro et un \u00e9cart-type de un. Elle joue un r\u00f4le crucial dans les analyses statistiques pour interpr\u00e9ter des probabilit\u00e9s donn\u00e9es.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe de la fonction dans MS Excel est :<\/p>\n

=LOI.NORMALE.STANDARD.INVERSE(probabilit\u00e9)<\/code><\/pre>\n
Tandis que dans Google Sheets, elle est :<\/p>\n
=NORMSINV(probabilit\u00e9)<\/code><\/pre>\n
Param\u00e8tre requis :<\/p>\n
    \n
  • probabilit\u00e9<\/strong> : Correspond \u00e0 la probabilit\u00e9 pour laquelle le quantile inverse normal est recherch\u00e9. Cette valeur doit \u00eatre strictement comprise entre 0 et 1 (exclus).<\/li>\n<\/ul>\n
    Exemples :<\/p>\n\n\n\n\n
    Formule<\/th>\nR\u00e9sultat<\/th>\nDescription<\/th>\n<\/tr>\n
    =LOI.NORMALE.STANDARD.INVERSE(0.95)<\/code><\/td>\n1.644853<\/td>\nCalcule le z-score correspondant \u00e0 une probabilit\u00e9 de 0.95 dans une distribution normale standard.<\/td>\n<\/tr>\n
    =NORMSINV(0.5)<\/code><\/td>\n0<\/td>\nFournit le z-score pour la m\u00e9diane de la distribution normale standard, soit une probabilit\u00e9 de 0.5.<\/td>\n<\/tr>\n<\/table>\n
    Applications pratiques<\/h2>\n
    Cette fonction est indispensable dans divers contextes statistiques et d’analyse de donn\u00e9es. Examinons quelques utilisations concr\u00e8tes :<\/p>\n
    Exemple 1: D\u00e9termination des seuils pour les tests statistiques<\/h2>\n
    Imaginez la mise en \u0153uvre d’un test d’hypoth\u00e8se utilisant une distribution normale o\u00f9 il est n\u00e9cessaire d’\u00e9tablir les valeurs critiques pour un taux d’erreur de type I de 5% (alpha = 0.05).<\/p>\n\n\n
    =LOI.NORMALE.STANDARD.INVERSE(1-0.025)<\/code><\/td>\n1.959964<\/td>\nIndique le z-score critique pour un intervalle de confiance de 95% dans un test \u00e0 deux queues.<\/td>\n<\/tr>\n<\/table>\n
    Exemple 2: Calcul de la capacit\u00e9 d\u2019ex\u00e9cution du processus<\/h2>\n
    Un ing\u00e9nieur qualit\u00e9 pourrait utiliser NORMSINV<\/code> pour identifier les am\u00e9liorations n\u00e9cessaires dans un processus de fabrication en \u00e9valuant la probabilit\u00e9 de non-conformit\u00e9s, comme 0.001 par exemple. Ce calcul aide \u00e0 cibler la production des pi\u00e8ces les plus \u00e0 risque :<\/p>\n\n\n
    =NORMSINV(0.001)<\/code><\/td>\n-3.090232<\/td>\nSignale combien de d\u00e9viations standard sous la moyenne se situent le 0,1% des pi\u00e8ces les moins conformes.<\/td>\n<\/tr>\n<\/table>\n
    En r\u00e9sum\u00e9, sous Excel ou Google Sheets, la fonction de distribution normale inverse constitue un outil analytique puissant, indispensable pour l\u2019interpr\u00e9tation statistique et l’\u00e9valuation des implications de probabilit\u00e9s dans des contextes de distribution normale.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie l\u2019inveRse de la distRibution cumul\u00e9e noRmale standaRd<\/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-6691","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction NORMSINV (LOI.NORMALE.STANDARD.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NORMSINV (LOI.NORMALE.STANDARD.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\/normsinv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NORMSINV (LOI.NORMALE.STANDARD.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NORMSINV (LOI.NORMALE.STANDARD.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\/normsinv\/\" \/>\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:06+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NORMSINV (LOI.NORMALE.STANDARD.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\/normsinv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/normsinv\/\",\"name\":\"Fonction NORMSINV (LOI.NORMALE.STANDARD.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:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NORMSINV (LOI.NORMALE.STANDARD.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/normsinv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/normsinv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/normsinv\/#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.STANDARD.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 NORMSINV (LOI.NORMALE.STANDARD.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NORMSINV (LOI.NORMALE.STANDARD.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\/normsinv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NORMSINV (LOI.NORMALE.STANDARD.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NORMSINV (LOI.NORMALE.STANDARD.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/normsinv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NORMSINV (LOI.NORMALE.STANDARD.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\/normsinv\/","url":"https:\/\/functiontranslator.com\/fr\/normsinv\/","name":"Fonction NORMSINV (LOI.NORMALE.STANDARD.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:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NORMSINV (LOI.NORMALE.STANDARD.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/normsinv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/normsinv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/normsinv\/#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.STANDARD.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\/6691","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=6691"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6691\/revisions"}],"predecessor-version":[{"id":29702,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6691\/revisions\/29702"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}