{"id":6756,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/coefficient-determination\/"},"modified":"2021-02-26T08:13:14","modified_gmt":"2021-02-26T08:13:14","slug":"rsq","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/rsq\/","title":{"rendered":"COEFFICIENT.DETERMINATION"},"content":{"rendered":"

Introduction \u00e0 la Coefficient de D\u00e9termination<\/h2>\n

La fonction RSQ est essentielle pour \u00e9valuer l’efficacit\u00e9 d’une r\u00e9gression lin\u00e9aire entre deux s\u00e9ries de donn\u00e9es. Elle calcule le carr\u00e9 du coefficient de corr\u00e9lation de Pearson, commun\u00e9ment appel\u00e9 R\u00b2, entre l’ensemble des variables d\u00e9pendantes Y et les variables ind\u00e9pendantes X. Utilis\u00e9e aussi bien dans Microsoft Excel que dans Google Sheets, cette fonction permet de quantifier quelle proportion de la variance de la variable d\u00e9pendante peut \u00eatre pr\u00e9dite \u00e0 partir de la variable ind\u00e9pendante.<\/p>\n

Syntaxe de la fonction<\/h2>\n
 RSQ(donn\u00e9es_y, donn\u00e9es_x)<\/code> <\/pre>\n
Dans cette syntaxe, donn\u00e9es_y<\/code> correspond aux valeurs de la variable d\u00e9pendante et donn\u00e9es_x<\/code> \u00e0 celles de la variable ind\u00e9pendante. Il est crucial que ces ensembles aient la m\u00eame quantit\u00e9 d’\u00e9l\u00e9ments et ne contiennent ni valeurs nulles ni non num\u00e9riques.<\/p>\n
Exemple simple d’utilisation<\/h2>\n
Consid\u00e9rons les ensembles de donn\u00e9es suivants :<\/p>\n
    \n
  • X = {2, 3, 9, 1, 8}<\/li>\n
  • Y = {1, 5, 6, 4, 3}<\/li>\n<\/ul>\n
    La formule \u00e0 ins\u00e9rer dans Excel ou Google Sheets est :<\/p>\n
     =RSQ(A2:A6, B2:B6)<\/code> <\/pre>\n
    Assurez-vous que les cellules A2 \u00e0 A6 contiennent les valeurs de X et que les cellules B2 \u00e0 B6 renferment les valeurs de Y.<\/p>\n
    Situation pratique : Mod\u00e9lisation de donn\u00e9es de vente<\/h2>\n
    Imaginons une entreprise analysant la relation entre les d\u00e9penses publicitaires (X) et les ventes (Y) sur plusieurs mois.<\/p>\n\n\n\n\n
    Mois<\/th>\nD\u00e9penses en publicit\u00e9 (X)<\/th>\nVentes (Y)<\/th>\n<\/tr>\n
    Janvier<\/td>\n300\u20ac<\/td>\n2700\u20ac<\/td>\n<\/tr>\n
    F\u00e9vrier<\/td>\n200\u20ac<\/td>\n2200\u20ac<\/td>\n<\/tr>\n
      <\/table>\n
    La fonction suivante peut \u00eatre utilis\u00e9e pour \u00e9valuer la corr\u00e9lation :<\/p>\n
     =RSQ(B2:B12, C2:C12)<\/code> <\/pre>\n
    Un R\u00b2 proche de 1 signifie une forte corr\u00e9lation positive entre les d\u00e9penses et les ventes, tandis qu’un R\u00b2 proche de 0 indiquerait une faible corr\u00e9lation.<\/p>\n
    \u00c9tude du rendement des investissements<\/h2>\n
    Un directeur financier pourrait vouloir analyser l’impact des investissements en \u00e9quipement (X) sur la productivit\u00e9 des employ\u00e9s (Y). Apr\u00e8s collecte des donn\u00e9es appropri\u00e9es, la fonction RSQ peut \u00eatre employ\u00e9e pour mesurer l’efficacit\u00e9 de ces investissements.<\/p>\n
     =RSQ(D2:D10, E2:E10)<\/code> <\/pre>\n
    Un R\u00b2 \u00e9lev\u00e9 sugg\u00e9rerait que les investissements dans l’\u00e9quipement ont un impact significatif sur la productivit\u00e9 des employ\u00e9s.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR du coefficient de d\u00e9teRmination R^2 d\u2019une R\u00e9gRession lin\u00e9aiRe<\/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-6756","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction RSQ (COEFFICIENT.DETERMINATION) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction RSQ (COEFFICIENT.DETERMINATION) 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\/rsq\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction RSQ (COEFFICIENT.DETERMINATION) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction RSQ (COEFFICIENT.DETERMINATION) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/rsq\/\" \/>\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:13:14+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction RSQ (COEFFICIENT.DETERMINATION) 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\/rsq\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/rsq\/\",\"name\":\"Fonction RSQ (COEFFICIENT.DETERMINATION) 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:13:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction RSQ (COEFFICIENT.DETERMINATION) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/rsq\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/rsq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rsq\/#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\":\"COEFFICIENT.DETERMINATION\"}]},{\"@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 RSQ (COEFFICIENT.DETERMINATION) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction RSQ (COEFFICIENT.DETERMINATION) 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\/rsq\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction RSQ (COEFFICIENT.DETERMINATION) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction RSQ (COEFFICIENT.DETERMINATION) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/rsq\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction RSQ (COEFFICIENT.DETERMINATION) 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\/rsq\/","url":"https:\/\/functiontranslator.com\/fr\/rsq\/","name":"Fonction RSQ (COEFFICIENT.DETERMINATION) 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:13:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction RSQ (COEFFICIENT.DETERMINATION) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/rsq\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/rsq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/rsq\/#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":"COEFFICIENT.DETERMINATION"}]},{"@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\/6756","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=6756"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6756\/revisions"}],"predecessor-version":[{"id":29767,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6756\/revisions\/29767"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}