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

Pr\u00e9sentation g\u00e9n\u00e9rale<\/h2>\n

La fonction INTERVALLE.CONFIANCE est utilis\u00e9e pour calculer la largeur d’un intervalle de confiance pour la moyenne d’une population, ce qui est essentiel dans les domaines statistiques et de la recherche pour garantir la pr\u00e9cision des estimations.<\/p>\n

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

Voici la syntaxe de la fonction dans Excel :<\/p>\n

INTERVALLE.CONFIANCE(alpha, std_dev, size)<\/code><\/pre>\n
    \n
  • alpha<\/code> : Le niveau de signification de l’intervalle (1 – niveau de confiance). Par exemple, pour un intervalle de confiance de 95%, alpha est 0.05.<\/li>\n
  • std_dev<\/code> : L’\u00e9cart type de la population. L’utilisation de l’\u00e9cart type d’un \u00e9chantillon peut conduire \u00e0 des r\u00e9sultats diff\u00e9rents.<\/li>\n
  • size<\/code> : La taille de l’\u00e9chantillon utilis\u00e9 pour calculer l’intervalle.<\/li>\n<\/ul>\n
    Exemple d’utilisation :<\/p>\n
    Pour calculer un intervalle de confiance de 95% pour une moyenne estim\u00e9e de population, avec un \u00e9cart type de 4, bas\u00e9 sur un \u00e9chantillon de 30 individus, utilisez :<\/code><\/pre>\n
      =INTERVALLE.CONFIANCE(0.05, 4, 30) <\/code> <\/p>\n
    Cette formule calcule la marge d’erreur qui, ajout\u00e9e et soustraite \u00e0 la moyenne de l’\u00e9chantillon, d\u00e9finit l’intervalle de confiance.<\/p>\n
    Cas pratiques<\/h2>\n
    Cas 1 : Enqu\u00eate consommateur<\/h2>\n
    Une entreprise souhaite estimer la satisfaction moyenne de ses clients. Avec un \u00e9chantillon de 150 clients poss\u00e9dant un \u00e9cart type de 1.2, pour un intervalle de confiance \u00e0 90%, la formule est :<\/p>\n
      =INTERVALLE.CONFIANCE(0.1, 1.2, 150) <\/code> <\/p>\n
    Le r\u00e9sultat permet d’obtenir la marge d’erreur, qui, ajout\u00e9e et soustraite \u00e0 la moyenne estimative, donne l’intervalle de confiance souhait\u00e9.<\/p>\n
    Cas 2 : \u00c9tude scientifique<\/h2>\n
    Un biologiste analysant la croissance de plantes avec un \u00e9chantillon de 40 plantes et un \u00e9cart type de 2.5 souhaite \u00e9tablir un intervalle de confiance \u00e0 95% :<\/p>\n
      =INTERVALLE.CONFIANCE(0.05, 2.5, 40) <\/code> <\/p>\n
    La valeur obtenue, une fois ajout\u00e9e et soustraite \u00e0 la moyenne de l’\u00e9chantillon, d\u00e9finit l’intervalle dans lequel la moyenne r\u00e9elle devrait se situer avec 95% de confiance.<\/p>\n
    Ces exemples illustrent l’utilisation de la fonction INTERVALLE.CONFIANCE pour \u00e9valuer la fiabilit\u00e9 d’une estimation, offrant ainsi une fondation robuste pour prendre des d\u00e9cisions \u00e9clair\u00e9es dans divers domaines.<\/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":[317],"tags":[],"class_list":["post-6449","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction CONFIDENCE (INTERVALLE.CONFIANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CONFIDENCE (INTERVALLE.CONFIANCE) 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\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CONFIDENCE (INTERVALLE.CONFIANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CONFIDENCE (INTERVALLE.CONFIANCE) 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\/\" \/>\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:27+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 (INTERVALLE.CONFIANCE) 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\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/confidence\/\",\"name\":\"Fonction CONFIDENCE (INTERVALLE.CONFIANCE) 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:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CONFIDENCE (INTERVALLE.CONFIANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/confidence\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/confidence\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/confidence\/#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\":\"INTERVALLE.CONFIANCE\"}]},{\"@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 (INTERVALLE.CONFIANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CONFIDENCE (INTERVALLE.CONFIANCE) 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\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CONFIDENCE (INTERVALLE.CONFIANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CONFIDENCE (INTERVALLE.CONFIANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/confidence\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CONFIDENCE (INTERVALLE.CONFIANCE) 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\/","url":"https:\/\/functiontranslator.com\/fr\/confidence\/","name":"Fonction CONFIDENCE (INTERVALLE.CONFIANCE) 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:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CONFIDENCE (INTERVALLE.CONFIANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/confidence\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/confidence\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/confidence\/#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":"INTERVALLE.CONFIANCE"}]},{"@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\/6449","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=6449"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6449\/revisions"}],"predecessor-version":[{"id":29461,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6449\/revisions\/29461"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}