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

La covariance est une mesure qui indique l’intensit\u00e9 de la relation lin\u00e9aire entre deux variables. Dans Excel et Google Sheets, la fonction COVARIANCE.P (\u00e9galement connue sous le nom de COVARIANCE.PEARSON) est utilis\u00e9e pour calculer la covariance de deux ensembles de donn\u00e9es au sein d’une population. Cette fonction est particuli\u00e8rement utile dans des domaines comme les statistiques, la finance et l’\u00e9conomie.<\/p>\n

Structure de la fonction<\/h2>\n

La syntaxe de la fonction COVARIANCE.P dans Excel et Google Sheets est la suivante :<\/p>\n

=COVARIANCE.P(matrice1, matrice2)<\/code><\/pre>\n
    \n
  • matrice1<\/strong> : Le premier ensemble de valeurs num\u00e9riques.<\/li>\n
  • matrice2<\/strong> : Le second ensemble de valeurs num\u00e9riques, qui doit avoir la m\u00eame taille que le premier.<\/li>\n<\/ul>\n
    Il est crucial que les deux ensembles de donn\u00e9es aient la m\u00eame longueur, sinon la fonction g\u00e9n\u00e9rera une erreur.<\/p>\n
    Exemple d’utilisation<\/h2>\n
    Consid\u00e9rons le jeu de donn\u00e9es suivant :<\/p>\n\n\n\n\n\n
    Revenu (matrice1)<\/th>\nD\u00e9penses (matrice2)<\/th>\n<\/tr>\n
    2000<\/td>\n1500<\/td>\n<\/tr>\n
    2500<\/td>\n2000<\/td>\n<\/tr>\n
    3000<\/td>\n2400<\/td>\n<\/tr>\n<\/table>\n
    Pour calculer la covariance de ces deux ensembles de donn\u00e9es, nous utiliserions la formule :<\/p>\n
    =COVARIANCE.P(A2:A4, B2:B4)<\/code><\/pre>\n
    Applications pratiques<\/h2>\n
    Analyse de la corr\u00e9lation entre ventes et d\u00e9penses publicitaires<\/h2>\n
    Imaginez que vous soyez un analyste de donn\u00e9es dans une entreprise cherchant \u00e0 \u00e9tablir s’il existe un lien entre les sommes d\u00e9pens\u00e9es en publicit\u00e9 et les revenus g\u00e9n\u00e9r\u00e9s par les ventes. Avec des donn\u00e9es mensuelles des d\u00e9penses et des ventes sur une ann\u00e9e, l’utilisation de COVARIANCE.P permet de mesurer cette tendance lin\u00e9aire : une valeur positive indiquerait une tendance \u00e0 l’augmentation conjointe, tandis qu’une valeur n\u00e9gative sugg\u00e9rerait le contraire. Cette analyse peut \u00eatre cruciale pour d\u00e9cider si augmenter le budget publicitaire pourrait effectivement booster les ventes.<\/p>\n
    \u00c9valuation des relations financi\u00e8res<\/h2>\n
    Dans le domaine financier, il est essentiel de comprendre les relations entre diff\u00e9rents actifs pour optimiser la construction de portefeuilles. Si deux actions pr\u00e9sentent une forte covariance, cela signifie qu’elles ont tendance \u00e0 \u00e9voluer dans la m\u00eame direction sous des conditions de march\u00e9 similaires. Calculer la covariance entre les rendements de diff\u00e9rents actifs peut vous aider \u00e0 mieux diversifier votre portefeuille.<\/p>\n
    La fonction COVARIANCE.P est donc un outil indispensable dans de nombreux sc\u00e9narios d’analyse, permettant d’\u00e9valuer pr\u00e9cis\u00e9ment les relations lin\u00e9aires entre deux s\u00e9ries de donn\u00e9es num\u00e9riques, de pr\u00e9voir des comportements et de renforcer les d\u00e9cisions bas\u00e9es sur des donn\u00e9es concr\u00e8tes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la covaRiance, moyenne des pRoduits des \u00e9caRts pouR chaque s\u00e9Rie d\u2019obseRvations<\/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-6470","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction COVARIANCE.P (COVARIANCE.PEARSON) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COVARIANCE.P (COVARIANCE.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\/covariance-p\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COVARIANCE.P (COVARIANCE.PEARSON) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COVARIANCE.P (COVARIANCE.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\/covariance-p\/\" \/>\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:03:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COVARIANCE.P (COVARIANCE.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\/covariance-p\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/covariance-p\/\",\"name\":\"Fonction COVARIANCE.P (COVARIANCE.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:03:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COVARIANCE.P (COVARIANCE.PEARSON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/covariance-p\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/covariance-p\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/covariance-p\/#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\":\"COVARIANCE.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 COVARIANCE.P (COVARIANCE.PEARSON) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COVARIANCE.P (COVARIANCE.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\/covariance-p\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COVARIANCE.P (COVARIANCE.PEARSON) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COVARIANCE.P (COVARIANCE.PEARSON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/covariance-p\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COVARIANCE.P (COVARIANCE.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\/covariance-p\/","url":"https:\/\/functiontranslator.com\/fr\/covariance-p\/","name":"Fonction COVARIANCE.P (COVARIANCE.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:03:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COVARIANCE.P (COVARIANCE.PEARSON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/covariance-p\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/covariance-p\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/covariance-p\/#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":"COVARIANCE.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\/6470","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=6470"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6470\/revisions"}],"predecessor-version":[{"id":29482,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6470\/revisions\/29482"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}