{"id":2100,"date":"2023-07-23T17:01:03","date_gmt":"2023-07-23T17:01:03","guid":{"rendered":"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/"},"modified":"2023-07-23T17:01:03","modified_gmt":"2023-07-23T17:01:03","slug":"pengambilan-sampel-sistematis-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/","title":{"rendered":"Cara melakukan pengambilan sampel sistematis di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Peneliti sering kali 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>pengambilan sampel sistematis<\/strong> , yang diterapkan dalam proses dua langkah sederhana:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Tempatkan setiap anggota populasi dalam urutan tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Pilih titik awal secara acak dan pilih satu <sup>dari<\/sup> n anggota untuk menjadi bagian sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara melakukan pengambilan sampel sistematis 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 nilai dari kumpulan data ke Excel:<\/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=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan nilai parameter<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu memutuskan berapa banyak nilai yang ingin kita ambil sampelnya secara acak. Untuk contoh ini, kita akan memilih ukuran sampel n = 4.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan rumus berikut untuk menghitung ukuran populasi, ukuran langkah pengambilan sampel sistematis, dan titik awal acak:<\/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=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Beri Label pada Setiap Nilai Data<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Fungsi <strong>RANDBETWEEN()<\/strong> kami secara acak memilih nilai 3 sebagai titik awal dalam kumpulan data kami. Jadi, beri nilai data di posisi 3 label 1, lalu beri nomor hingga ukuran langkah 5:<\/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=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketik <strong>=D4<\/strong> di sel berikutnya yang tersedia:<\/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=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, salin dan tempel rumus ini ke semua sel yang tersisa di kolom D. Kemudian isi nilai di bagian atas kolom D secara manual:<\/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=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Filter nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita perlu memfilter kumpulan data agar hanya menyertakan nilai data berlabel 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, klik pada tab <strong>Data<\/strong> di sepanjang pita atas. Kemudian klik ikon <strong>Filter<\/strong> . Lalu klik kolom berlabel <strong>Label<\/strong> dan filter untuk hanya menyertakan baris yang memiliki label dengan nilai 1:<\/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=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah ini selesai, data akan difilter agar hanya menyertakan nilai data dengan label 1:<\/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=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini mewakili ukuran sampel kami 4.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/metode-pengambilan-sampel\/\" target=\"_blank\" rel=\"noopener\">Pengantar Jenis Metode Pengambilan Sampel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sampel-acak-excel\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sampel acak di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Peneliti sering kali 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 pengambilan sampel sistematis , yang diterapkan dalam proses dua langkah sederhana: 1. Tempatkan setiap anggota populasi dalam urutan tertentu. 2. Pilih titik awal secara acak dan pilih [&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>Bagaimana Melakukan Pengambilan Sampel Sistematis di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan pengambilan sampel sistematis 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-sistematis-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana Melakukan Pengambilan Sampel Sistematis di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan pengambilan sampel sistematis di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/\" \/>\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=\"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=\"1 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-sistematis-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/\",\"name\":\"Bagaimana Melakukan Pengambilan Sampel Sistematis di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T17:01:03+00:00\",\"dateModified\":\"2023-07-23T17:01:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan pengambilan sampel sistematis di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan pengambilan sampel sistematis 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":"Bagaimana Melakukan Pengambilan Sampel Sistematis di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara melakukan pengambilan sampel sistematis 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-sistematis-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana Melakukan Pengambilan Sampel Sistematis di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan pengambilan sampel sistematis di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/","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":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/","url":"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/","name":"Bagaimana Melakukan Pengambilan Sampel Sistematis di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T17:01:03+00:00","dateModified":"2023-07-23T17:01:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan pengambilan sampel sistematis di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pengambilan-sampel-sistematis-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan pengambilan sampel sistematis 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\/2100"}],"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=2100"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2100\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}