{"id":6822,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/t-test\/"},"modified":"2021-02-26T08:15:40","modified_gmt":"2021-02-26T08:15:40","slug":"t-test","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/t-test\/","title":{"rendered":"T.TEST"},"content":{"rendered":"

Introduction \u00e0 la fonction de Test T<\/h2>\n

Le test T est une fonction statistique fr\u00e9quemment utilis\u00e9e dans Microsoft Excel et Google Sheets. Elle sert \u00e0 \u00e9valuer si deux \u00e9chantillons pr\u00e9sentent des moyennes statistiquement diff\u00e9rentes. Cette fonction est notamment pr\u00e9cieuse dans l’analyse de donn\u00e9es pour comparer les performances de deux groupes distincts.<\/p>\n

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

La syntaxe du test T dans Excel et Google Sheets est la suivante :<\/p>\n

 T.TEST(array1, array2, tails, type) <\/code><\/pre>\n
 O\u00f9 : <\/p>\n
    \n
  • array1<\/strong> : La premi\u00e8re plage de donn\u00e9es.<\/li>\n
  • array2<\/strong> : La seconde plage de donn\u00e9es.<\/li>\n
  • tails<\/strong> : Indique le nombre de queues de distribution (1 ou 2).<\/li>\n
  • type<\/strong> : Le type de test T (1 = paire, 2 = deux \u00e9chantillons \u00e9gaux en variance, 3 = deux \u00e9chantillons in\u00e9gaux en variance).<\/li>\n<\/ul>\n
    Voici un exemple d’application dans une feuille de calcul :<\/p>\n
     =T.TEST(A2:A10, B2:B10, 2, 3) <\/code><\/pre>\n
    Cet exemple illustre la comparaison de deux groupes de donn\u00e9es (A2:A10 et B2:B10) avec un test T \u00e0 deux queues et des variances in\u00e9gales.<\/p>\n
    Sc\u00e9narios pratiques d’application<\/h2>\n
    Explorons maintenant des cas concrets d’utilisation de cette fonction :<\/p>\n
    Cas d’utilisation 1 : Comparaison des performances de deux machines<\/h2>\n
    Imaginons que vous disposiez des r\u00e9sultats de performances de deux machines diff\u00e9rentes pour la production de pi\u00e8ces et vous souhaitez examiner si leur diff\u00e9rence de performance moyenne est statistiquement significative.<\/p>\n
     Donn\u00e9es : <\/p>\n
      \n
    • Machine A : 100, 102, 98, 94, 102<\/li>\n
    • Machine B : 92, 90, 91, 93, 94<\/li>\n<\/ul>\n
      La formule dans Excel ou Google Sheets serait :<\/p>\n
       =T.TEST(A2:A6, B2:B6, 2, 2) <\/code><\/pre>\n
      Cette formule utilise un test T \u00e0 deux queues en supposant que les variances sont \u00e9gales. Le r\u00e9sultat nous permettra de d\u00e9terminer si les performances des deux machines diff\u00e8rent significativement.<\/p>\n
      Cas d’utilisation 2 : \u00c9valuation de l’effet d’un traitement m\u00e9dical<\/h2>\n
      Consid\u00e9rez l’\u00e9valuation de l’efficacit\u00e9 d’un nouveau m\u00e9dicament. Avant et apr\u00e8s l’administration du m\u00e9dicament, certains indicateurs de sant\u00e9 sont mesur\u00e9s chez un groupe de patients.<\/p>\n
       Donn\u00e9es : <\/p>\n
        \n
      • Avant le traitement : 80, 85, 82, 78, 76<\/li>\n
      • Apr\u00e8s le traitement : 84, 87, 85, 88, 86<\/li>\n<\/ul>\n
        La formule pour tester l’efficacit\u00e9 du traitement serait :<\/p>\n
         =T.TEST(A2:A6, B2:B6, 1, 1) <\/code><\/pre>\n
        Cette approche utilise un test T \u00e0 une queue, anticipant une am\u00e9lioration des indices de sant\u00e9 d\u00fb au traitement, et suppose que les diff\u00e9rences sont li\u00e9es (les m\u00eames patients ayant \u00e9t\u00e9 mesur\u00e9s avant et apr\u00e8s).<\/p>\n
        Ces exemples illustrent comment la fonction peut \u00eatre mise en \u0153uvre dans des contextes industriels et m\u00e9dicaux pour r\u00e9aliser des analyses statistiques valides et pertinentes.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Renvoie la pRobabilit\u00e9 associ\u00e9e \u00e0 un test 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-6822","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction T.TEST dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction T.TEST 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\/t-test\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction T.TEST dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction T.TEST d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/t-test\/\" \/>\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:15:40+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction T.TEST 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\/t-test\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/t-test\/\",\"name\":\"Fonction T.TEST 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:15:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction T.TEST d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/t-test\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/t-test\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/t-test\/#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\":\"T.TEST\"}]},{\"@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 T.TEST dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction T.TEST 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\/t-test\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction T.TEST dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction T.TEST d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/t-test\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction T.TEST 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\/t-test\/","url":"https:\/\/functiontranslator.com\/fr\/t-test\/","name":"Fonction T.TEST 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:15:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction T.TEST d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/t-test\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/t-test\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/t-test\/#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":"T.TEST"}]},{"@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\/6822","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=6822"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6822\/revisions"}],"predecessor-version":[{"id":29831,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6822\/revisions\/29831"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}