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

La fonction INTERVALLE.CONFIANCE.STUDENT, \u00e9galement connue sous le nom de CONFIDENCE.T dans les versions anglaises de Microsoft Excel, permet de calculer l’intervalle de confiance pour la moyenne d’une population en s’appuyant sur une distribution t de Student. Elle est particuli\u00e8rement utile lorsque la taille de l’\u00e9chantillon est r\u00e9duite et que la variance de la population est inconnue.<\/p>\n

Syntaxe d\u00e9taill\u00e9e de la fonction<\/h2>\n

La syntaxe de la fonction INTERVALLE.CONFIANCE.STUDENT dans Excel est la suivante :<\/p>\n

INTERVALLE.CONFIANCE.STUDENT(alpha; taille_\u00e9chantillon; \u00e9cart_type)<\/strong><\/code><\/pre>\n
    \n
  • alpha<\/strong> : Le niveau d’importance utilis\u00e9 pour calculer l’intervalle de confiance. Correspond \u00e0 1 – (niveau de confiance\/100). Par exemple, pour un niveau de confiance de 95%, alpha sera de 0,05.<\/li>\n
  • taille_\u00e9chantillon<\/strong> : La taille de l’\u00e9chantillon.<\/li>\n
  • \u00e9cart_type<\/strong> : L’\u00e9cart type de l’\u00e9chantillon.<\/li>\n<\/ul>\n
    Exemples d’application<\/h2>\n
    Ci-dessous, quelques exemples d’utilisation de la fonction INTERVALLE.CONFIANCE.STUDENT dans divers sc\u00e9narios.<\/p>\n
    Exemple 1 : D\u00e9termination de l’intervalle de confiance d’un \u00e9chantillon<\/h2>\n
    Consid\u00e9rons un \u00e9chantillon de 25 mesures avec un \u00e9cart type de 4. Vous d\u00e9sirez calculer l’intervalle de confiance \u00e0 95% pour la moyenne de cet \u00e9chantillon.<\/p>\n
     =INTERVALLE.CONFIANCE.STUDENT(0.05; 25; 4)<\/code> <\/pre>\n
    En utilisant cette formule, Excel fournira l’intervalle de confiance pour la moyenne de l’\u00e9chantillon, en se basant sur une distribution t de Student, compte tenu de la petite taille de l’\u00e9chantillon.<\/p>\n
    Exemple 2 : Comparaison des niveaux de confiance<\/h2>\n
    Vous envisagez de comparer les intervalles de confiance pour le m\u00eame \u00e9chantillon en consid\u00e9rant diff\u00e9rents niveaux de confiance : 90%, 95% et 99%.<\/p>\n\n\n\n\n\n
    Niveau de confiance<\/th>\nAlpha<\/th>\nFormule<\/th>\nIntervalle de confiance<\/th>\n<\/tr>\n
    90%<\/td>\n0.1<\/td>\n=INTERVALLE.CONFIANCE.STUDENT(0.1; 25; 4)<\/code><\/td>\nR\u00e9sultat A<\/td>\n<\/tr>\n
    95%<\/td>\n0.05<\/td>\n=INTERVALLE.CONFIANCE.STUDENT(0.05; 25; 4)<\/code><\/td>\nR\u00e9sultat B<\/td>\n<\/tr>\n
    99%<\/td>\n0.01<\/td>\n=INTERVALLE.CONFIANCE.STUDENT(0.01; 25; 4)<\/code><\/td>\nR\u00e9sultat C<\/td>\n<\/tr>\n<\/table>\n
    Avec ces formules, vous observerez que plus le niveau de confiance est \u00e9lev\u00e9, plus l’intervalle de confiance s’\u00e9largit, refl\u00e9tant ainsi une plus grande incertitude autour de la moyenne estim\u00e9e.<\/p>\n
    Ces exemples illustrent comment utiliser la fonction INTERVALLE.CONFIANCE.STUDENT pour \u00e9valuer la pr\u00e9cision des estimations statistiques, notamment dans des situations o\u00f9 les tailles d’\u00e9chantillon sont limit\u00e9es et les variances de la population mal connues.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie l\u2019inteRvalle de confiance pouR la moyenne d\u2019une population, \u00e0 l\u2019aide d\u2019une distRibution t de Student<\/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-6451","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) 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-t\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) 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-t\/\" \/>\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:30+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.T (INTERVALLE.CONFIANCE.STUDENT) 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-t\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/confidence-t\/\",\"name\":\"Fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) 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:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/confidence-t\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/confidence-t\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/confidence-t\/#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.STUDENT\"}]},{\"@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.T (INTERVALLE.CONFIANCE.STUDENT) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) 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-t\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/confidence-t\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) 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-t\/","url":"https:\/\/functiontranslator.com\/fr\/confidence-t\/","name":"Fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) 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:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CONFIDENCE.T (INTERVALLE.CONFIANCE.STUDENT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/confidence-t\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/confidence-t\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/confidence-t\/#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.STUDENT"}]},{"@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\/6451","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=6451"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6451\/revisions"}],"predecessor-version":[{"id":29463,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6451\/revisions\/29463"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}