{"id":6537,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-f-droite\/"},"modified":"2021-02-26T08:06:12","modified_gmt":"2021-02-26T08:06:12","slug":"f-dist-rt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/","title":{"rendered":"LOI.F.DROITE"},"content":{"rendered":"

La fonction LOI.F.DROITE dans Microsoft Excel et Google Sheets est utilis\u00e9e pour calculer la probabilit\u00e9 qu’une valeur F d\u00e9passe un certain seuil. Cela est particuli\u00e8rement utile dans divers sc\u00e9narios analytiques, notamment les tests d’hypoth\u00e8ses statistiques. Elle retourne la probabilit\u00e9 \u00e0 l’extr\u00e9mit\u00e9 droite (sup\u00e9rieure) de la distribution F.<\/p>\n

Syntaxe et exemples<\/h2>\n

Voici la syntaxe de la fonction LOI.F.DROITE :<\/p>\n

 =LOI.F.DROITE(x, deg_freedom1, deg_freedom2) <\/code><\/pre>\n
    \n
  • x<\/code> : valeur de la statistique F pour laquelle vous voulez calculer la probabilit\u00e9 de d\u00e9passement.<\/li>\n
  • deg_freedom1<\/code> (degr\u00e9s de libert\u00e9 du num\u00e9rateur) : un entier indiquant le nombre de degr\u00e9s de libert\u00e9 du num\u00e9rateur.<\/li>\n
  • deg_freedom2<\/code> (degr\u00e9s de libert\u00e9 du d\u00e9nominateur) : un entier indiquant le nombre de degr\u00e9s de libert\u00e9 du d\u00e9nominateur.<\/li>\n<\/ul>\n
    Exemple :<\/b> Pour d\u00e9terminer la probabilit\u00e9 qu’une variable al\u00e9atoire suivant une distribution F avec 10 degr\u00e9s de libert\u00e9 dans le num\u00e9rateur et 20 dans le d\u00e9nominateur soit sup\u00e9rieure \u00e0 2.0 :<\/p>\n
     =LOI.F.DROITE(2.0, 10, 20) <\/code><\/pre>\n
    Ce calcul fournira la probabilit\u00e9 que la valeur F exc\u00e8de 2.0.<\/p>\n
    Applications pratiques<\/h2>\n
    Comparaison de deux variances de groupes<\/h2>\n
    Supposez que vous r\u00e9alisiez une \u00e9tude comparant les variances de deux groupes distincts pour v\u00e9rifier leur homog\u00e9n\u00e9it\u00e9. Les degr\u00e9s de libert\u00e9 des deux groupes sont respectivement de 15 et 20, et la valeur F calcul\u00e9e est de 1.5 :<\/p>\n
     =LOI.F.DROITE(1.5, 15, 20) <\/code><\/pre>\n
    Cette formule indiquera la probabilit\u00e9 que les diff\u00e9rences observ\u00e9es dans les variances soient dues au hasard, aidant ainsi \u00e0 d\u00e9terminer si elles sont statistiquement diff\u00e9rentes.<\/p>\n
    \u00c9valuation de mod\u00e8les de r\u00e9gression<\/h2>\n
    Dans l’analyse de r\u00e9gression, LOI.F.DROITE est fr\u00e9quemment utilis\u00e9e pour tester la significativit\u00e9 globale d’un mod\u00e8le de r\u00e9gression. Par exemple, pour un mod\u00e8le avec un F de 3.2, ayant 3 degr\u00e9s de libert\u00e9 pour le num\u00e9rateur et 36 pour l’erreur :<\/p>\n
     =LOI.F.DROITE(3.2, 3, 36) <\/code><\/pre>\n
    Cela permettra d’\u00e9valuer la probabilit\u00e9 que le mod\u00e8le ne soit pas significatif, facilitant la d\u00e9cision d’int\u00e9grer ou non des variables suppl\u00e9mentaires.<\/p>\n
    En somme, l’utilisation de LOI.F.DROITE permet de simplifier l’approche des questions statistiques complexes et fournit des insights pr\u00e9cieux pour les d\u00e9cisions bas\u00e9es sur les donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la distRibution de pRobabilit\u00e9 F<\/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-6537","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction F.DIST.RT (LOI.F.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction F.DIST.RT (LOI.F.DROITE) 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\/f-dist-rt\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction F.DIST.RT (LOI.F.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction F.DIST.RT (LOI.F.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/\" \/>\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:06:12+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction F.DIST.RT (LOI.F.DROITE) 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\/f-dist-rt\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/\",\"name\":\"Fonction F.DIST.RT (LOI.F.DROITE) 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:06:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction F.DIST.RT (LOI.F.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/#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.F.DROITE\"}]},{\"@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 F.DIST.RT (LOI.F.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction F.DIST.RT (LOI.F.DROITE) 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\/f-dist-rt\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction F.DIST.RT (LOI.F.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction F.DIST.RT (LOI.F.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction F.DIST.RT (LOI.F.DROITE) 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\/f-dist-rt\/","url":"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/","name":"Fonction F.DIST.RT (LOI.F.DROITE) 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:06:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction F.DIST.RT (LOI.F.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/f-dist-rt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/f-dist-rt\/#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.F.DROITE"}]},{"@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\/6537","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=6537"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6537\/revisions"}],"predecessor-version":[{"id":29549,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6537\/revisions\/29549"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}