{"id":1227,"date":"2023-07-27T05:29:55","date_gmt":"2023-07-27T05:29:55","guid":{"rendered":"https:\/\/statorials.org\/id\/sampel-acak-excel\/"},"modified":"2023-07-27T05:29:55","modified_gmt":"2023-07-27T05:29:55","slug":"sampel-acak-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sampel-acak-excel\/","title":{"rendered":"Cara memilih sampel acak di excel (langkah demi langkah)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin memilih sampel acak dari kumpulan data di Excel. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi RAND()<\/strong> , yang menghasilkan angka acak antara 0 dan 1.<\/span><\/p>\n

Tutorial ini memberikan contoh langkah demi langkah tentang cara menggunakan fungsi ini untuk memilih sampel acak di Excel.<\/span><\/p>\n

Langkah 1: Buat kumpulan data<\/strong><\/h3>\n

Pertama, masukkan nilai dari kumpulan data Anda dalam satu kolom. Untuk contoh ini, kita akan memasukkan 20 nilai berbeda di kolom A:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Buat daftar nilai acak<\/strong><\/span><\/h3>\n

Selanjutnya, ketik =RAND()<\/strong> di sel B2. Ini menciptakan nilai acak antara 0 dan 1.<\/span><\/p>\n

Selanjutnya arahkan kursor ke pojok kanan bawah sel B2 hingga muncul tanda +<\/strong> kecil, lalu klik dua kali. Ini akan menyalin rumus =RAND()<\/strong> ke semua sel yang tersisa di kolom B:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 3: Salin dan tempel nilai acak<\/strong><\/span><\/h3>\n

Selanjutnya, sorot nilai di kolom B dan klik Ctrl + C.<\/strong> Ini akan menyalin semua nilai. Selanjutnya, klik kanan sel C2 dan pilih Tempel Nilai<\/strong> .<\/span><\/p>\n

Perhatikan bahwa nilai di kolom B dapat berubah setelah Anda melakukan ini, tapi jangan khawatir.<\/span> <\/p>\n

\"\"<\/p>\n

Terakhir, sorot nilai di kolom C dan seret untuk menggantikan nilai di kolom B.<\/span><\/p>\n

Akan muncul kotak dialog bertuliskan \u201cSudah ada data di sini. Apakah Anda ingin menggantinya?” Klik Oke<\/strong> .<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 4: Urutkan berdasarkan nilai acak<\/strong><\/span><\/h3>\n

Selanjutnya, sorot sel A1:B21. Lalu klik tab Data<\/strong> di sepanjang pita atas, lalu klik Sortir<\/strong> di bagian Sortir & Filter<\/strong> . Urutkan nilai berdasarkan angka acak<\/strong> dari terkecil hingga terbesar.<\/span><\/p>\n

Nilainya akan diurutkan berdasarkan angka acak, dari yang terkecil hingga yang terbesar:<\/span> <\/p>\n

\"Sampel<\/p>\n

Langkah 5: Pilih sampel acak<\/strong><\/span><\/h3>\n

Terakhir, pilih n<\/em> baris pertama untuk menjadi bagian dari sampel acak Anda. Misalnya, jika Anda menginginkan sampel acak berukuran 5, pilih 5 nilai data mentah pertama untuk disertakan dalam sampel Anda.<\/span><\/p>\n

Dalam contoh ini, sampel acak kita akan mencakup 5 nilai pertama: 8, 18, 26, 24, 24.<\/span> <\/p>\n

\"Pilih<\/p>\n","protected":false},"excerpt":{"rendered":"

Seringkali Anda mungkin ingin memilih sampel acak dari kumpulan data di Excel. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi RAND() , yang menghasilkan angka acak antara 0 dan 1. Tutorial ini memberikan contoh langkah demi langkah tentang cara menggunakan fungsi ini untuk memilih sampel acak di Excel. Langkah 1: Buat kumpulan data Pertama, masukkan […]<\/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":"\nCara Memilih Sampel Acak di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghasilkan sampel acak di Excel, beserta contohnya.\" \/>\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\/sampel-acak-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memilih Sampel Acak di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghasilkan sampel acak di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sampel-acak-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T05:29:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/randomsampleexcel1-1.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\/sampel-acak-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/sampel-acak-excel\/\",\"name\":\"Cara Memilih Sampel Acak di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T05:29:55+00:00\",\"dateModified\":\"2023-07-27T05:29:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghasilkan sampel acak di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sampel-acak-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sampel-acak-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sampel-acak-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memilih sampel acak 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 Memilih Sampel Acak di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara menghasilkan sampel acak di Excel, beserta contohnya.","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\/sampel-acak-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memilih Sampel Acak di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara menghasilkan sampel acak di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/sampel-acak-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T05:29:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/randomsampleexcel1-1.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\/sampel-acak-excel\/","url":"https:\/\/statorials.org\/id\/sampel-acak-excel\/","name":"Cara Memilih Sampel Acak di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T05:29:55+00:00","dateModified":"2023-07-27T05:29:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghasilkan sampel acak di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sampel-acak-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sampel-acak-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sampel-acak-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memilih sampel acak 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\/1227"}],"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=1227"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1227\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}