{"id":6450,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/intervalle-confiance-normal\/"},"modified":"2021-02-26T08:03:28","modified_gmt":"2021-02-26T08:03:28","slug":"confidence-norm","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/confidence-norm\/","title":{"rendered":"INTERVALLE.CONFIANCE.NORMAL"},"content":{"rendered":"

Description et Syntaxe de la Fonction<\/h2>\n

La fonction INTERVALLE.CONFIANCE.NORMAL<\/code> dans Excel et Google Sheets calcule l’intervalle de confiance pour la moyenne d’une population, un outil indispensable en statistique pour \u00e9valuer o\u00f9 pourrait se situer la moyenne r\u00e9elle d’une population donn\u00e9e.<\/p>\n

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

=INTERVALLE.CONFIANCE.NORMAL(alpha; sigma; taille)<\/code><\/pre>\n
    \n
  • alpha<\/b> : Le niveau de signification, qui d\u00e9finit la probabilit\u00e9 que l’intervalle de confiance ne contienne pas la moyenne de la population. Un alpha de 0.05 correspond \u00e0 un intervalle de confiance de 95%.<\/li>\n
  • sigma<\/b> : L’\u00e9cart type de la population.<\/li>\n
  • taille<\/b> : Le nombre total d’observations dans l’\u00e9chantillon.<\/li>\n<\/ul>\n
    Exemples d’Utilisation<\/h2>\n
    Exemples d’application de cette fonction :<\/p>\n
      \n
    1. Pour calculer un intervalle de confiance \u00e0 95% d’une population dont l’\u00e9cart type est de 10 et la taille de l’\u00e9chantillon de 50 :<\/li>\n
      =INTERVALLE.CONFIANCE.NORMAL(0.05; 10; 50)<\/code><\/pre>\n
    2. Si vous d\u00e9sirez \u00e9tablir un intervalle de confiance \u00e0 90% pour un \u00e9chantillon de 100 individus avec un \u00e9cart type de 15 :<\/li>\n
      =INTERVALLE.CONFIANCE.NORMAL(0.10; 15; 100)<\/code><\/pre>\n<\/ol>\n
      Applications Pratiques<\/h2>\n
      Voici des sc\u00e9narios courants o\u00f9 l’usage de cette fonction est particuli\u00e8rement pertinent :<\/p>\n
      \u00c9valuation de la Satisfaction des Clients<\/h3>\n
      Une entreprise \u00e9value la satisfaction client \u00e0 partir d’un \u00e9chantillon de 200 individus, avec un \u00e9cart type de 7, souhaitant une confiance de 95% dans les r\u00e9sultats :<\/p>\n
      =INTERVALLE.CONFIANCE.NORMAL(0.05; 7; 200)<\/code><\/pre>\n
      Ce calcul fournit la marge d’erreur des scores de satisfaction moyens, ce qui permet \u00e0 l’entreprise de mieux comprendre la satisfaction g\u00e9n\u00e9rale de sa client\u00e8le bas\u00e9e sur l’\u00e9chantillon.<\/p>\n
      \u00c9tude sur la Consommation de Produits<\/h3>\n
      Dans une \u00e9tude de march\u00e9 centr\u00e9e sur la consommation d’un produit sp\u00e9cifique, avec un \u00e9chantillon de 250 consommateurs et un \u00e9cart type estim\u00e9 \u00e0 12, visant un niveau de confiance de 90% :<\/p>\n
      =INTERVALLE.CONFIANCE.NORMAL(0.10; 12; 250)<\/code><\/pre>\n
      Ce r\u00e9sultat instrumentalise le chercheur \u00e0 mieux cerner l’intervalle de confiance entourant la consommation moyenne pr\u00e9vue, offrant ainsi un aper\u00e7u plus d\u00e9taill\u00e9 des comportements de consommation relatifs au produit \u00e0 l’\u00e9tude.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie l\u2019inteRvalle de confiance pouR une moyenne de population<\/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-6450","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) 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\/confidence-norm\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/confidence-norm\/\" \/>\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:03:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) 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\/confidence-norm\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/confidence-norm\/\",\"name\":\"Fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) 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:03:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/confidence-norm\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/confidence-norm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/confidence-norm\/#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\":\"INTERVALLE.CONFIANCE.NORMAL\"}]},{\"@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 CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) 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\/confidence-norm\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/confidence-norm\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) 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\/confidence-norm\/","url":"https:\/\/functiontranslator.com\/fr\/confidence-norm\/","name":"Fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) 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:03:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CONFIDENCE.NORM (INTERVALLE.CONFIANCE.NORMAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/confidence-norm\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/confidence-norm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/confidence-norm\/#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":"INTERVALLE.CONFIANCE.NORMAL"}]},{"@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\/6450","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=6450"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6450\/revisions"}],"predecessor-version":[{"id":29462,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6450\/revisions\/29462"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}