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

La fonction LOI.F dans Excel et Google Sheets est utilis\u00e9e pour calculer la probabilit\u00e9 que la variable al\u00e9atoire d’une distribution F d\u00e9passe une certaine valeur sp\u00e9cifi\u00e9e. Elle est fr\u00e9quemment employ\u00e9e en statistique, notamment pour comparer les variances entre deux \u00e9chantillons de donn\u00e9es. Cette fonction est particuli\u00e8rement importante dans l’analyse de variance (ANOVA).<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction LOI.F est la suivante :<\/p>\n

=LOI.F(x, degr\u00e9s_libert\u00e91, degr\u00e9s_libert\u00e92)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • x<\/strong> : La valeur pour laquelle la fonction F est \u00e9valu\u00e9e.<\/li>\n
  • degr\u00e9s_libert\u00e91<\/strong> : Le nombre de degr\u00e9s de libert\u00e9 du num\u00e9rateur, un entier positif.<\/li>\n
  • degr\u00e9s_libert\u00e92<\/strong> : Le nombre de degr\u00e9s de libert\u00e9 du d\u00e9nominateur, \u00e9galement un entier positif.<\/li>\n<\/ul>\n
    Exemples d’utilisation pratique<\/h2>\n
    Exemple 1 : Comparaison de deux variances d’\u00e9chantillons<\/h2>\n
    Supposons que vous \u00e9valuez la performance de deux machines diff\u00e9rentes. Les performances mesur\u00e9es constituent deux jeux de donn\u00e9es distincts, et vous souhaitez d\u00e9terminer si l’\u00e9cart de performance entre ces machines est statistiquement significatif. Les donn\u00e9es recueillies sont les suivantes :<\/p>\n
      \n
    • Machine A : n = 15, variance = 4<\/li>\n
    • Machine B : n = 12, variance = 7<\/li>\n<\/ul>\n
      Employons la fonction LOI.F pour examiner si la diff\u00e9rence entre ces variances est statistiquement significative.<\/p>\n
      =LOI.F((4\/7), 14, 11)<\/code><\/pre>\n
      Dans cet exemple, \u00ab\u00a0(4\/7)\u00a0\u00bb repr\u00e9sente le ratio des variances (variance de A divis\u00e9e par la variance de B), \u00ab\u00a014\u00a0\u00bb (15-1) et \u00ab\u00a011\u00a0\u00bb (12-1) sont les degr\u00e9s de libert\u00e9 pour chaque \u00e9chantillon, respectivement.<\/p>\n
      La valeur retourn\u00e9e indiquera la probabilit\u00e9 que les deux variances diff\u00e8rent de mani\u00e8re statistiquement significative. Une valeur inf\u00e9rieure \u00e0 0.05, g\u00e9n\u00e9ralement, signale une diff\u00e9rence notable.<\/p>\n
      Exemple 2 : Application dans une ANOVA \u00e0 un facteur<\/h2>\n
      Imaginons qu’un biologiste souhaite comparer le taux de croissance de trois esp\u00e8ces de plantes dans des conditions environnementales identiques. Apr\u00e8s avoir collect\u00e9 et analys\u00e9 les donn\u00e9es, il calcule les variances intra-groupe et inter-groupe et d\u00e9sire d\u00e9terminer si les diff\u00e9rences observ\u00e9es dans le taux de croissance sont r\u00e9ellement significatives.<\/p>\n
      Variances calcul\u00e9es :<\/p>\n
        \n
      • Variance entre les groupes (inter-groupe) = 10<\/li>\n
      • Variance au sein des groupes (intra-groupe) = 5.5<\/li>\n<\/ul>\n
        =LOI.F((10\/5.5), 2, 27)<\/code><\/pre>\n
        \u00ab\u00a02\u00a0\u00bb repr\u00e9sente les degr\u00e9s de libert\u00e9 pour les trois groupes (3-1), et \u00ab\u00a027\u00a0\u00bb est le total des degr\u00e9s de libert\u00e9 internes aux groupes.<\/p>\n
        Le r\u00e9sultat de cette fonction r\u00e9v\u00e8le la probabilit\u00e9 que les variances observ\u00e9es traduisent de v\u00e9ritables diff\u00e9rences dans le taux de croissance des esp\u00e8ces, permettant au biologiste de tirer des conclusions sur son hypoth\u00e8se.<\/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":[317],"tags":[],"class_list":["post-6536","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction FDIST (LOI.F) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction FDIST (LOI.F) 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\/fdist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction FDIST (LOI.F) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction FDIST (LOI.F) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/fdist\/\" \/>\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:05+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction FDIST (LOI.F) 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\/fdist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/fdist\/\",\"name\":\"Fonction FDIST (LOI.F) 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:05+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction FDIST (LOI.F) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/fdist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/fdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/fdist\/#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.F\"}]},{\"@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 FDIST (LOI.F) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction FDIST (LOI.F) 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\/fdist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction FDIST (LOI.F) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction FDIST (LOI.F) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/fdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:05+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction FDIST (LOI.F) 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\/fdist\/","url":"https:\/\/functiontranslator.com\/fr\/fdist\/","name":"Fonction FDIST (LOI.F) 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:05+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction FDIST (LOI.F) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/fdist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/fdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/fdist\/#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.F"}]},{"@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\/6536","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=6536"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6536\/revisions"}],"predecessor-version":[{"id":29548,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6536\/revisions\/29548"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}