{"id":2056,"date":"2023-07-23T22:04:32","date_gmt":"2023-07-23T22:04:32","guid":{"rendered":"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/"},"modified":"2023-07-23T22:04:32","modified_gmt":"2023-07-23T22:04:32","slug":"tek-degiskenli-analiz-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/","title":{"rendered":"Excel&#39;de tek de\u011fi\u015fkenli analiz nas\u0131l ger\u00e7ekle\u015ftirilir: \u00f6rneklerle"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Tek de\u011fi\u015fkenli analiz<\/strong> terimi, bir de\u011fi\u015fkenin analizini ifade eder. Bunu \u201cuni\u201d \u00f6n ekinin \u201cbir\u201d anlam\u0131na geldi\u011fini bilerek hat\u0131rlayabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tek de\u011fi\u015fkenli analiz ger\u00e7ekle\u015ftirmenin en yayg\u0131n yolu, \u00f6zet istatistikleri kullanarak bir de\u011fi\u015fkeni tan\u0131mlamakt\u0131r.<\/span> <span style=\"color: #000000;\">\u0130ki yayg\u0131n \u00f6zet istatistik t\u00fcr\u00fc vard\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/merkezi-egilimi-olcer\/\" target=\"_blank\" rel=\"noopener noreferrer\">Merkezi e\u011filim \u00f6l\u00e7\u00fcleri<\/a> : Bir veri k\u00fcmesinin merkezini tan\u0131mlayan say\u0131lar. \u00d6rnekler \u015funlar\u0131 i\u00e7erir:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Anlam<\/span><\/li>\n<li> <span style=\"color: #000000;\">Medyan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Moda<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Da\u011f\u0131l\u0131m \u00f6l\u00e7\u00fcleri: Bir veri k\u00fcmesindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131n\u0131 tan\u0131mlayan say\u0131lar. \u00d6rnekler \u015funlar\u0131 i\u00e7erir:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Standart sapma<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u00c7eyrekler aras\u0131 aral\u0131k<\/span><\/li>\n<li> <span style=\"color: #000000;\">D\u00fczenli<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek, Excel&#8217;de tek de\u011fi\u015fkenli analizin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini a\u00e7\u0131klamaktad\u0131r.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;de Tek De\u011fi\u015fkenli Analiz \u00c7al\u0131\u015ft\u0131rma<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Diyelim ki Excel&#8217;de 20 farkl\u0131 basketbolcunun say\u0131, asist ve ribaundlar\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahibiz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19179 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/univarie1.png\" alt=\"\" width=\"555\" height=\"519\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi \u201cPuan\u201d s\u00fctunundaki de\u011ferler \u00fczerinde tek de\u011fi\u015fkenli bir analiz yapmak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u201cPuan\u201d de\u011fi\u015fkenine ili\u015fkin \u00e7e\u015fitli \u00f6zet istatistikleri hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fclleri kullanabiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-19180 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/univarie2.png\" alt=\"Excel'de Tek De\u011fi\u015fkenli Analiz\" width=\"676\" height=\"421\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u201cPuan\u201d de\u011fi\u015fkeni i\u00e7in bu de\u011ferlerin nas\u0131l yorumlanaca\u011f\u0131 a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ortalama = <strong>18,85<\/strong> . Bu ortalama de\u011feri temsil eder.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Medyan = <strong>18,5<\/strong> Bu \u201cortalama\u201d de\u011feri temsil eder.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Mod = <strong>14<\/strong> . Bu en s\u0131k g\u00f6r\u00fclen de\u011feri temsil eder.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Standart sapma = <strong>5,75<\/strong> . Bu, de\u011ferlerin ortalamadan ortalama sapmas\u0131n\u0131 temsil eder.<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u00c7eyrekler aras\u0131 \u00f6l\u00e7ek = <strong>9,25<\/strong> . Bu, de\u011ferlerin ortadaki %50&#8217;sinin da\u011f\u0131l\u0131m\u0131n\u0131 temsil eder.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Aral\u0131k = <strong>20<\/strong> . Bu, en b\u00fcy\u00fck ve en k\u00fc\u00e7\u00fck de\u011fer aras\u0131ndaki fark\u0131 temsil eder.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Yaln\u0131zca bu \u00f6zet istatistikleri bilerek veri k\u00fcmesindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131 hakk\u0131nda \u00e7ok \u015fey \u00f6\u011frenebiliriz.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde tek de\u011fi\u015fkenli ve iki de\u011fi\u015fkenli analize ili\u015fkin ayr\u0131nt\u0131l\u0131 a\u00e7\u0131klamalar verilmektedir:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz\/\" target=\"_blank\" rel=\"noopener\">Tek De\u011fi\u015fkenli Analize Basit Bir Giri\u015f<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/iki-degiskenli-analiz\/\" target=\"_blank\" rel=\"noopener\">\u0130ki de\u011fi\u015fkenli analize basit bir giri\u015f<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tek de\u011fi\u015fkenli analiz terimi, bir de\u011fi\u015fkenin analizini ifade eder. Bunu \u201cuni\u201d \u00f6n ekinin \u201cbir\u201d anlam\u0131na geldi\u011fini bilerek hat\u0131rlayabilirsiniz. Tek de\u011fi\u015fkenli analiz ger\u00e7ekle\u015ftirmenin en yayg\u0131n yolu, \u00f6zet istatistikleri kullanarak bir de\u011fi\u015fkeni tan\u0131mlamakt\u0131r. \u0130ki yayg\u0131n \u00f6zet istatistik t\u00fcr\u00fc vard\u0131r: Merkezi e\u011filim \u00f6l\u00e7\u00fcleri : Bir veri k\u00fcmesinin merkezini tan\u0131mlayan say\u0131lar. \u00d6rnekler \u015funlar\u0131 i\u00e7erir: Anlam Medyan Moda Da\u011f\u0131l\u0131m \u00f6l\u00e7\u00fcleri: [&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-2056","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 Tek De\u011fi\u015fkenli Analiz Nas\u0131l Yap\u0131l\u0131r (\u00d6rneklerle) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde Excel&#039;de tek de\u011fi\u015fkenli analizin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tek-degiskenli-analiz-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 Tek De\u011fi\u015fkenli Analiz Nas\u0131l Yap\u0131l\u0131r (\u00d6rneklerle) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde Excel&#039;de tek de\u011fi\u015fkenli analizin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T22:04:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/univarie1.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\/tek-degiskenli-analiz-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/\",\"name\":\"Excel&#39;de Tek De\u011fi\u015fkenli Analiz Nas\u0131l Yap\u0131l\u0131r (\u00d6rneklerle) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-23T22:04:32+00:00\",\"dateModified\":\"2023-07-23T22:04:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde Excel&#39;de tek de\u011fi\u015fkenli analizin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de tek de\u011fi\u015fkenli analiz nas\u0131l ger\u00e7ekle\u015ftirilir: \u00f6rneklerle\"}]},{\"@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 Tek De\u011fi\u015fkenli Analiz Nas\u0131l Yap\u0131l\u0131r (\u00d6rneklerle) - Statorials","description":"Bu e\u011fitimde Excel&#39;de tek de\u011fi\u015fkenli analizin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","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\/tek-degiskenli-analiz-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Tek De\u011fi\u015fkenli Analiz Nas\u0131l Yap\u0131l\u0131r (\u00d6rneklerle) - Statorials","og_description":"Bu e\u011fitimde Excel&#39;de tek de\u011fi\u015fkenli analizin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-23T22:04:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/univarie1.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\/tek-degiskenli-analiz-excel\/","url":"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/","name":"Excel&#39;de Tek De\u011fi\u015fkenli Analiz Nas\u0131l Yap\u0131l\u0131r (\u00d6rneklerle) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-23T22:04:32+00:00","dateModified":"2023-07-23T22:04:32+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde Excel&#39;de tek de\u011fi\u015fkenli analizin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/tek-degiskenli-analiz-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de tek de\u011fi\u015fkenli analiz nas\u0131l ger\u00e7ekle\u015ftirilir: \u00f6rneklerle"}]},{"@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\/2056","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=2056"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/2056\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=2056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=2056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=2056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}