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

Description de la fonction<\/h2>\n

La fonction COVARIANCE.S, \u00e9galement connue sous le nom de COVARIANCE.STANDARD dans certaines versions d’Excel, est utilis\u00e9e pour calculer la covariance d’un \u00e9chantillon. La covariance est une mesure qui indique la relation lin\u00e9aire entre deux ensembles de donn\u00e9es. En essence, elle \u00e9value dans quelle mesure les deux variables varient conjointement.<\/p>\n

Syntaxe :<\/p>\n

COVARIANCE.S(matrice1, matrice2)<\/code><\/pre>\n
O\u00f9 matrice1<\/code> et matrice2<\/code> repr\u00e9sentent les deux ensembles de donn\u00e9es ou matrices dont vous souhaitez calculer la covariance.<\/p>\n
Exemple de syntaxe avec cas pratique<\/h2>\n
Imaginez que vous disposez des r\u00e9sultats de deux examens diff\u00e9rents pour un groupe d’\u00e9tudiants et que vous souhaitez examiner la relation entre les performances \u00e0 ces deux \u00e9preuves.<\/p>\n
Les donn\u00e9es sont organis\u00e9es de la mani\u00e8re suivante :<\/p>\n\n\n\n\n\n\n
Examen 1<\/th>\nExamen 2<\/th>\n<\/tr>\n
15<\/td>\n17<\/td>\n<\/tr>\n
12<\/td>\n12<\/td>\n<\/tr>\n
14<\/td>\n15<\/td>\n<\/tr>\n
10<\/td>\n8<\/td>\n<\/tr>\n<\/table>\n
Pour calculer la covariance entre ces deux ensembles de donn\u00e9es, appliquez la formule suivante dans Excel :<\/p>\n
=COVARIANCE.S(A2:A5, B2:B5)<\/code><\/pre>\n
Probl\u00e8mes pratiques et solutions<\/h2>\n
\u00c9valuation de la corr\u00e9lation dans les performances de vente<\/h2>\n
Supposons que vous soyez un analyste des ventes analysant les donn\u00e9es mensuelles de vente de deux produits sur une ann\u00e9e. Vous souhaitez savoir si les performances de vente de ces produits sont corr\u00e9l\u00e9es.<\/p>\n
    \n
  • Produit A : ventes mensuelles (en unit\u00e9s) : 120, 150, 130, 160, 180, 140, 170, 155, 165, 135, 160, 145<\/li>\n
  • Produit B : ventes mensuelles (en unit\u00e9s) : 110, 130, 125, 150, 190, 165, 155, 145, 160, 150, 155, 140<\/li>\n<\/ul>\n
    Ins\u00e9rez ces donn\u00e9es dans Excel et utilisez la fonction COVARIANCE.S pour calculer la covariance :<\/p>\n
    =COVARIANCE.S(A2:A13, B2:B13)<\/code><\/pre>\n
    Ce calcul vous permettra de comprendre la relation lin\u00e9aire entre les ventes des deux produits.<\/p>\n
    Analyse de l’interd\u00e9pendance des investissements<\/h2>\n
    Consid\u00e9rez que vous \u00eates un gestionnaire de portefeuille analysant la relation entre les rendements de deux actions sur une p\u00e9riode de 10 ans pour optimiser la diversification.<\/p>\n
      \n
    • Action X : rendements annuels : 8%, 10%, 7%, 9%, 12%, 11%, 13%, 10%, 14%, 12%<\/li>\n
    • Action Y : rendements annuels : 5%, 7%, 6%, 8%, 9%, 8%, 10%, 9%, 11%, 10%<\/li>\n<\/ul>\n
      Utilisez ces donn\u00e9es pour calculer la covariance avec la formule :<\/p>\n
      =COVARIANCE.S(A2:A11, B2:B11)<\/code><\/pre>\n
      Cette analyse vous aidera \u00e0 d\u00e9terminer si les rendements des deux titres sont interd\u00e9pendants, ce qui est un aspect crucial pour la planification de la diversification de votre portefeuille.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la covaRiance d\u2019\u00e9chantillon, moyenne des pRoduits des \u00e9caRts pouR chaque paiRe de points de deux jeux de donn\u00e9es<\/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-6471","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction COVARIANCE.S (COVARIANCE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COVARIANCE.S (COVARIANCE.STANDARD) 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-s\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COVARIANCE.S (COVARIANCE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COVARIANCE.S (COVARIANCE.STANDARD) 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-s\/\" \/>\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:55+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.S (COVARIANCE.STANDARD) 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-s\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/covariance-s\/\",\"name\":\"Fonction COVARIANCE.S (COVARIANCE.STANDARD) 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:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COVARIANCE.S (COVARIANCE.STANDARD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/covariance-s\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/covariance-s\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/covariance-s\/#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.STANDARD\"}]},{\"@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.S (COVARIANCE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COVARIANCE.S (COVARIANCE.STANDARD) 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-s\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COVARIANCE.S (COVARIANCE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COVARIANCE.S (COVARIANCE.STANDARD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/covariance-s\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COVARIANCE.S (COVARIANCE.STANDARD) 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-s\/","url":"https:\/\/functiontranslator.com\/fr\/covariance-s\/","name":"Fonction COVARIANCE.S (COVARIANCE.STANDARD) 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:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COVARIANCE.S (COVARIANCE.STANDARD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/covariance-s\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/covariance-s\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/covariance-s\/#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.STANDARD"}]},{"@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\/6471","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=6471"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6471\/revisions"}],"predecessor-version":[{"id":29483,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6471\/revisions\/29483"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}