{"id":2100,"date":"2023-07-23T17:01:03","date_gmt":"2023-07-23T17:01:03","guid":{"rendered":"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/"},"modified":"2023-07-23T17:01:03","modified_gmt":"2023-07-23T17:01:03","slug":"excelde-sistematik-ornekleme","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/","title":{"rendered":"Excel&#39;de sistematik \u00f6rnekleme nas\u0131l yap\u0131l\u0131r (ad\u0131m ad\u0131m)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ara\u015ft\u0131rmac\u0131lar genellikle bir pop\u00fclasyondan<a href=\"https:\/\/statorials.org\/tr\/ornekleme-yontemleri\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u00f6rnekler<\/a> al\u0131r ve bu \u00f6rnekteki verileri, bir b\u00fct\u00fcn olarak pop\u00fclasyon hakk\u0131nda sonu\u00e7lar \u00e7\u0131karmak i\u00e7in kullan\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Yayg\u0131n olarak kullan\u0131lan bir \u00f6rnekleme y\u00f6ntemi, iki a\u015famal\u0131 basit bir s\u00fcre\u00e7te uygulanan <strong>sistematik \u00f6rneklemedir<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Bir pop\u00fclasyonun her \u00fcyesini belirli bir s\u0131raya yerle\u015ftirin.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Rastgele bir ba\u015flang\u0131\u00e7 noktas\u0131 se\u00e7in ve numunenin par\u00e7as\u0131 olacak n <sup>\u00fcyeden<\/sup> birini se\u00e7in.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, Excel&#8217;de sistematik \u00f6rneklemenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>1. Ad\u0131m: Verileri girin<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">\u00d6ncelikle bir veri setindeki de\u011ferleri Excel&#8217;e girelim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19514 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel1.png\" alt=\"\" width=\"597\" height=\"511\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ad\u0131m 2: Parametre de\u011ferlerini girin<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Daha sonra rastgele ka\u00e7 de\u011fer \u00f6rneklemek istedi\u011fimize karar vermemiz gerekiyor. Bu \u00f6rnek i\u00e7in n = 4 \u00f6rnek boyutunu se\u00e7ece\u011fiz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra pop\u00fclasyon b\u00fcy\u00fckl\u00fc\u011f\u00fcn\u00fc, sistematik \u00f6rneklememizin ad\u0131m b\u00fcy\u00fckl\u00fc\u011f\u00fcn\u00fc ve rastgele ba\u015flang\u0131\u00e7 noktas\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fclleri kullanaca\u011f\u0131z:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19515 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel2.png\" alt=\"\" width=\"631\" height=\"487\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>3. Ad\u0131m: Her Veri De\u011ferini Etiketleyin<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><strong>RANDBETWEEN()<\/strong> fonksiyonumuz veri setimizde ba\u015flang\u0131\u00e7 noktas\u0131 olarak 3 de\u011ferini rastgele se\u00e7ti. Bu nedenle, 3. konumdaki veri de\u011ferine 1 etiketi verin, ard\u0131ndan ad\u0131m boyutu 5&#8217;e kadar numaraland\u0131r\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19516 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel3.png\" alt=\"\" width=\"606\" height=\"453\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra, bir sonraki kullan\u0131labilir h\u00fccreye <strong>=D4<\/strong> yaz\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19517 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel4.png\" alt=\"\" width=\"585\" height=\"382\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra bu form\u00fcl\u00fc kopyalay\u0131p D s\u00fctunundaki kalan t\u00fcm h\u00fccrelere yap\u0131\u015ft\u0131r\u0131n. Ard\u0131ndan D s\u00fctununun \u00fcst\u00fcndeki de\u011ferleri manuel olarak doldurun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19518 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel5.png\" alt=\"\" width=\"575\" height=\"420\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>4. Ad\u0131m: De\u011ferleri filtreleyin<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Son olarak veri k\u00fcmesini yaln\u0131zca 1 etiketli veri de\u011ferlerini i\u00e7erecek \u015fekilde filtrelememiz gerekiyor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in \u00fcst \u015feritteki <strong>Veri<\/strong> sekmesine t\u0131klay\u0131n. Daha sonra <strong>Filtre<\/strong> simgesine t\u0131klay\u0131n. Ard\u0131ndan <strong>Etiketler<\/strong> etiketli s\u00fctunu t\u0131klay\u0131n ve yaln\u0131zca 1 de\u011ferine sahip bir etikete sahip sat\u0131rlar\u0131 dahil edecek \u015fekilde filtreleyin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19519 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel6.png\" alt=\"\" width=\"331\" height=\"434\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu yap\u0131ld\u0131ktan sonra veriler yaln\u0131zca 1 etiketine sahip veri de\u011ferlerini i\u00e7erecek \u015fekilde filtrelenecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19520 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel7.png\" alt=\"\" width=\"339\" height=\"326\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu bizim \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fcm\u00fcz 4&#8217;\u00fc temsil ediyor.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/tr\/ornekleme-yontemleri\/\" target=\"_blank\" rel=\"noopener\">\u00d6rnekleme Y\u00f6ntemi T\u00fcrlerine Giri\u015f<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-rastgele-ornek\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de rastgele bir \u00f6rnek nas\u0131l se\u00e7ilir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ara\u015ft\u0131rmac\u0131lar genellikle bir pop\u00fclasyondan\u00f6rnekler al\u0131r ve bu \u00f6rnekteki verileri, bir b\u00fct\u00fcn olarak pop\u00fclasyon hakk\u0131nda sonu\u00e7lar \u00e7\u0131karmak i\u00e7in kullan\u0131r. Yayg\u0131n olarak kullan\u0131lan bir \u00f6rnekleme y\u00f6ntemi, iki a\u015famal\u0131 basit bir s\u00fcre\u00e7te uygulanan sistematik \u00f6rneklemedir : 1. Bir pop\u00fclasyonun her \u00fcyesini belirli bir s\u0131raya yerle\u015ftirin. 2. Rastgele bir ba\u015flang\u0131\u00e7 noktas\u0131 se\u00e7in ve numunenin par\u00e7as\u0131 olacak n \u00fcyeden birini [&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-2100","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 Sistematik \u00d6rnekleme Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#039;de sistematik \u00f6rneklemenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi 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\/excelde-sistematik-ornekleme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Sistematik \u00d6rnekleme Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#039;de sistematik \u00f6rneklemenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T17:01:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel1.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\/excelde-sistematik-ornekleme\/\",\"url\":\"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/\",\"name\":\"Excel&#39;de Sistematik \u00d6rnekleme Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-23T17:01:03+00:00\",\"dateModified\":\"2023-07-23T17:01:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de sistematik \u00f6rneklemenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de sistematik \u00f6rnekleme nas\u0131l yap\u0131l\u0131r (ad\u0131m ad\u0131m)\"}]},{\"@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 Sistematik \u00d6rnekleme Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m) - Statorials","description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de sistematik \u00f6rneklemenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi 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\/excelde-sistematik-ornekleme\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Sistematik \u00d6rnekleme Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m) - Statorials","og_description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de sistematik \u00f6rneklemenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/","og_site_name":"Statorials","article_published_time":"2023-07-23T17:01:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sysexcel1.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\/excelde-sistematik-ornekleme\/","url":"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/","name":"Excel&#39;de Sistematik \u00d6rnekleme Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-23T17:01:03+00:00","dateModified":"2023-07-23T17:01:03+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de sistematik \u00f6rneklemenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excelde-sistematik-ornekleme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de sistematik \u00f6rnekleme nas\u0131l yap\u0131l\u0131r (ad\u0131m ad\u0131m)"}]},{"@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\/2100","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=2100"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/2100\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=2100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=2100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=2100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}