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

Introduction \u00e0 la fonction LOI.NORMALE.STANDARD.INVERSE.N<\/h2>\n

La fonction LOI.NORMALE.STANDARD.INVERSE.N, \u00e9galement connue sous le nom de NORM.S.INV en anglais, est utilis\u00e9e aussi bien dans Microsoft Excel que dans Google Sheets pour calculer l’inverse de la fonction de distribution cumulative normale standard. Ce calcul est fondamental en statistiques pour identifier les valeurs seuils en rapport avec une probabilit\u00e9 donn\u00e9e au sein d’une distribution normale standard.<\/p>\n

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

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

=LOI.NORMALE.STANDARD.INVERSE.N(probabilit\u00e9)<\/code><\/pre>\n
O\u00f9 probabilit\u00e9<\/i> est la probabilit\u00e9 requise associ\u00e9e \u00e0 la distribution normale standard.<\/p>\n
Exemple 1:<\/strong> Pour d\u00e9terminer la valeur z correspondant \u00e0 une probabilit\u00e9 de 0,95 (95%).<\/p>\n
=LOI.NORMALE.STANDARD.INVERSE.N(0,95)<\/code><\/pre>\n
Cette requ\u00eate retourne environ 1,645, signifiant que 95% des valeurs sont inf\u00e9rieures \u00e0 1,645 dans une distribution normale standard.<\/p>\n
Exemple 2:<\/strong> Pour une probabilit\u00e9 de 0,05 (5%).<\/p>\n
=LOI.NORMALE.STANDARD.INVERSE.N(0,05)<\/code><\/pre>\n
Cette fonction renvoie approximativement -1,645, indiquant que 5% des valeurs sont en dessous de ce seuil dans une distribution normale standard.<\/p>\n
Sc\u00e9narios pratiques d’utilisation<\/h2>\n
1. D\u00e9termination des seuils de confiance en statistique<\/h2>\n
Dans la pratique, la fonction LOI.NORMALE.STANDARD.INVERSE.N est souvent utilis\u00e9e pour \u00e9tablir les seuils de confiance pour des analyses statistiques. Par exemple, un psychologue souhaitant fixer un seuil de confiance de 95% pour une \u00e9tude psychom\u00e9trique pourrait utiliser la formule suivante :<\/p>\n
=LOI.NORMALE.STANDARD.INVERSE.N(0,975)<\/code><\/pre>\n
Cette formule fournira environ 1,96, ce qui permet au psychologue d’affirmer avec 95% de confiance que les r\u00e9sultats de ses tests se trouveront au-dessus des 2,5% les plus bas et en dessous des 2,5% les plus hauts de la distribution normale.<\/p>\n
2. Mod\u00e9lisation financi\u00e8re et \u00e9valuation du risque<\/h2>\n
Dans le secteur financier, il est crucial de d\u00e9finir des seuils \u00e0 diff\u00e9rents niveaux de confiance pour \u00e9valuer le risque d’un investissement. Ainsi, un analyste financier d\u00e9sireux de consid\u00e9rer le risque associ\u00e9 au centile le plus extr\u00eame (1%) d’un portefeuille d’investissement utiliserait la formule :<\/p>\n
=LOI.NORMALE.STANDARD.INVERSE.N(0,01)<\/code><\/pre>\n
Le r\u00e9sultat, environ -2,326, aide l’analyste \u00e0 examiner les risques au-del\u00e0 de 99% de la distribution normale pr\u00e9sum\u00e9e des rendements. Cette information peut aider \u00e0 \u00e9laborer une strat\u00e9gie de gestion de risque ad\u00e9quate.<\/p>\n
Conclusion<\/h2>\n
En somme, la fonction LOI.NORMALE.STANDARD.INVERSE.N est essentielle en analyse statistique et en mod\u00e9lisation financi\u00e8re, permettant de quantifier et de comprendre les niveaux de risque ou de confiance associ\u00e9s \u00e0 des probabilit\u00e9s sp\u00e9cifiques dans une distribution normale standard. Ma\u00eetriser cet outil est indispensable pour une prise de d\u00e9cision efficace et \u00e9clair\u00e9e bas\u00e9e sur des donn\u00e9es de probabilit\u00e9.<\/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":[315],"tags":[],"class_list":["post-6690","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction NORM.S.INV (LOI.NORMALE.STANDARD.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NORM.S.INV (LOI.NORMALE.STANDARD.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-s-inv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NORM.S.INV (LOI.NORMALE.STANDARD.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NORM.S.INV (LOI.NORMALE.STANDARD.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-s-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:05+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.S.INV (LOI.NORMALE.STANDARD.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-s-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/norm-s-inv\/\",\"name\":\"Fonction NORM.S.INV (LOI.NORMALE.STANDARD.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:05+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NORM.S.INV (LOI.NORMALE.STANDARD.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/norm-s-inv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/norm-s-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/norm-s-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.NORMALE.STANDARD.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.S.INV (LOI.NORMALE.STANDARD.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NORM.S.INV (LOI.NORMALE.STANDARD.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-s-inv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NORM.S.INV (LOI.NORMALE.STANDARD.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NORM.S.INV (LOI.NORMALE.STANDARD.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/norm-s-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:05+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NORM.S.INV (LOI.NORMALE.STANDARD.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-s-inv\/","url":"https:\/\/functiontranslator.com\/fr\/norm-s-inv\/","name":"Fonction NORM.S.INV (LOI.NORMALE.STANDARD.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:05+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NORM.S.INV (LOI.NORMALE.STANDARD.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/norm-s-inv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/norm-s-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/norm-s-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.NORMALE.STANDARD.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\/6690","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=6690"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6690\/revisions"}],"predecessor-version":[{"id":29701,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6690\/revisions\/29701"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}