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

La fonction LOI.NORMALE<\/strong> dans Microsoft Excel et Google Sheets est utilis\u00e9e pour calculer la distribution normale d’un ensemble de donn\u00e9es. Cette fonction est essentielle en statistiques pour analyser la conformit\u00e9 des donn\u00e9es \u00e0 une moyenne sp\u00e9cifi\u00e9e. Elle offre la possibilit\u00e9 de calculer soit la fonction de densit\u00e9 de probabilit\u00e9 (PDF), soit la fonction de r\u00e9partition cumul\u00e9e (CDF) d’une variable al\u00e9atoire qui suit une distribution normale.<\/p>\n

Pr\u00e9sentation de la syntaxe<\/h2>\n

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

=LOI.NORMALE(x; moyenne; \u00e9cart_type; cumulative)<\/code><\/pre>\n
    \n
  • x<\/strong> : La valeur pour laquelle la distribution est calcul\u00e9e.<\/li>\n
  • moyenne<\/strong> : La moyenne de la distribution normale.<\/li>\n
  • \u00e9cart_type<\/strong> : L’\u00e9cart type de la distribution normale.<\/li>\n
  • cumulative<\/strong> : Un bool\u00e9en qui sp\u00e9cifie le type de r\u00e9sultat retourn\u00e9. Si TRUE, la fonction renvoie la distribution cumul\u00e9e ; si FALSE, elle produit la fonction de densit\u00e9 de probabilit\u00e9.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Illustrons par des exemples concrets l’utilisation de LOI.NORMALE<\/strong> :<\/p>\n\n\n\n\n
    Formule<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    \n
    =LOI.NORMALE(4; 5; 1; FAUX)<\/code><\/pre>\n<\/td>\n
    		Calcule la fonction de densit\u00e9 de probabilit\u00e9 pour x=4 avec une moyenne de 5 et un \u00e9cart type de 1.<\/td>\n0.2420<\/td>\n<\/tr>\n
    \n
    =LOI.NORMALE(4; 5; 1; VRAI)<\/code><\/pre>\n<\/td>\n
    		Calcule la distribution cumul\u00e9e pour x=4 avec une moyenne de 5 et un \u00e9cart type de 1.<\/td>\n0.1587<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios pratiques<\/h2>\n
    Sc\u00e9nario 1 : \u00c9valuation d’un seuil de test<\/strong><\/p>\n
    Consid\u00e9rons un enseignant analysant les scores \u00e0 un test, normalement distribu\u00e9s avec une moyenne de 70 et un \u00e9cart type de 10. Pour d\u00e9terminer le pourcentage d’\u00e9tudiants ayant obtenu moins de 60 :<\/p>\n
    =LOI.NORMALE(60; 70; 10; VRAI)<\/code><\/pre>\n
    Cette formule indique que 15.87% des \u00e9tudiants ont des scores inf\u00e9rieurs \u00e0 60.<\/p>\n
    Sc\u00e9nario 2 : Calcul de probabilit\u00e9 dans le contr\u00f4le qualit\u00e9<\/strong><\/p>\n
    Dans un contexte de contr\u00f4le qualit\u00e9, une entreprise consid\u00e8re un produit comme d\u00e9fectueux si ses mesures d\u00e9passent \u00b13 \u00e9carts-type autour de la moyenne du processus, fix\u00e9e \u00e0 8 avec un \u00e9cart type de 0.5. Pour calculer la probabilit\u00e9 qu’un produit soit non d\u00e9fectueux :<\/p>\n
    =1 - (LOI.NORMALE(6.5; 8; 0.5; VRAI) + (1 - LOI.NORMALE(9.5; 8; 0.5; VRAI)))<\/code><\/pre>\n
    Cette formule estime la probabilit\u00e9 que le produit reste dans l’intervalle [6.5, 9.5], sugg\u00e9rant une tr\u00e8s faible probabilit\u00e9 de d\u00e9fectuosit\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe continue 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-6685","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction NORMDIST (LOI.NORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NORMDIST (LOI.NORMALE) 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\/normdist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NORMDIST (LOI.NORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NORMDIST (LOI.NORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/normdist\/\" \/>\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:10:58+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NORMDIST (LOI.NORMALE) 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\/normdist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/normdist\/\",\"name\":\"Fonction NORMDIST (LOI.NORMALE) 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:10:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NORMDIST (LOI.NORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/normdist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/normdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/normdist\/#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\"}]},{\"@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 NORMDIST (LOI.NORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NORMDIST (LOI.NORMALE) 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\/normdist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NORMDIST (LOI.NORMALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NORMDIST (LOI.NORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/normdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NORMDIST (LOI.NORMALE) 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\/normdist\/","url":"https:\/\/functiontranslator.com\/fr\/normdist\/","name":"Fonction NORMDIST (LOI.NORMALE) 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:10:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NORMDIST (LOI.NORMALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/normdist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/normdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/normdist\/#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"}]},{"@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\/6685","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=6685"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6685\/revisions"}],"predecessor-version":[{"id":29696,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6685\/revisions\/29696"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}