{"id":6535,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-f-n\/"},"modified":"2021-02-26T08:06:03","modified_gmt":"2021-02-26T08:06:03","slug":"f-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/f-dist\/","title":{"rendered":"LOI.F.N"},"content":{"rendered":"<h2>Description de la fonction<\/h2>\n<p>La fonction <strong>LOI.F.N<\/strong> dans Microsoft Excel et Google Sheets sert \u00e0 calculer la probabilit\u00e9 de la distribution F de Fisher-Snedecor. Cette distribution continue est cruciale en statistiques, particuli\u00e8rement pour les analyses de variance (ANOVA). Elle est utilis\u00e9e pour \u00e9valuer si les variances de deux s\u00e9ries de donn\u00e9es diff\u00e8rent, sugg\u00e9rant ainsi des diff\u00e9rences entre les populations en termes de variabilit\u00e9.<\/p>\n<h2>Syntaxe de la fonction<\/h2>\n<p>Voici la syntaxe de la fonction <strong>LOI.F.N<\/strong> :<\/p>\n<pre><code>=LOI.F.N(x; deg_freedom1; deg_freedom2; cumulative)<\/code><\/pre>\n<ul>\n<li><strong>x<\/strong> : La valeur pour laquelle la fonction est \u00e9valu\u00e9e.<\/li>\n<li><strong>deg_freedom1<\/strong> : Les degr\u00e9s de libert\u00e9 du num\u00e9rateur, repr\u00e9sentant le nombre de degr\u00e9s de libert\u00e9 associ\u00e9s \u00e0 l&rsquo;estimation de la premi\u00e8re variance.<\/li>\n<li><strong>deg_freedom2<\/strong> : Les degr\u00e9s de libert\u00e9 du d\u00e9nominateur, pour l&rsquo;estimation de la seconde variance.<\/li>\n<li><strong>cumulative<\/strong> : Param\u00e8tre bool\u00e9en qui d\u00e9finit le type de fonction :\n<ul>\n<li>TRUE ou 1 pour la fonction de distribution cumul\u00e9e.<\/li>\n<li>FALSE ou 0 pour la fonction de densit\u00e9 de probabilit\u00e9.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Exemples pratiques<\/h2>\n<p>Ci-dessous, quelques exemples d&rsquo;utilisation de la fonction <strong>LOI.F.N<\/strong> dans Excel et Google Sheets.<\/p>\n<h2>1. Tester l&rsquo;\u00e9galit\u00e9 des variances de deux \u00e9chantillons<\/h2>\n<p>Imaginez que vous disposez des r\u00e9sultats de deux groupes \u00e0 un test standardis\u00e9 et souhaitez v\u00e9rifier si la variabilit\u00e9 des scores est similaire. Apr\u00e8s avoir obtenu la variance des scores pour chaque groupe, vous utilisez la distribution F pour tester votre hypoth\u00e8se.<\/p>\n<pre><code> Var1 = 15; Var2 = 10; N1 = 30; N2 = 25; \/\/ Variances et tailles des \u00e9chantillons F_statistique = Var1 \/ Var2; \/\/ Calcul de la statistique F P_valeur = LOI.F.N(F_statistique, N1-1, N2-1, TRUE); \/\/ Calcul de la p-valeur <\/code><\/pre>\n<p>Si la <strong>P_valeur<\/strong> est inf\u00e9rieure \u00e0 votre seuil de signification (habituellement 0,05), l&rsquo;hypoth\u00e8se des variances \u00e9gales est rejet\u00e9e.<\/p>\n<h2>2. Application en ANOVA<\/h2>\n<p>L&rsquo;analyse de variance (ANOVA) est souvent utilis\u00e9e pour voir si les moyennes de trois groupes ou plus sont \u00e9quivalentes. La fonction LOI.F.N est essentielle pour calculer les p-valeurs dans le cadre d&rsquo;une ANOVA \u00e0 un facteur.<\/p>\n<pre><code> MS_Between = 120; \/\/ Moyenne des carr\u00e9s entre les groupes MS_Within = 30; \/\/ Moyenne des carr\u00e9s \u00e0 l'int\u00e9rieur des groupes df_between = 2; \/\/ Degr\u00e9s de libert\u00e9 entre les groupes df_within = 57; \/\/ Degr\u00e9s de libert\u00e9 \u00e0 l'int\u00e9rieur des groupes F = MS_Between \/ MS_Within; \/\/ Calcul de la statistique F P_valeur = LOI.F.N(F, df_between, df_within, TRUE); \/\/ Calcul de la p-valeur pour l'ANOVA <\/code><\/pre>\n<p>Une <strong>P_valeur<\/strong> basse (en g\u00e9n\u00e9ral inf\u00e9rieure \u00e0 0,05) sugg\u00e8re de rejeter l&rsquo;hypoth\u00e8se nulle selon laquelle les moyennes des groupes sont identiques.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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-6535","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction F.DIST (LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction F.DIST (LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction F.DIST (LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction F.DIST (LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/f-dist\/\" \/>\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: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 F.DIST (LOI.F.N) 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\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/f-dist\/\",\"name\":\"Fonction F.DIST (LOI.F.N) 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:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction F.DIST (LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/f-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/f-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/f-dist\/#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.N\"}]},{\"@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 (LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction F.DIST (LOI.F.N) 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\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction F.DIST (LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction F.DIST (LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/f-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction F.DIST (LOI.F.N) 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\/","url":"https:\/\/functiontranslator.com\/fr\/f-dist\/","name":"Fonction F.DIST (LOI.F.N) 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:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction F.DIST (LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/f-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/f-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/f-dist\/#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.N"}]},{"@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\/6535","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=6535"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6535\/revisions"}],"predecessor-version":[{"id":29547,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6535\/revisions\/29547"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}