{"id":6708,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/pearson\/"},"modified":"2021-02-26T08:11:32","modified_gmt":"2021-02-26T08:11:32","slug":"pearson","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/pearson\/","title":{"rendered":"PEARSON"},"content":{"rendered":"

Introduction \u00e0 la corr\u00e9lation de Pearson<\/h2>\n

La corr\u00e9lation de Pearson est un indicateur statistique couramment employ\u00e9 pour mesurer le niveau de relation lin\u00e9aire entre deux variables quantitatives. Cette mesure est fr\u00e9quemment utilis\u00e9e dans Excel et Google Sheets pour \u00e9tudier la corr\u00e9lation entre deux ensembles de donn\u00e9es et d\u00e9terminer dans quelle mesure ces variables varient conjointement de mani\u00e8re proportionnelle.<\/p>\n

Syntaxe g\u00e9n\u00e9rale<\/h2>\n

Dans Excel et Google Sheets, cette fonction est d\u00e9sign\u00e9e par PEARSON<\/code>. Voici comment on l’utilise typiquement :<\/p>\n

=PEARSON(matrice1, matrice2)<\/code><\/pre>\n
    \n
  • matrice1<\/strong> : Correspond \u00e0 la premi\u00e8re s\u00e9rie de valeurs ou la premi\u00e8re plage de donn\u00e9es.<\/li>\n
  • matrice2<\/strong> : Correspond \u00e0 la seconde s\u00e9rie de valeurs ou la plage de donn\u00e9es associ\u00e9e.<\/li>\n<\/ul>\n
    Le coefficient de corr\u00e9lation retourne un valeur entre -1 et 1. Un r\u00e9sultat de 1 indique une corr\u00e9lation positive parfaite, tandis que -1 signale une corr\u00e9lation n\u00e9gative parfaite. Une valeur de 0 signifie qu’il n’y a aucune corr\u00e9lation lin\u00e9aire directe entre les variables.<\/p>\n
    Exemple d’application<\/h2>\n
    Imaginez que vous avez les scores de deux tests diff\u00e9rents r\u00e9alis\u00e9s par un groupe d’\u00e9tudiants. Pour examiner l’existence d’une \u00e9ventuelle corr\u00e9lation entre les performances obtenues lors de ces deux tests, vous pourriez proc\u00e9der de la mani\u00e8re suivante :<\/p>\n\n\n\n\n\n\n\n
    Test A<\/th>\nTest B<\/th>\n<\/tr>\n
    85<\/td>\n88<\/td>\n<\/tr>\n
    78<\/td>\n82<\/td>\n<\/tr>\n
    96<\/td>\n91<\/td>\n<\/tr>\n
    65<\/td>\n70<\/td>\n<\/tr>\n
    80<\/td>\n78<\/td>\n<\/tr>\n<\/table>\n
    Utilisez la formule suivante dans Excel ou Google Sheets pour calculer la corr\u00e9lation entre les scores des Test A et Test B :<\/p>\n
    =PEARSON(A2:A6, B2:B6)<\/code><\/pre>\n
    Interpr\u00e9tation des r\u00e9sultats<\/h2>\n
    Si la fonction retourne, par exemple, un coefficient de 0.947, cela indique une forte corr\u00e9lation positive. Cela implique g\u00e9n\u00e9ralement que les \u00e9tudiants performant bien sur le Test A tendent aussi \u00e0 bien r\u00e9ussir le Test B.<\/p>\n
    Utilisation en finance<\/h2>\n
    Supposons que vous \u00eates un analyste financier cherchant \u00e0 \u00e9tudier la relation entre le rendement de deux actions sp\u00e9cifiques sur le march\u00e9 boursier. Cette fonction peut \u00eatre utilis\u00e9e pour \u00e9valuer si les cours de ces actions \u00e9voluent de mani\u00e8re similaire, ce qui est une information pr\u00e9cieuse pour la strat\u00e9gie de diversification de portefeuille.<\/p>\n
      \n
    • Donn\u00e9es de l’action 1 : 230, 210, 220, 200, 215<\/li>\n
    • Donn\u00e9es de l’action 2 : 100, 105, 102, 98, 104<\/li>\n<\/ul>\n
      Pour analyser cette relation, ins\u00e9rez la formule suivante dans votre feuille de calcul :<\/p>\n
      =PEARSON(C2:C6, D2:D6)<\/code><\/pre>\n
      Un coefficient proche de 0 indiquerait que les variations de prix de l’une des actions n’ont pas d’effet significatif ou pr\u00e9visible sur l’autre, ce qui peut influencer vos d\u00e9cisions de diversification.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le coefficient de coRR\u00e9lation d\u2019\u00e9chantillonnage de PeaRson<\/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-6708","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction PEARSON dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PEARSON 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\/pearson\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PEARSON dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PEARSON d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/pearson\/\" \/>\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:11:32+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction PEARSON 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\/pearson\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/pearson\/\",\"name\":\"Fonction PEARSON 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:11:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PEARSON d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/pearson\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/pearson\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/pearson\/#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\":\"PEARSON\"}]},{\"@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 PEARSON dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PEARSON 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\/pearson\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PEARSON dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PEARSON d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/pearson\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PEARSON 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\/pearson\/","url":"https:\/\/functiontranslator.com\/fr\/pearson\/","name":"Fonction PEARSON 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:11:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PEARSON d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/pearson\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/pearson\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/pearson\/#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":"PEARSON"}]},{"@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\/6708","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=6708"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6708\/revisions"}],"predecessor-version":[{"id":29719,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6708\/revisions\/29719"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}