{"id":15339,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kovaryans\/"},"modified":"2021-02-25T16:24:24","modified_gmt":"2021-02-25T16:24:24","slug":"covar","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/covar\/","title":{"rendered":"KOVARYANS"},"content":{"rendered":"

Kovaryans Fonksiyonunun Temelleri<\/h2>\n

Kovaryans, iki rassal de\u011fi\u015fkenin birlikte nas\u0131l varyasyon g\u00f6sterdi\u011fini \u00f6l\u00e7en bir istatistiksel terimdir. Microsoft Excel ve Google E-Tablolar, bu hesaplamay\u0131 COVAR<\/code> ad\u0131nda bir fonksiyon ile kolayla\u015ft\u0131r\u0131r. Kovaryans, iki de\u011fi\u015fkenin birbirine olan ili\u015fkisinin y\u00f6n\u00fcn\u00fc g\u00f6sterir ancak b\u00fcy\u00fckl\u00fc\u011f\u00fcn\u00fc de\u011fil. Bu de\u011fer pozitifse, de\u011fi\u015fkenler birlikte artar; negatifse, biri artarken di\u011feri azal\u0131r.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

Excel ve Google E-Tablolar’da COVAR<\/code> fonksiyonu a\u015fa\u011f\u0131daki s\u00f6zdizimine sahiptir:<\/p>\n

  COVAR(dizi1, dizi2) <\/code> <\/pre>\n
    \n
  • dizi1:<\/strong> Kovaryans\u0131 hesaplamak istedi\u011finiz ilk veri setini i\u00e7eren h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • dizi2:<\/strong> \u0130lk veri setiyle ili\u015fkilendirdi\u011finiz ikinci veri setini i\u00e7eren h\u00fccre aral\u0131\u011f\u0131.<\/li>\n<\/ul>\n
    \u00d6rnek Senaryolar<\/h2>\n
    Senaryo 1: Yat\u0131r\u0131m Getirileri<\/h3>\n
    Yat\u0131r\u0131m portf\u00f6y\u00fcn\u00fczde bulunan iki farkl\u0131 hisse senedinin getirileri aras\u0131ndaki ili\u015fkiyi anlamak isteyebilirsiniz. \u00d6rnek veri olarak, iki hisse senedinin ayl\u0131k getiri y\u00fczdelerini ele alal\u0131m:<\/p>\n
      Hisse A Getirileri: 2%, 3%, 2.5%, 3.5%, 4% Hisse B Getirileri: 1%, 1.5%, 2%, 2.5%, 3% <\/code> <\/pre>\n
    Kovaryans\u0131 hesaplamak i\u00e7in Excel veya Google E-Tablolar’da COVAR<\/code> form\u00fcl\u00fc \u015fu \u015fekilde yaz\u0131labilir:<\/p>\n
      =COVAR(A1:A5, B1:B5) <\/code> <\/pre>\n
    Bu form\u00fcl, Hisse A ve Hisse B getirileri aras\u0131ndaki kovaryans miktar\u0131n\u0131 verecektir, ve bu de\u011ferle bu iki hissenin birlikte ne kadar ve hangi y\u00f6nde hareket etti\u011fini analiz edebilirsiniz.<\/p>\n
    Senaryo 2: Pazarlama Kampanyas\u0131 ve Sat\u0131\u015flar<\/h3>\n
    Bir \u015firket, farkl\u0131 pazarlama kampanyalar\u0131n\u0131n sat\u0131\u015f rakamlar\u0131 \u00fczerindeki etkisini \u00f6l\u00e7mek istiyor olabilir. Diyelim ki a\u015fa\u011f\u0131daki gibidir:<\/p>\n
      Pazarlama B\u00fct\u00e7esi (bin TL): 100, 200, 300, 400, 500 Sat\u0131\u015flar (bin TL): 10, 15, 20, 25, 30 <\/code> <\/pre>\n
    Bu \u00f6rnekte, pazarlama b\u00fct\u00e7esi ile sat\u0131\u015flar aras\u0131 ili\u015fkiyi kovaryans ile \u00f6l\u00e7mek m\u00fcmk\u00fcnd\u00fcr:<\/p>\n
      =COVAR(A1:A5, B1:B5) <\/code> <\/pre>\n
    Bu de\u011ferle, pazarlama harcamalar\u0131n\u0131n sat\u0131\u015flar \u00fczerindeki etkisini \u00e7\u0131karabilir ve pazarlama stratejileri \u00fczerine daha bilin\u00e7li kararlar verebilirsiniz.<\/p>\n
    Yorumlar ve Dikkat Edilmesi Gerekenler<\/h2>\n
    COVAR<\/code> fonksiyonu kullan\u0131l\u0131rken veri setlerinin boyutlar\u0131n\u0131n ayn\u0131 olmas\u0131 gerekti\u011fine dikkat edin. \u0130statistiksel analizler yaparken, kovaryans\u0131n yaln\u0131zca y\u00f6nlendirme sa\u011flad\u0131\u011f\u0131n\u0131 etkili b\u00fcy\u00fckl\u00fck \u00f6l\u00e7\u00fcs\u00fc olmad\u0131\u011f\u0131n\u0131 unutmay\u0131n. \u0130li\u015fkilerin daha net anla\u015f\u0131labilmesi ad\u0131na korelasyon katsay\u0131s\u0131n\u0131 da hesaplamak genellikle yararl\u0131 olur.<\/p>\n","protected":false},"excerpt":{"rendered":"
    E\u015fle\u015ftirilmi\u015f sapmalar\u0131n ortalamas\u0131 olan kovaryans\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[584],"tags":[],"class_list":["post-15339","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COVAR (KOVARYANS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/covar\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COVAR (KOVARYANS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/covar\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:24:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/covar\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/covar\/\",\"name\":\"Excel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:24:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COVAR (KOVARYANS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/covar\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/covar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/covar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uyumluluk\",\"item\":\"https:\/\/functiontranslator.com\/tr\/uyumluluk\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"KOVARYANS\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COVAR (KOVARYANS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/covar\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COVAR (KOVARYANS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/covar\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/covar\/","url":"https:\/\/functiontranslator.com\/tr\/covar\/","name":"Excel'de COVAR (KOVARYANS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:24:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COVAR (KOVARYANS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/covar\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/covar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/covar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Uyumluluk","item":"https:\/\/functiontranslator.com\/tr\/uyumluluk\/"},{"@type":"ListItem","position":3,"name":"KOVARYANS"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15339"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15339\/revisions"}],"predecessor-version":[{"id":26607,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15339\/revisions\/26607"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}