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

Funkce COVAR<\/strong> se pou\u017e\u00edv\u00e1 pro v\u00fdpo\u010det kovariance dvou soubor\u016f dat. Kovariance je statistick\u00fd ukazatel, kter\u00fd ilustruje, jak se dv\u011b prom\u011bnn\u00e9 m\u011bn\u00ed spole\u010dn\u011b, a je kl\u00ed\u010dov\u00e1 pro anal\u00fdzu vztah\u016f mezi daty. Tato funkce je dostupn\u00e1 jak v Microsoft Excel, tak v Google Sheets a jej\u00ed syntaxe a pou\u017eit\u00ed jsou v obou p\u0159\u00edpadech velmi podobn\u00e9.<\/p>\n

Syntaxe funkce<\/h2>\n

Syntaxe pro funkci COVAR<\/code> je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

COVAR(array1, array2)<\/code><\/pre>\n
    \n
  • array1<\/strong> – Prvn\u00ed soubor hodnot nebo rozsah bun\u011bk p\u0159edstavuj\u00edc\u00ed prvn\u00ed prom\u011bnnou.<\/li>\n
  • array2<\/strong> – Druh\u00fd soubor hodnot nebo rozsah bun\u011bk p\u0159edstavuj\u00edc\u00ed druhou prom\u011bnnou.<\/li>\n<\/ul>\n
    Je d\u016fle\u017eit\u00e9, aby oba datov\u00e9 soubory obsahovaly stejn\u00fd po\u010det hodnot. Hodnoty, kter\u00e9 jsou neplatn\u00e9 nebo chyb\u011bj\u00ed, jsou p\u0159i v\u00fdpo\u010dtu ignorov\u00e1ny.<\/p>\n
    P\u0159\u00edklady pou\u017eit\u00ed<\/h2>\n
    N\u00e1sleduje p\u0159\u00edklad pou\u017eit\u00ed funkce COVAR<\/code>, kde m\u00e1me dv\u011b sady \u010d\u00edsel, a pot\u0159ebujeme analyzovat, jak jsou tato data propojena:<\/p>\n
    =COVAR(A2:A10, B2:B10)<\/code><\/pre>\n
    Tento p\u0159\u00edklad demonstruje pou\u017eit\u00ed rozsah\u016f A2:A10 a B2:B10 pro v\u00fdpo\u010det kovariance dvou soubor\u016f dat.<\/p>\n
    Praktick\u00e9 aplikace<\/h2>\n
    Uk\u00e1\u017eeme si n\u011bkolik p\u0159\u00edklad\u016f, kde m\u016f\u017ee b\u00fdt funkce COVAR prakticky vyu\u017eita:<\/p>\n
      \n
    • Anal\u00fdza tr\u017en\u00edch trend\u016f:<\/strong> Prozkoum\u00e1n\u00ed vztahu mezi cenami dvou akci\u00ed m\u016f\u017ee b\u00fdt podpo\u0159eno kovarianc\u00ed, kter\u00e1 ukazuje, zda ceny akci\u00ed maj\u00ed tendenci se pohybovat spole\u010dn\u011b. Pozitivn\u00ed kovariance nazna\u010duje, \u017ee ceny akci\u00ed obvykle stoupaj\u00ed nebo klesaj\u00ed spole\u010dn\u011b, zat\u00edmco negativn\u00ed kovariance ukazuje, \u017ee se jedna akcie obvykle vyv\u00edj\u00ed opa\u010dn\u011b ve srovn\u00e1n\u00ed s druhou.<\/li>\n<\/ul>\n
      \u0158e\u0161en\u00e9 p\u0159\u00edklady<\/h2>\n
      P\u0159\u00edklad 1<\/h3>\n
      P\u0159edstavme si n\u00e1sleduj\u00edc\u00ed data o cen\u00e1ch akci\u00ed dvou spole\u010dnost\u00ed A a B:<\/p>\n\n\n\n\n\n
      Datum<\/th>\nCena akcie A<\/th>\nCena akcie B<\/th>\n<\/tr>\n
      1.1.2023<\/td>\n200<\/td>\n150<\/td>\n<\/tr>\n
      1.2.2023<\/td>\n210<\/td>\n160<\/td>\n<\/tr>\n
      1.3.2023<\/td>\n205<\/td>\n155<\/td>\n<\/tr>\n<\/table>\n
      Pro v\u00fdpo\u010det kovariance cen akci\u00ed spole\u010dnost\u00ed A a B pou\u017eijeme vzorec:<\/p>\n
      =COVAR(B2:B4, C2:C4)<\/code><\/pre>\n
      Kde B2:B4 zahrnuje ceny akcie A a C2:C4 ceny akcie B. V\u00fdsledek uk\u00e1\u017ee m\u00edru jejich spole\u010dn\u00e9ho pohybu.<\/p>\n
      P\u0159\u00edklad 2<\/h3>\n
      M\u00e1me prozkoumat vz\u00e1jemn\u00fd vztah mezi po\u010dtem hodin studia a zn\u00e1mkami student\u016f. Data jsou n\u00e1sleduj\u00edc\u00ed:<\/p>\n\n\n\n\n\n
      Student<\/th>\nHodiny studia<\/th>\nZn\u00e1mka<\/th>\n<\/tr>\n
      Student 1<\/td>\n4<\/td>\n2<\/td>\n<\/tr>\n
      Student 2<\/td>\n6<\/td>\n1<\/td>\n<\/tr>\n
      Student 3<\/td>\n3<\/td>\n3<\/td>\n<\/tr>\n<\/table>\n
      Pro anal\u00fdzu pou\u017eijeme:<\/p>\n
      =COVAR(B2:B4, C2:C4)<\/code><\/pre>\n
      Kde B2:B4 obsahuje hodiny studia a C2:C4 zn\u00e1mky. Z\u00edskan\u00e1 kovariance napom\u00e1h\u00e1 pochopit, zda je studijn\u00ed \u010das spjat s lep\u0161\u00edmi zn\u00e1mkami.<\/p>\n
      Oba p\u0159\u00edklady demonstruj\u00ed, jak m\u016f\u017ee b\u00fdt funkce COVAR vyu\u017eita k porozum\u011bn\u00ed vz\u00e1jemn\u00fdch vztah\u016f mezi r\u016fzn\u00fdmi prom\u011bnn\u00fdmi a usnadnit tak v\u011bdeck\u00e9 \u010di obchodn\u00ed rozhodov\u00e1n\u00ed.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Vr\u00e1t\u00ed hodnotu kovariance, pr\u016fm\u011brnou hodnotu sou\u010din\u016f p\u00e1rov\u00fdch odchylek<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[289],"tags":[],"class_list":["post-5501","post","type-post","status-publish","format-standard","hentry","category-kompatibilita"],"acf":[],"yoast_head":"\nFunkce COVAR v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije COVAR 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\/covar\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce COVAR v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije COVAR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/covar\/\" \/>\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:39+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce COVAR 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\/covar\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/covar\/\",\"name\":\"Funkce COVAR 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:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije COVAR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/covar\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/covar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/covar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kompatibilita\",\"item\":\"https:\/\/functiontranslator.com\/cs\/kompatibilita\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"COVAR\"}]},{\"@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 COVAR v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije COVAR 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\/covar\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce COVAR v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije COVAR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/covar\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:52:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce COVAR 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\/covar\/","url":"https:\/\/functiontranslator.com\/cs\/covar\/","name":"Funkce COVAR 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:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije COVAR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/covar\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/covar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/covar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Kompatibilita","item":"https:\/\/functiontranslator.com\/cs\/kompatibilita\/"},{"@type":"ListItem","position":3,"name":"COVAR"}]},{"@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\/5501","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=5501"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5501\/revisions"}],"predecessor-version":[{"id":30640,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5501\/revisions\/30640"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}