{"id":577,"date":"2023-07-29T11:03:43","date_gmt":"2023-07-29T11:03:43","guid":{"rendered":"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/"},"modified":"2023-07-29T11:03:43","modified_gmt":"2023-07-29T11:03:43","slug":"varyasyon-katsayisi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/","title":{"rendered":"Excel&#39;de de\u011fi\u015fim katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Genellikle CV olarak k\u0131salt\u0131lan bir <strong>varyasyon katsay\u0131s\u0131<\/strong> , bir veri k\u00fcmesindeki de\u011ferlerin ortalamaya g\u00f6re yay\u0131lmas\u0131n\u0131 \u00f6l\u00e7menin bir yoludur. A\u015fa\u011f\u0131daki \u015fekilde hesaplan\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>CV<\/strong> = \u03c3 \/ \u03bc<\/span><\/p>\n<p> <span style=\"color: #000000;\">Alt\u0131n:<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u03c3 = veri k\u00fcmesinin standart sapmas\u0131<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u03bc = veri k\u00fcmesinin ortalamas\u0131<\/span><\/p>\n<p> <span style=\"color: #000000;\">En basit haliyle varyasyon katsay\u0131s\u0131, standart sapman\u0131n ortalamaya oran\u0131d\u0131r.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>De\u011fi\u015fim katsay\u0131s\u0131 ne zaman kullan\u0131l\u0131r?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">De\u011fi\u015fim katsay\u0131s\u0131 genellikle iki farkl\u0131 veri k\u00fcmesi aras\u0131ndaki de\u011fi\u015fimi kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in kullan\u0131l\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ger\u00e7ek d\u00fcnyada, finansta bir yat\u0131r\u0131m\u0131n ortalama beklenen getirisini, yat\u0131r\u0131m\u0131n beklenen standart sapmas\u0131 ile kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in s\u0131kl\u0131kla kullan\u0131l\u0131r. Bu, yat\u0131r\u0131mc\u0131lar\u0131n yat\u0131r\u0131mlar aras\u0131ndaki risk-getiri dengesini kar\u015f\u0131la\u015ft\u0131rmas\u0131na olanak tan\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, bir yat\u0131r\u0131mc\u0131n\u0131n a\u015fa\u011f\u0131daki iki yat\u0131r\u0131m fonuna yat\u0131r\u0131m yapmay\u0131 d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcn\u00fc varsayal\u0131m:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Yat\u0131r\u0131m Fonu A: ortalama = %7, standart sapma = %12,4<\/span><\/p>\n<p> <span style=\"color: #000000;\">UCITS B: ortalama = %5, standart sapma = %8,2<\/span><\/p>\n<p> <span style=\"color: #000000;\">Yat\u0131r\u0131mc\u0131, her fonun de\u011fi\u015fim katsay\u0131s\u0131n\u0131 hesaplayarak \u015funlar\u0131 not eder:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Yat\u0131r\u0131m fonu A i\u00e7in CV = %12,4 \/ %7 = <strong>1,77<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Yat\u0131r\u0131m fonu B i\u00e7in CV = %8,2 \/ %5 = <strong>1,64<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">B Yat\u0131r\u0131m Fonu&#8217;nun de\u011fi\u015fim katsay\u0131s\u0131 daha d\u00fc\u015f\u00fck oldu\u011fundan standart sapmaya g\u00f6re daha iyi bir ortalama getiri sa\u011flamaktad\u0131r.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Excel&#8217;de De\u011fi\u015fim Katsay\u0131s\u0131 Nas\u0131l Hesaplan\u0131r?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de bir veri k\u00fcmesinin de\u011fi\u015fim katsay\u0131s\u0131n\u0131 hesaplamak i\u00e7in yerle\u015fik bir form\u00fcl yoktur, ancak neyse ki bunu birka\u00e7 basit form\u00fcl kullanarak hesaplamak nispeten kolayd\u0131r. A\u015fa\u011f\u0131daki \u00f6rnek, belirli bir veri seti i\u00e7in varyasyon katsay\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">20 \u00f6\u011frencinin s\u0131nav sonu\u00e7lar\u0131n\u0131 i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5218 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv0.png\" alt=\"Excel'deki \u00d6rnek Veri K\u00fcmesi\" width=\"488\" height=\"510\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu veri k\u00fcmesinin de\u011fi\u015fim katsay\u0131s\u0131n\u0131 hesaplamak i\u00e7in yaln\u0131zca iki say\u0131y\u0131 bilmeniz gerekir: ortalama ve standart sapma. Bunlar a\u015fa\u011f\u0131daki form\u00fcller kullan\u0131larak hesaplanabilir:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ortalama: <strong>= ORTALAMA (A2:A21)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Standart sapma: <strong>=STDEV(A2:A21)<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5221 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv1.png\" alt=\"Excel'de bir veri k\u00fcmesi i\u00e7in varyasyon katsay\u0131s\u0131n\u0131n hesaplanmas\u0131\" width=\"542\" height=\"511\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">De\u011fi\u015fim katsay\u0131s\u0131n\u0131 hesaplamak i\u00e7in standart sapmay\u0131 ortalamaya b\u00f6leriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5223 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv2.png\" alt=\"Excel'deki varyasyon katsay\u0131s\u0131\" width=\"552\" height=\"489\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">De\u011fi\u015fim katsay\u0131s\u0131 <strong>0,0864<\/strong> olarak \u00e7\u0131k\u0131yor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">CV&#8217;yi hesaplamak i\u00e7in tek bir form\u00fcl de kullanabilece\u011fimizi unutmay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5225 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv3.png\" alt=\"Excel'deki varyasyon form\u00fcl\u00fc form\u00fcl\u00fc\" width=\"557\" height=\"504\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu, <strong>0,0864<\/strong> ile ayn\u0131 CV&#8217;yi verir.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Genellikle CV olarak k\u0131salt\u0131lan bir varyasyon katsay\u0131s\u0131 , bir veri k\u00fcmesindeki de\u011ferlerin ortalamaya g\u00f6re yay\u0131lmas\u0131n\u0131 \u00f6l\u00e7menin bir yoludur. A\u015fa\u011f\u0131daki \u015fekilde hesaplan\u0131r: CV = \u03c3 \/ \u03bc Alt\u0131n: \u03c3 = veri k\u00fcmesinin standart sapmas\u0131 \u03bc = veri k\u00fcmesinin ortalamas\u0131 En basit haliyle varyasyon katsay\u0131s\u0131, standart sapman\u0131n ortalamaya oran\u0131d\u0131r. De\u011fi\u015fim katsay\u0131s\u0131 ne zaman kullan\u0131l\u0131r? De\u011fi\u015fim katsay\u0131s\u0131 genellikle [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-577","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de varyasyon katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Bir \u00f6rnekle birlikte Excel&#039;de varyasyon katsay\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de varyasyon katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bir \u00f6rnekle birlikte Excel&#039;de varyasyon katsay\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T11:03:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv0.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\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:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/\",\"name\":\"Excel&#39;de varyasyon katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T11:03:43+00:00\",\"dateModified\":\"2023-07-29T11:03:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bir \u00f6rnekle birlikte Excel&#39;de varyasyon katsay\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de de\u011fi\u015fim katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de varyasyon katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r - Statorials","description":"Bir \u00f6rnekle birlikte Excel&#39;de varyasyon katsay\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.","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:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de varyasyon katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r - Statorials","og_description":"Bir \u00f6rnekle birlikte Excel&#39;de varyasyon katsay\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T11:03:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv0.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/","url":"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/","name":"Excel&#39;de varyasyon katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T11:03:43+00:00","dateModified":"2023-07-29T11:03:43+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bir \u00f6rnekle birlikte Excel&#39;de varyasyon katsay\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/varyasyon-katsayisi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de de\u011fi\u015fim katsay\u0131s\u0131 nas\u0131l hesaplan\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=577"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}