{"id":6541,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/inverse-loi-f-n\/"},"modified":"2021-02-26T08:06:18","modified_gmt":"2021-02-26T08:06:18","slug":"f-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/f-inv\/","title":{"rendered":"INVERSE.LOI.F.N"},"content":{"rendered":"<h2>Description de la fonction<\/h2>\n<p>La fonction <code>F.INV<\/code> dans MS Excel et <code>INVERSE.LOI.F.N<\/code> dans Google Sheets sert \u00e0 calculer la valeur critique de la distribution F de Fisher-Snedecor pour une probabilit\u00e9 donn\u00e9e. Cette distribution est essentielle dans l&rsquo;analyse statistique, notamment en ANOVA (analyse de la variance), pour comparer les variances de diff\u00e9rentes populations et tirer des conclusions sur les \u00e9chantillons \u00e9tudi\u00e9s.<\/p>\n<h2>Syntaxe<\/h2>\n<p>Dans Excel, la syntaxe est :<\/p>\n<pre><code>F.INV(probabilit\u00e9, degr\u00e9s_de_libert\u00e91, degr\u00e9s_de_libert\u00e92)<\/code><\/pre>\n<p>Dans Google Sheets, la syntaxe est :<\/p>\n<pre><code>INVERSE.LOI.F.N(probabilit\u00e9, degr\u00e9s_de_libert\u00e91, degr\u00e9s_de_libert\u00e92)<\/code><\/pre>\n<p>Les param\u00e8tres sont d\u00e9finis comme suit :<\/p>\n<ul>\n<li><b>probabilit\u00e9<\/b> : Correspond \u00e0 la probabilit\u00e9 pour laquelle on souhaite trouver la valeur critique de F; cette valeur doit \u00eatre comprise entre 0 et 1.<\/li>\n<li><b>degr\u00e9s_de_libert\u00e91<\/b> : Nombre de degr\u00e9s de libert\u00e9 du num\u00e9rateur de la distribution F.<\/li>\n<li><b>degr\u00e9s_de_libert\u00e92<\/b> : Nombre de degr\u00e9s de libert\u00e9 du d\u00e9nominateur de la distribution F.<\/li>\n<\/ul>\n<h2>Exemples de calculs<\/h2>\n<p>Pour illustrer, si vous souhaitez d\u00e9terminer la valeur critique de F pour une ANOVA qui utilise un seuil de confiance de 95% avec 10 degr\u00e9s de libert\u00e9 au num\u00e9rateur et 20 au d\u00e9nominateur, utilisez la formule suivante :<\/p>\n<pre><code>=F.INV(0.95, 10, 20) \/\/ Dans Excel =INVERSE.LOI.F.N(0.95, 10, 20) \/\/ Dans Google Sheets<\/code><\/pre>\n<p>Cette formule donnera approximativement 2.1245, indiquant que la valeur de F doit d\u00e9passer 2.1245 pour rejeter l&rsquo;hypoth\u00e8se nulle \u00e0 95% de probabilit\u00e9.<\/p>\n<h2>Sc\u00e9narios pratiques d&rsquo;utilisation<\/h2>\n<h2>Test de la variance pour deux \u00e9chantillons<\/h2>\n<p>Supposons que vous vouliez tester si deux machines produisant le m\u00eame produit g\u00e9n\u00e8rent une variance comparable. En prenant des \u00e9chantillons de 15 et 18 cycles de production respectivement pour les machines, le test peut \u00eatre formul\u00e9 ainsi :<\/p>\n<pre><code>=F.INV(0.95, 15, 18) \/\/ Calcul avec Excel =INVERSE.LOI.F.N(0.95, 15, 18) \/\/ Calcul avec Google Sheets<\/code><\/pre>\n<p>Le r\u00e9sultat indicatif du seuil F critique permettra de comparer et de conclure si les variances sont similaires ou significativement diff\u00e9rentes.<\/p>\n<h2>Comparaison des groupes en ANOVA<\/h2>\n<p>Dans le cadre d&rsquo;une ANOVA \u00e0 un facteur portant sur trois groupes, supposant que l&rsquo;analyse a r\u00e9sult\u00e9 en 5 degr\u00e9s de libert\u00e9 pour le num\u00e9rateur et 10 pour le d\u00e9nominateur, et que nous cherchons la valeur critique de F pour un niveau de confiance de 99%, la proc\u00e9dure est la suivante :<\/p>\n<pre><code>=F.INV(0.99, 5, 10) \/\/ Utilisation dans Excel =INVERSE.LOI.F.N(0.99, 5, 10) \/\/ Utilisation dans Google Sheets<\/code><\/pre>\n<p>Ce r\u00e9sultat est utilis\u00e9 pour d\u00e9terminer si les moyennes des trois groupes diff\u00e8rent de mani\u00e8re significative \u00e0 ce niveau de confiance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Renvoie l\u2019inveRse de 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-6541","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.INV (INVERSE.LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction F.INV (INVERSE.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-inv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction F.INV (INVERSE.LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction F.INV (INVERSE.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-inv\/\" \/>\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:18+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.INV (INVERSE.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-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/f-inv\/\",\"name\":\"Fonction F.INV (INVERSE.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:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction F.INV (INVERSE.LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/f-inv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/f-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/f-inv\/#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\":\"INVERSE.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.INV (INVERSE.LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction F.INV (INVERSE.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-inv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction F.INV (INVERSE.LOI.F.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction F.INV (INVERSE.LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/f-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction F.INV (INVERSE.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-inv\/","url":"https:\/\/functiontranslator.com\/fr\/f-inv\/","name":"Fonction F.INV (INVERSE.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:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction F.INV (INVERSE.LOI.F.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/f-inv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/f-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/f-inv\/#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":"INVERSE.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\/6541","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=6541"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6541\/revisions"}],"predecessor-version":[{"id":29552,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6541\/revisions\/29552"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}