{"id":2102,"date":"2023-07-23T16:49:29","date_gmt":"2023-07-23T16:49:29","guid":{"rendered":"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/"},"modified":"2023-07-23T16:49:29","modified_gmt":"2023-07-23T16:49:29","slug":"pengambilan-sampel-cluster-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/","title":{"rendered":"Cara melakukan cluster sampling di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, kita sering mengambil <a href=\"https:\/\/statorials.org\/id\/metode-pengambilan-sampel\/\" target=\"_blank\" rel=\"noopener noreferrer\">sampel<\/a> dari suatu populasi dan menggunakan data dari sampel tersebut untuk menarik kesimpulan tentang populasi secara keseluruhan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Metode pengambilan sampel yang umum digunakan adalah <strong>cluster sampling<\/strong> , yaitu suatu populasi dibagi menjadi beberapa cluster dan seluruh anggota cluster <em>tertentu<\/em> dipilih untuk dimasukkan ke dalam sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara melakukan pengambilan sampel klaster di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari masukkan kumpulan data berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19538 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster1.png\" alt=\"\" width=\"453\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kami akan melakukan pengambilan sampel cluster di mana kami memilih dua tim secara acak dan memilih untuk memasukkan semua pemain dari kedua tim tersebut ke dalam sampel akhir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan Nilai Unik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketik <strong>=UNIQUE(B2:B21)<\/strong> untuk menghasilkan array nilai unik dari kolom <strong>Tim<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19539 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster2.png\" alt=\"\" width=\"459\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan memasukkan bilangan bulat (dimulai dari 1) di samping setiap nama tim unik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19540 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster3.png\" alt=\"\" width=\"503\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Pilih cluster acak<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan mengetik <strong>=RANDBETWEEN(G2, G6)<\/strong> untuk memilih secara acak salah satu bilangan bulat dari daftar:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19541 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster4.png\" alt=\"\" width=\"454\" height=\"356\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita klik <strong>ENTER<\/strong> , kita dapat melihat bahwa nilai <strong>5<\/strong> telah dipilih secara acak. Tim yang terkait dengan nilai ini adalah Tim E, yang mewakili tim pertama yang akan kami sertakan dalam sampel akhir.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19542 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster5.png\" alt=\"\" width=\"440\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik dua kali sel mana pun dan tekan <strong>Enter<\/strong> . Nomor baru akan dipilih dari fungsi <strong>=RANDBETWEEN(G2, G6)<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19543 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster6.png\" alt=\"\" width=\"440\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai <strong>3<\/strong> dipilih secara acak. Tim yang terkait dengan nilai ini adalah Tim C, yang mewakili tim kedua yang akan kami sertakan dalam sampel akhir kami.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Saring sampel akhir<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sampel akhir hanya akan mencakup semua pemain yang tergabung dalam Tim C atau Tim E.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memfilter hanya pemain ini, sorot semua data. Lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik tombol <strong>Filter<\/strong> di grup <strong>Sortir &amp; Filter<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Saat filter muncul di atas setiap kolom, klik panah tarik-turun di samping kolom Tim dan centang kotak di samping Hanya Tim C dan E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19544 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster7.png\" alt=\"\" width=\"363\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik OK, kumpulan data akan difilter untuk hanya menampilkan pemain dari Tim C atau Tim E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19545 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster8.png\" alt=\"\" width=\"355\" height=\"342\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini mewakili sampel akhir kami.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pengambilan sampel cluster kami selesai karena kami memilih dua tim secara acak dan memasukkan setiap pemain dari kedua tim tersebut ke dalam sampel akhir kami.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara memilih tipe sampel lain dalam suatu populasi menggunakan Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/sampel-acak-excel\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sampel acak di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Sampling Sistematis di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pengambilan-sampel-bertingkat-excel\/\">Bagaimana melakukan pengambilan sampel bertingkat di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, kita sering mengambil sampel dari suatu populasi dan menggunakan data dari sampel tersebut untuk menarik kesimpulan tentang populasi secara keseluruhan. Metode pengambilan sampel yang umum digunakan adalah cluster sampling , yaitu suatu populasi dibagi menjadi beberapa cluster dan seluruh anggota cluster tertentu dipilih untuk dimasukkan ke dalam sampel. Contoh langkah demi langkah berikut [&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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Melakukan Cluster Sampling di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan pengambilan sampel cluster di Excel, termasuk contoh langkah demi langkah.\" \/>\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\/id\/pengambilan-sampel-cluster-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Cluster Sampling di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan pengambilan sampel cluster di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T16:49:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/\",\"name\":\"Cara Melakukan Cluster Sampling di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T16:49:29+00:00\",\"dateModified\":\"2023-07-23T16:49:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan pengambilan sampel cluster di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan cluster sampling di excel (langkah demi langkah)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Melakukan Cluster Sampling di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara melakukan pengambilan sampel cluster di Excel, termasuk contoh langkah demi langkah.","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\/id\/pengambilan-sampel-cluster-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Cluster Sampling di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan pengambilan sampel cluster di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-23T16:49:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cluster1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/","url":"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/","name":"Cara Melakukan Cluster Sampling di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T16:49:29+00:00","dateModified":"2023-07-23T16:49:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan pengambilan sampel cluster di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pengambilan-sampel-cluster-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan cluster sampling di excel (langkah demi langkah)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2102"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2102"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2102\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}