{"id":6805,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-student-bilaterale\/"},"modified":"2021-02-26T08:15:03","modified_gmt":"2021-02-26T08:15:03","slug":"t-dist-2t","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/","title":{"rendered":"LOI.STUDENT.BILATERALE"},"content":{"rendered":"

Introduction \u00e0 la fonction LOI.STUDENT.BILATERALE<\/h2>\n

La fonction LOI.STUDENT.BILATERALE dans Excel, et son \u00e9quivalent T.DIST.2T dans Google Sheets, permet de calculer la probabilit\u00e9 bilat\u00e9rale dans une distribution de Student t. Ces fonctions sont essentielles pour r\u00e9aliser des tests de significativit\u00e9 en statistique, surtout quand la variance d’une population est inconnue et qu\u2019on analyse des \u00e9chantillons.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe dans Excel est :<\/p>\n

=LOI.STUDENT.BILATERALE(x; degr\u00e9s_libert\u00e9)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • x<\/strong> : la valeur t dont la probabilit\u00e9 doit \u00eatre calcul\u00e9e.<\/li>\n
  • degr\u00e9s_libert\u00e9<\/strong> : le nombre de degr\u00e9s de libert\u00e9 associ\u00e9s au test t.<\/li>\n<\/ul>\n
    Dans Google Sheets, la syntaxe est similaire :<\/p>\n
    =T.DIST.2T(x, degr\u00e9s_libert\u00e9)<\/code><\/pre>\n
    Exemples d’utilisation<\/h2>\n
    Imaginons un \u00e9chantillon pour lequel un test t affiche une valeur de 2.3 avec 15 degr\u00e9s de libert\u00e9. Pour calculer la probabilit\u00e9 des deux queues :<\/p>\n
    =LOI.STUDENT.BILATERALE(2.3, 15)<\/code><\/pre>\n
    Sur Google Sheets, la formule serait :<\/p>\n
    =T.DIST.2T(2.3, 15)<\/code><\/pre>\n
    Pratiques courantes<\/h2>\n
    Cette fonction est particuli\u00e8rement utile dans les cas suivants :<\/p>\n\n\n\n\n
    Sc\u00e9nario<\/th>\nUtilisation<\/th>\n<\/tr>\n
    Analyse de la significativit\u00e9 d’une diff\u00e9rence de moyennes entre deux \u00e9chantillons<\/td>\nUtilisation de LOI.STUDENT.BILATERALE pour \u00e9valuer si la diff\u00e9rence entre les moyennes de deux \u00e9chantillons est statistiquement significative.<\/td>\n<\/tr>\n
    \u00c9valuation des r\u00e9sultats d’une exp\u00e9rience par rapport \u00e0 une valeur th\u00e9orique<\/td>\nCalcul de la probabilit\u00e9 que le r\u00e9sultat obtenu soit aussi extr\u00eame ou plus, en r\u00e9f\u00e9rence \u00e0 une distribution t.<\/td>\n<\/tr>\n<\/table>\n
    Solution d\u00e9taill\u00e9e d’une t\u00e2che pratique<\/h2>\n
    Sc\u00e9nario :<\/strong> Un chercheur souhaite v\u00e9rifier si la moyenne de son \u00e9chantillon exp\u00e9rimental diff\u00e8re de mani\u00e8re significative de la moyenne th\u00e9orique. La valeur t est de 1.8 pour 20 degr\u00e9s de libert\u00e9.<\/p>\n
    \u00c9tapes :<\/strong><\/p>\n
      \n
    • Utiliser la fonction LOI.STUDENT.BILATERALE pour calculer la probabilit\u00e9 correspondante.<\/li>\n
    • Ins\u00e9rer la formule =LOI.STUDENT.BILATERALE(1.8, 20)<\/code> dans Excel ou =T.DIST.2T(1.8, 20)<\/code> dans Google Sheets.<\/li>\n
    • Examiner si cette probabilit\u00e9 est inf\u00e9rieure au seuil typique alpha de 0.05.<\/li>\n<\/ul>\n
      R\u00e9sultat :<\/strong> Si la fonction renvoie une valeur inf\u00e9rieure \u00e0 0.05, le chercheur peut conclure \u00e0 la significativit\u00e9 statistique de la diff\u00e9rence.<\/p>\n
      Ma\u00eetriser cette fonction permet donc d’appuyer solidement l’interpr\u00e9tation de r\u00e9sultats d\u2019exp\u00e9riences ou d\u2019\u00e9tudes gr\u00e2ce \u00e0 des analyses statistiques pr\u00e9cises.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe suivant la loi 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-6805","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction T.DIST.2T (LOI.STUDENT.BILATERALE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction T.DIST.2T (LOI.STUDENT.BILATERALE) 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-dist-2t\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction T.DIST.2T (LOI.STUDENT.BILATERALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction T.DIST.2T (LOI.STUDENT.BILATERALE) 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-dist-2t\/\" \/>\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:03+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.DIST.2T (LOI.STUDENT.BILATERALE) 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-dist-2t\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/\",\"name\":\"Fonction T.DIST.2T (LOI.STUDENT.BILATERALE) 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:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction T.DIST.2T (LOI.STUDENT.BILATERALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/#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\":\"LOI.STUDENT.BILATERALE\"}]},{\"@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.DIST.2T (LOI.STUDENT.BILATERALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction T.DIST.2T (LOI.STUDENT.BILATERALE) 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-dist-2t\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction T.DIST.2T (LOI.STUDENT.BILATERALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction T.DIST.2T (LOI.STUDENT.BILATERALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction T.DIST.2T (LOI.STUDENT.BILATERALE) 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-dist-2t\/","url":"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/","name":"Fonction T.DIST.2T (LOI.STUDENT.BILATERALE) 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:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction T.DIST.2T (LOI.STUDENT.BILATERALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/t-dist-2t\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/t-dist-2t\/#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":"LOI.STUDENT.BILATERALE"}]},{"@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\/6805","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=6805"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6805\/revisions"}],"predecessor-version":[{"id":29814,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6805\/revisions\/29814"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}