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

Description et Syntaxe<\/h2>\n

La fonction LOI.NORMALE.STANDARD.N<\/strong> dans Excel et Google Sheets est con\u00e7ue pour \u00e9valuer la fonction de distribution normale standard. Elle applique une loi normale o\u00f9 la moyenne est de z\u00e9ro et l’\u00e9cart-type est d’un, ce qui est essentiel en statistique pour le calcul des probabilit\u00e9s associ\u00e9es \u00e0 la courbe normale standard.<\/p>\n

=LOI.NORMALE.STANDARD.N(z, cumulatif)<\/code><\/pre>\n
    \n
  • z<\/code> : la valeur z pour laquelle la distribution est calcul\u00e9e.<\/li>\n
  • cumulatif<\/code> : un bool\u00e9en indiquant le mode de calcul. Mettre \u00e0 VRAI pour obtenir la fonction de distribution cumul\u00e9e, ou FAUX pour la fonction de densit\u00e9 de probabilit\u00e9.<\/li>\n<\/ul>\n
    Exemple de syntaxe :<\/p>\n
    =LOI.NORMALE.STANDARD.N(1.96, VRAI)<\/code><\/pre>\n
    Cette formule retournera la probabilit\u00e9 qu’une variable al\u00e9atoire suivant une distribution normale standard soit inf\u00e9rieure ou \u00e9gale \u00e0 1.96.<\/p>\n
    Cas pratiques d’utilisation<\/h2>\n
    Calcul de valeurs critiques dans les tests statistiques<\/h3>\n
    Un usage fr\u00e9quent de la fonction LOI.NORMALE.STANDARD.N est dans le calcul des valeurs critiques pour les tests d’hypoth\u00e8se statistiques. Par exemple, pour d\u00e9terminer une valeur critique avec un niveau alpha de 0.05 (dans un test unilateral \u00e0 droite) :<\/p>\n
    =LOI.NORMALE.STANDARD.N(0.05, FAUX)<\/code><\/pre>\n
    La fonction retourne environ 0.0398, repr\u00e9sentant la probabilit\u00e9 d’observer une valeur plus extr\u00eame sous l’hypoth\u00e8se nulle.<\/p>\n
    \u00c9valuation de la Probabilit\u00e9<\/h3>\n
    Pour estimer la probabilit\u00e9 que la valeur z soit inf\u00e9rieure \u00e0 -1.645 (dans le cas d’un test unilateral \u00e0 gauche) :<\/p>\n
    =LOI.NORMALE.STANDARD.N(-1.645, VRAI)<\/code><\/pre>\n
    Le r\u00e9sultat est approximativement 0.0505, indiquant la probabilit\u00e9 que la variable normale standard soit inf\u00e9rieure \u00e0 cette valeur.<\/p>\n
    Tableau R\u00e9capitulatif<\/h2>\n\n\n\n\n
    Fonction<\/th>\nParam\u00e8tre<\/th>\nDescription<\/th>\n<\/tr>\n
    LOI.NORMALE.STANDARD.N<\/td>\nz = 1.96<\/td>\nProbabilit\u00e9 cumul\u00e9e pour z \u2264 1.96<\/td>\n<\/tr>\n
    LOI.NORMALE.STANDARD.N<\/td>\nz = -1.645<\/td>\nProbabilit\u00e9 cumul\u00e9e pour z \u2264 -1.645<\/td>\n<\/tr>\n<\/table>\n
     Cet exemple incorpore une exprime formalis\u00e9e tout en pr\u00e9servant les informations techniques essentielles pour une application efficace de cette fonction dans Excel et Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe continue suivant une loi 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-6688","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction NORM.S.DIST (LOI.NORMALE.STANDARD.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NORM.S.DIST (LOI.NORMALE.STANDARD.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-dist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NORM.S.DIST (LOI.NORMALE.STANDARD.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NORM.S.DIST (LOI.NORMALE.STANDARD.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-dist\/\" \/>\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:02+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.DIST (LOI.NORMALE.STANDARD.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-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/\",\"name\":\"Fonction NORM.S.DIST (LOI.NORMALE.STANDARD.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:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NORM.S.DIST (LOI.NORMALE.STANDARD.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/#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.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.DIST (LOI.NORMALE.STANDARD.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NORM.S.DIST (LOI.NORMALE.STANDARD.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-dist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NORM.S.DIST (LOI.NORMALE.STANDARD.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NORM.S.DIST (LOI.NORMALE.STANDARD.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NORM.S.DIST (LOI.NORMALE.STANDARD.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-dist\/","url":"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/","name":"Fonction NORM.S.DIST (LOI.NORMALE.STANDARD.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:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NORM.S.DIST (LOI.NORMALE.STANDARD.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/norm-s-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/norm-s-dist\/#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.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\/6688","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=6688"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6688\/revisions"}],"predecessor-version":[{"id":29699,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6688\/revisions\/29699"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}