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

Pr\u00e9sentation de la fonction TEST.F<\/h2>\n

La fonction TEST.F, connue \u00e9galement sous le nom de FTEST dans certaines versions d’Excel, est con\u00e7ue pour \u00e9valuer si deux s\u00e9ries de donn\u00e9es pr\u00e9sentent des variances similaires. Elle calcule la probabilit\u00e9 que les variances de deux \u00e9chantillons soient identiques, en supposant que ces \u00e9chantillons proviennent de distributions normalement distribu\u00e9es.<\/p>\n

Syntaxe dans Excel et Google Sheets<\/h2>\n

La syntaxe pour Excel est :<\/p>\n

=TEST.F(matrice1, matrice2)<\/code><\/pre>\n
o\u00f9 matrice1<\/code> repr\u00e9sente le premier ensemble de donn\u00e9es et matrice2<\/code> le second.<\/p>\n
Pour Google Sheets, la syntaxe est tr\u00e8s semblable :<\/p>\n
=FTEST(matrice1, matrice2)<\/code><\/pre>\n
Cette fonction produit une valeur p, indiquant la probabilit\u00e9. Une valeur p basse indique que les variances des deux \u00e9chantillons diff\u00e8rent de mani\u00e8re significative.<\/p>\n
Exemples d’utilisation<\/h2>\n
Cette fonction peut s’av\u00e9rer utile dans divers contextes :<\/p>\n
    \n
  • Comparaison de machines :<\/strong> Imaginez que vous disposiez de deux machines fabriquant le m\u00eame produit et que vous souhaitiez analyser si la variation des dimensions des pi\u00e8ces produites est comparable.<\/li>\n
  • Recherche en biologie :<\/strong> Un biologiste peut \u00eatre int\u00e9ress\u00e9 par l’\u00e9tude de la variation de taille entre deux populations distinctes d’une esp\u00e8ce pour d\u00e9terminer si elles pr\u00e9sentent une variabilit\u00e9 g\u00e9n\u00e9tique similaire pour une caract\u00e9ristique donn\u00e9e.<\/li>\n<\/ul>\n
    Solution d\u00e9taill\u00e9e pour un cas concret<\/h2>\n
    Probl\u00e8me :<\/strong> Un responsable de production d\u00e9sire savoir si les poids des produits finis issus de deux lignes de production diff\u00e9rentes sont comparables en termes de variabilit\u00e9. Voici les poids des 10 derniers produits de chaque ligne :<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
    Cha\u00eene 1<\/th>\nCha\u00eene 2<\/th>\n<\/tr>\n
    14.1<\/td>\n13.8<\/td>\n<\/tr>\n
    15.3<\/td>\n14.1<\/td>\n<\/tr>\n
    14.9<\/td>\n15.0<\/td>\n<\/tr>\n
    15.5<\/td>\n13.5<\/td>\n<\/tr>\n
    14.7<\/td>\n14.2<\/td>\n<\/tr>\n
    15.2<\/td>\n15.1<\/td>\n<\/tr>\n
    14.5<\/td>\n13.9<\/td>\n<\/tr>\n
    15.0<\/td>\n15.4<\/td>\n<\/tr>\n
    14.8<\/td>\n14.0<\/td>\n<\/tr>\n
    15.1<\/td>\n15.2<\/td>\n<\/tr>\n<\/table>\n
    Solution :<\/strong> Utilisation de la fonction TEST.F dans Excel pour analyser ces deux jeux de donn\u00e9es :<\/p>\n
    =TEST.F(A2:A11, B2:B11)<\/code><\/pre>\n
    o\u00f9 A2:A11 et B2:B11 correspondent aux poids enregistr\u00e9s dans les cha\u00eenes 1 et 2, respectivement.<\/p>\n
    Si le r\u00e9sultat retourn\u00e9 est 0.073, cela signifie qu’il existe 7.3% de chances que les diff\u00e9rences observ\u00e9es dans les variances soient fortuites, sugg\u00e9rant qu’il n’y a pas de diff\u00e9rence statistiquement significative entre les variances des deux cha\u00eenes de production.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le R\u00e9sultat d\u2019un test 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-6559","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction FTEST (TEST.F) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction FTEST (TEST.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\/ftest\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction FTEST (TEST.F) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction FTEST (TEST.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\/ftest\/\" \/>\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:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction FTEST (TEST.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\/ftest\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ftest\/\",\"name\":\"Fonction FTEST (TEST.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:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction FTEST (TEST.F) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ftest\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ftest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ftest\/#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\":\"TEST.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 FTEST (TEST.F) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction FTEST (TEST.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\/ftest\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction FTEST (TEST.F) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction FTEST (TEST.F) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ftest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction FTEST (TEST.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\/ftest\/","url":"https:\/\/functiontranslator.com\/fr\/ftest\/","name":"Fonction FTEST (TEST.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:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction FTEST (TEST.F) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ftest\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ftest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ftest\/#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":"TEST.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\/6559","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=6559"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6559\/revisions"}],"predecessor-version":[{"id":29570,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6559\/revisions\/29570"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}