{"id":578,"date":"2023-07-29T10:57:35","date_gmt":"2023-07-29T10:57:35","guid":{"rendered":"https:\/\/statorials.org\/tr\/asimetri-excel\/"},"modified":"2023-07-29T10:57:35","modified_gmt":"2023-07-29T10:57:35","slug":"asimetri-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/asimetri-excel\/","title":{"rendered":"Excel&#39;de \u00e7arp\u0131kl\u0131k nas\u0131l hesaplan\u0131r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>\u00c7arp\u0131kl\u0131k,<\/strong> bir veri k\u00fcmesinin veya da\u011f\u0131l\u0131m\u0131n\u0131n \u00e7arp\u0131kl\u0131\u011f\u0131n\u0131n bir \u00f6l\u00e7\u00fcs\u00fcd\u00fcr. Bu de\u011fer pozitif ya da negatif olabilir. Bunu bilmek faydal\u0131d\u0131r \u00e7\u00fcnk\u00fc da\u011f\u0131l\u0131m\u0131n \u015feklini anlamam\u0131za yard\u0131mc\u0131 olur.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Negatif \u00e7arp\u0131kl\u0131k, kuyru\u011fun da\u011f\u0131l\u0131m\u0131n sol taraf\u0131nda oldu\u011funu ve daha negatif de\u011ferlere do\u011fru uzand\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pozitif bir \u00e7arp\u0131kl\u0131k, kuyru\u011fun da\u011f\u0131l\u0131m\u0131n sa\u011f taraf\u0131nda oldu\u011funu ve daha pozitif de\u011ferlere do\u011fru uzand\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">S\u0131f\u0131r de\u011feri, da\u011f\u0131l\u0131mda asimetri olmad\u0131\u011f\u0131n\u0131, yani da\u011f\u0131l\u0131m\u0131n tamamen simetrik oldu\u011funu g\u00f6sterir. Bu al\u0131\u015f\u0131lmad\u0131k bir durumdur ve pratikte nadiren meydana gelir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Excel&#8217;de \u00c7arp\u0131kl\u0131k Nas\u0131l Hesaplan\u0131r<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel, bir da\u011f\u0131l\u0131m\u0131n \u00e7arp\u0131kl\u0131\u011f\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki yerle\u015fik i\u015flevi sa\u011flar:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\"><strong>=\u00c7ARK (de\u011fer dizisi)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu i\u015flev \u00e7arp\u0131kl\u0131\u011f\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullan\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Asimetri = [n\/(n-1)(n-2)] * \u03a3[(x <sub>i<\/sub> \u2013 <span style=\"text-decoration: overline;\">x<\/span> )\/s] <sup>3<\/sup><\/span><\/p>\n<p> <span style=\"color: #000000;\">Alt\u0131n:<\/span><\/p>\n<p> <span style=\"color: #000000;\">n = \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u03a3 = \u201ctoplam\u201d anlam\u0131na gelen s\u00fcsl\u00fc sembol<\/span><\/p>\n<p> <span style=\"color: #000000;\">x <sub>i<\/sub> = veri k\u00fcmesindeki <sup>i&#8217;inci<\/sup> de\u011ferin de\u011feri<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"text-decoration: overline;\">x<\/span> = ortalama<\/span><\/p>\n<p> <span style=\"color: #000000;\">s = standart sapma<\/span><\/p>\n<p> <span style=\"color: #000000;\">Form\u00fcl biraz karma\u015f\u0131k ama neyse ki Excel bu hesaplamay\u0131 sizin i\u00e7in yap\u0131yor, b\u00f6ylece bunu manuel olarak yapman\u0131za gerek kalm\u0131yor.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">\u00d6rnek: Excel&#8217;de asimetriyi hesaplamak<\/span><\/strong><\/h3>\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-5233 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel0.png\" alt=\"Excel'deki de\u011ferler tablosu \u00f6rne\u011fi\" width=\"545\" height=\"569\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>=SKEW(A2:A21)<\/strong> kullanarak da\u011f\u0131l\u0131m\u0131n \u00e7arp\u0131kl\u0131\u011f\u0131n\u0131 hesaplayabiliriz.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5234 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel1.png\" alt=\"Excel'de \u00c7arp\u0131kl\u0131k Nas\u0131l Hesaplan\u0131r\" width=\"560\" height=\"609\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu bize bu veri k\u00fcmesinin \u00e7arp\u0131kl\u0131\u011f\u0131n\u0131n <strong>-0,1849<\/strong> oldu\u011funu s\u00f6yler. Bu de\u011fer negatif oldu\u011fundan da\u011f\u0131l\u0131m\u0131n kuyru\u011funun sola do\u011fru uzand\u0131\u011f\u0131n\u0131 biliyoruz.<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Teknik not:<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">SKEW() i\u015flevi #DIV\/0 hatas\u0131n\u0131 d\u00f6nd\u00fcrecektir! a\u015fa\u011f\u0131daki iki senaryoda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u00dc\u00e7ten az veri noktas\u0131 varsa<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u00d6rnek standart sapmas\u0131 s\u0131f\u0131r ise<\/span><\/li>\n<\/ul>\n<\/blockquote>\n<h2> <span style=\"color: #000000;\"><strong>Ek Kaynak: \u00c7arp\u0131kl\u0131k ve Bas\u0131kl\u0131k Hesaplay\u0131c\u0131s\u0131<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131 ve bas\u0131kl\u0131\u011f\u0131 otomatik olarak hesaplayan <a href=\"https:\/\/statorials.org\/tr\" target=\"_blank\" rel=\"noopener\">\u0130statistiksel \u00c7arp\u0131kl\u0131k ve Bas\u0131kl\u0131k Hesaplay\u0131c\u0131&#8217;y\u0131<\/a> kullanarak belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131 da hesaplayabilirsiniz. Veri k\u00fcmenizin ham veri de\u011ferlerini giri\u015f kutusuna girmeniz ve ard\u0131ndan &#8220;Hesapla&#8221;ya t\u0131klaman\u0131z yeterlidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, yukar\u0131daki \u00f6rnekten veri k\u00fcmesinin \u00e7arp\u0131kl\u0131\u011f\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5236 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel2.png\" alt=\"Asimetri hesaplay\u0131c\u0131 \u00f6rne\u011fi\" width=\"500\" height=\"707\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Hesap makinesindeki \u00e7arp\u0131kl\u0131k de\u011ferinin Excel&#8217;de buldu\u011fumuz \u00e7arp\u0131kl\u0131k de\u011feriyle e\u015fle\u015fti\u011fini unutmay\u0131n.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c7arp\u0131kl\u0131k, bir veri k\u00fcmesinin veya da\u011f\u0131l\u0131m\u0131n\u0131n \u00e7arp\u0131kl\u0131\u011f\u0131n\u0131n bir \u00f6l\u00e7\u00fcs\u00fcd\u00fcr. Bu de\u011fer pozitif ya da negatif olabilir. Bunu bilmek faydal\u0131d\u0131r \u00e7\u00fcnk\u00fc da\u011f\u0131l\u0131m\u0131n \u015feklini anlamam\u0131za yard\u0131mc\u0131 olur. Negatif \u00e7arp\u0131kl\u0131k, kuyru\u011fun da\u011f\u0131l\u0131m\u0131n sol taraf\u0131nda oldu\u011funu ve daha negatif de\u011ferlere do\u011fru uzand\u0131\u011f\u0131n\u0131 g\u00f6sterir. Pozitif bir \u00e7arp\u0131kl\u0131k, kuyru\u011fun da\u011f\u0131l\u0131m\u0131n sa\u011f taraf\u0131nda oldu\u011funu ve daha pozitif de\u011ferlere do\u011fru uzand\u0131\u011f\u0131n\u0131 g\u00f6sterir. S\u0131f\u0131r [&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-578","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 Asimetri Nas\u0131l Hesaplan\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Bir \u00f6rnekle birlikte Excel&#039;de belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131n nas\u0131l hesaplanaca\u011f\u0131na ili\u015fkin 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\/asimetri-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 Asimetri Nas\u0131l Hesaplan\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bir \u00f6rnekle birlikte Excel&#039;de belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131n nas\u0131l hesaplanaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/asimetri-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T10:57:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel0.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\/asimetri-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/asimetri-excel\/\",\"name\":\"Excel&#39;de Asimetri Nas\u0131l Hesaplan\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T10:57:35+00:00\",\"dateModified\":\"2023-07-29T10:57:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bir \u00f6rnekle birlikte Excel&#39;de belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131n nas\u0131l hesaplanaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/asimetri-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/asimetri-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/asimetri-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de \u00e7arp\u0131kl\u0131k 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 Asimetri Nas\u0131l Hesaplan\u0131r - Statorials","description":"Bir \u00f6rnekle birlikte Excel&#39;de belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131n nas\u0131l hesaplanaca\u011f\u0131na ili\u015fkin 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\/asimetri-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Asimetri Nas\u0131l Hesaplan\u0131r - Statorials","og_description":"Bir \u00f6rnekle birlikte Excel&#39;de belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131n nas\u0131l hesaplanaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/asimetri-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T10:57:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inclinaisonexcel0.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\/asimetri-excel\/","url":"https:\/\/statorials.org\/tr\/asimetri-excel\/","name":"Excel&#39;de Asimetri Nas\u0131l Hesaplan\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T10:57:35+00:00","dateModified":"2023-07-29T10:57:35+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bir \u00f6rnekle birlikte Excel&#39;de belirli bir veri k\u00fcmesi i\u00e7in \u00e7arp\u0131kl\u0131\u011f\u0131n nas\u0131l hesaplanaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/asimetri-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/asimetri-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/asimetri-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de \u00e7arp\u0131kl\u0131k 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\/578","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=578"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/578\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}