{"id":6814,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-student-inverse\/"},"modified":"2021-02-26T08:15:20","modified_gmt":"2021-02-26T08:15:20","slug":"tinv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/tinv\/","title":{"rendered":"LOI.STUDENT.INVERSE"},"content":{"rendered":"

Description et syntaxe<\/h2>\n

La fonction LOI.STUDENT.INVERSE<\/strong> dans Excel et TINV<\/strong> dans Google Sheets permet de calculer l’inverse de la distribution de Student, souvent utilis\u00e9e pour comparer deux \u00e9chantillons dans des tests statistiques. Cette fonction d\u00e9termine la valeur t correspondant \u00e0 une probabilit\u00e9 sp\u00e9cifique avec un nombre donn\u00e9 de degr\u00e9s de libert\u00e9.<\/p>\n

Syntaxe dans Excel :<\/p>\n

=LOI.STUDENT.INVERSE(probabilit\u00e9; degr\u00e9s_libert\u00e9)<\/code><\/pre>\n
Syntaxe dans Google Sheets :<\/p>\n
=TINV(probabilit\u00e9; degr\u00e9s_libert\u00e9)<\/code><\/pre>\n
    \n
  • probabilit\u00e9<\/strong> : La probabilit\u00e9 associ\u00e9e \u00e0 la distribution t de Student. Ce param\u00e8tre doit \u00eatre un nombre r\u00e9el compris entre 0 et 1.<\/li>\n
  • degr\u00e9s_libert\u00e9<\/strong> : Le nombre de degr\u00e9s de libert\u00e9 de la distribution. Ce doit \u00eatre un entier positif.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Voici quelques exemples illustrant l’utilisation de la fonction LOI.STUDENT.INVERSE :<\/p>\n
    =LOI.STUDENT.INVERSE(0.05; 10)<\/code><\/pre>\n
    Cette formule donne la valeur t pour une probabilit\u00e9 de 0.05 et 10 degr\u00e9s de libert\u00e9. Elle est typiquement utilis\u00e9e dans les tests d’hypoth\u00e8ses pour d\u00e9terminer si deux moyennes diff\u00e8rent de mani\u00e8re statistiquement significative \u00e0 un niveau de confiance de 95%.<\/p>\n
    Applications pratiques<\/h2>\n
    Test d’hypoth\u00e8se pour comparer deux moyennes<\/h3>\n
    Si vous analysez les performances de deux groupes d’\u00e9tudiants et souhaitez v\u00e9rifier si elles diff\u00e8rent significativement, utilisez la fonction LOI.STUDENT.INVERSE pour obtenir la valeur t critique \u00e0 comparer avec la valeur t calcul\u00e9e.<\/p>\n
    =LOI.STUDENT.INVERSE(0.025; 20)<\/code><\/pre>\n
    Cette formule \u00e9value la valeur t pour un test \u00e0 deux queues avec une probabilit\u00e9 totale de 0.05 (0.025 par queue) et 20 degr\u00e9s de libert\u00e9. Si la valeur t calcul\u00e9e exc\u00e8de la valeur obtenue, la diff\u00e9rence entre les groupes est consid\u00e9r\u00e9e comme statistiquement significative.<\/p>\n
    Analyse de la fiabilit\u00e9 des produits<\/h3>\n
    Pour comparer la durabilit\u00e9 de diff\u00e9rents mat\u00e9riaux ou produits dans un contexte industriel, les ing\u00e9nieurs peuvent collecter des donn\u00e9es sur la dur\u00e9e de vie des produits et utiliser cette fonction pour tester l’existence de diff\u00e9rences significatives.<\/p>\n\n\n\n\n
    Type de Produit<\/th>\nDur\u00e9e de vie moyenne (jours)<\/th>\nVariance<\/th>\n\u00c9chantillon (n)<\/th>\n<\/tr>\n
    Produit A<\/td>\n365<\/td>\n45<\/td>\n30<\/td>\n<\/tr>\n
    Produit B<\/td>\n342<\/td>\n40<\/td>\n30<\/td>\n<\/tr>\n<\/table>\n
    =LOI.STUDENT.INVERSE(0.025; 58)<\/code><\/pre>\n
    Si l’analyse s’appuie sur 59 degr\u00e9s de libert\u00e9 (n1 + n2 – 2) et que la valeur t calcul\u00e9e pour comparer la dur\u00e9e de vie moyenne des produits A et B d\u00e9passe la valeur obtenue, alors une diff\u00e9rence significative est d\u00e9montr\u00e9e.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie, pouR une pRobabilit\u00e9 donn\u00e9e, la valeuR 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":[317],"tags":[],"class_list":["post-6814","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction TINV (LOI.STUDENT.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TINV (LOI.STUDENT.INVERSE) 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\/tinv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TINV (LOI.STUDENT.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TINV (LOI.STUDENT.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/tinv\/\" \/>\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:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TINV (LOI.STUDENT.INVERSE) 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\/tinv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/tinv\/\",\"name\":\"Fonction TINV (LOI.STUDENT.INVERSE) 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:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TINV (LOI.STUDENT.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/tinv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/tinv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/tinv\/#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\":\"LOI.STUDENT.INVERSE\"}]},{\"@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 TINV (LOI.STUDENT.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TINV (LOI.STUDENT.INVERSE) 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\/tinv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TINV (LOI.STUDENT.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TINV (LOI.STUDENT.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/tinv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TINV (LOI.STUDENT.INVERSE) 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\/tinv\/","url":"https:\/\/functiontranslator.com\/fr\/tinv\/","name":"Fonction TINV (LOI.STUDENT.INVERSE) 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:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TINV (LOI.STUDENT.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/tinv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/tinv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/tinv\/#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":"LOI.STUDENT.INVERSE"}]},{"@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\/6814","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=6814"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6814\/revisions"}],"predecessor-version":[{"id":29823,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6814\/revisions\/29823"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}