{"id":5503,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/covariance-s\/"},"modified":"2021-02-26T09:52:44","modified_gmt":"2021-02-26T09:52:44","slug":"covariance-s","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/covariance-s\/","title":{"rendered":"COVARIANCE.S"},"content":{"rendered":"

P\u0159ehled funkce<\/h2>\n

Funkce COVARIANCE.S<\/code> v Excelu a Google Sheets umo\u017e\u0148uje vypo\u010d\u00edtat vzorkovou kovarianci mezi dv\u011bma sadami dat. Kovariance je statistick\u00fd ukazatel, kter\u00fd popisuje, jak spole\u010dn\u011b variuj\u00ed dv\u011b prom\u011bnn\u00e9. Pokud je kovariance kladn\u00e1, ob\u011b prom\u011bnn\u00e9 obvykle vzr\u016fstaj\u00ed nebo klesaj\u00ed sou\u010dasn\u011b. Naopak z\u00e1porn\u00e1 kovariance nazna\u010duje, \u017ee kdy\u017e jedna prom\u011bnn\u00e1 stoup\u00e1, druh\u00e1 kles\u00e1.<\/p>\n

Syntaxe a pou\u017eit\u00ed<\/h2>\n

Syntaxe funkce COVARIANCE.S<\/code> je:<\/p>\n

COVARIANCE.S(array1, array2)<\/code><\/pre>\n
Kde array1<\/code> a array2<\/code> jsou pole nebo rozsahy bun\u011bk, ve kter\u00fdch chceme spo\u010d\u00edtat kovarianci. Je d\u016fle\u017eit\u00e9, aby ob\u011b pole obsahovala stejn\u00fd po\u010det datov\u00fdch bod\u016f.<\/p>\n\n\n\n\n
Parametr<\/th>\nPopis<\/th>\n<\/tr>\n
array1<\/code><\/td>\nPrvn\u00ed sada datov\u00fdch bod\u016f.<\/td>\n<\/tr>\n
array2<\/code><\/td>\nDruh\u00e1 sada datov\u00fdch bod\u016f.<\/td>\n<\/tr>\n<\/table>\n
P\u0159\u00edklad pou\u017eit\u00ed:<\/p>\n
=COVARIANCE.S(A1:A10, B1:B10)<\/code><\/pre>\n
Tento p\u0159\u00edklad spo\u010d\u00edt\u00e1 kovarianci mezi daty ulo\u017een\u00fdmi v rozsaz\u00edch bun\u011bk A1:A10 a B1:B10.<\/p>\n
Praktick\u00e9 aplikace funkce<\/h2>\n
Vyu\u017eit\u00ed v investi\u010dn\u00edm rozhodov\u00e1n\u00ed<\/h2>\n
Investo\u0159i \u010dasto vyu\u017e\u00edvaj\u00ed kovarianci pro anal\u00fdzu vztah\u016f mezi v\u00fdnosy r\u016fzn\u00fdch akciov\u00fdch cenn\u00fdch pap\u00edr\u016f. Uva\u017eujme m\u011bs\u00ed\u010dn\u00ed v\u00fdnosy dvou akci\u00ed za posledn\u00edch 10 m\u011bs\u00edc\u016f, kter\u00e9 jsou zaznamen\u00e1ny v bu\u0148k\u00e1ch A1:A10 pro akcii X a B1:B10 pro akcii Y:<\/p>\n
=COVARIANCE.S(A1:A10, B1:B10)<\/code><\/pre>\n
    \n
  • Pokud je v\u00fdsledek kladn\u00fd, znamen\u00e1 to, \u017ee ceny obou akci\u00ed obvykle rostou nebo klesaj\u00ed spole\u010dn\u011b.<\/li>\n
  • Z\u00e1porn\u00fd v\u00fdsledek indikuje, \u017ee kdy\u017e cena jedn\u00e9 akcie kles\u00e1, druh\u00e1 tenduje k r\u016fstu.<\/li>\n<\/ul>\n
    P\u0159\u00edprava marketingov\u00e9 strategie<\/h2>\n
    Kovarianci lze vyu\u017e\u00edt tak\u00e9 v marketingu k posouzen\u00ed vztahu mezi \u010d\u00e1stkami vynalo\u017een\u00fdmi na reklamu a prodeji produkt\u016f. P\u0159edstavme si, \u017ee \u010d\u00e1stky vynalo\u017een\u00e9 na reklamu jsou v bu\u0148k\u00e1ch A1:A10 a zaznamenan\u00fd prodej v B1:B10:<\/p>\n
    =COVARIANCE.S(A1:A10, B1:B10)<\/code><\/pre>\n
      \n
    • Kladn\u00e1 hodnota ukazuje, \u017ee vy\u0161\u0161\u00ed investice do reklamy maj\u00ed tendenci b\u00fdt spojeny s vy\u0161\u0161\u00edm prodejem, co\u017e m\u016f\u017ee poukazovat na efektivitu reklamn\u00edch investic.<\/li>\n
    • Z\u00e1porn\u00e1 hodnota by nazna\u010dovala, \u017ee v\u011bt\u0161\u00ed v\u00fddaje na reklamu nemus\u00ed nutn\u011b v\u00e9st k zv\u00fd\u0161en\u00ed prodeje, co\u017e m\u016f\u017ee b\u00fdt podkladem pro revizi marketingov\u00fdch strategi\u00ed.<\/li>\n<\/ul>\n
      V obou p\u0159\u00edpadech m\u016f\u017ee COVARIANCE.S<\/code> poskytnout u\u017eite\u010dn\u00e9 informace pro lep\u0161\u00ed pochopen\u00ed a formulaci strategi\u00ed na z\u00e1klad\u011b vz\u00e1jemn\u00fdch vztah\u016f mezi kl\u00ed\u010dov\u00fdmi prom\u011bnn\u00fdmi.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Vr\u00e1t\u00ed hodnotu kovariance v\u00fdb\u011bru, tedy pr\u016fm\u011br sou\u010din\u016f odchylek pro ka\u017edou dvojici datov\u00fdch bod\u016f ve dvou mno\u017ein\u00e1ch dat<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[287],"tags":[],"class_list":["post-5503","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije COVARIANCE.S u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\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\/cs\/covariance-s\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije COVARIANCE.S u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/covariance-s\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:52:44+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/covariance-s\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/covariance-s\/\",\"name\":\"Funkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T09:52:44+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije COVARIANCE.S u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/covariance-s\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/covariance-s\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/covariance-s\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistick\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/statisticke\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"COVARIANCE.S\"}]},{\"@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\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije COVARIANCE.S u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","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\/cs\/covariance-s\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije COVARIANCE.S u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/covariance-s\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:52:44+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/covariance-s\/","url":"https:\/\/functiontranslator.com\/cs\/covariance-s\/","name":"Funkce COVARIANCE.S v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T09:52:44+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije COVARIANCE.S u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/covariance-s\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/covariance-s\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/covariance-s\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Statistick\u00e9","item":"https:\/\/functiontranslator.com\/cs\/statisticke\/"},{"@type":"ListItem","position":3,"name":"COVARIANCE.S"}]},{"@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":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5503"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5503\/revisions"}],"predecessor-version":[{"id":30642,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5503\/revisions\/30642"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}