{"id":2289,"date":"2023-07-22T22:19:07","date_gmt":"2023-07-22T22:19:07","guid":{"rendered":"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/"},"modified":"2023-07-22T22:19:07","modified_gmt":"2023-07-22T22:19:07","slug":"contoh-lembar-acak-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/","title":{"rendered":"Cara memilih sampel acak di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin memilih sampel acak dari kumpulan data di Google Spreadsheet. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi <strong>RAND()<\/strong> , yang menghasilkan angka acak antara 0 dan 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini untuk memilih sampel acak di Google Spreadsheet.<\/span><\/p>\n<h3> <strong>Langkah 1: Buat kumpulan data<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan nilai dari kumpulan data ke dalam satu kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20806 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire1.png\" alt=\"\" width=\"531\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat daftar nilai acak<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketik <strong>=RAND()<\/strong> di sel B2. Ini menciptakan nilai acak antara 0 dan 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Salin dan tempel rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20808 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire2.png\" alt=\"\" width=\"584\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Salin dan tempel nilai acak<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai di kolom B dan klik <strong>Ctrl + C.<\/strong> Ini akan menyalin semua nilai. Selanjutnya, klik kanan sel C2 dan pilih <strong>Tempel Spesial &gt; Tempel Nilai Saja<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai di kolom B dapat berubah setelah Anda melakukan ini, tapi jangan khawatir.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20809 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire3.png\" alt=\"\" width=\"579\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, sorot nilai di kolom C dan seret untuk menggantikan nilai di kolom B.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20810 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire4.png\" alt=\"\" width=\"574\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Urutkan berdasarkan nilai acak<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel A2:B16. Lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, dan klik <strong>Sortir Rentang<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pilih untuk mengurutkan berdasarkan nilai pada kolom B dari A sampai Z, lalu klik <strong>Sortir<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20811 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire5.png\" alt=\"\" width=\"675\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilainya akan diurutkan berdasarkan angka acak, dari yang terkecil hingga yang terbesar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20812 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire6.png\" alt=\"\" width=\"555\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 5: Pilih sampel acak<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, pilih <em>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<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20813 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire7.png\" alt=\"\" width=\"583\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, sampel acak kita akan menyertakan 5 nilai pertama: <strong>5<\/strong> , <strong>20<\/strong> , <strong>14<\/strong> , <strong>13<\/strong> , <strong>8<\/strong> .<\/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 sampel acak dari kumpulan data menggunakan perangkat lunak statistik lainnya:<\/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\/sampel-acak-di-r\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sampel acak di R<\/a><br \/> Cara memilih sampel acak dengan Python<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin memilih sampel acak dari kumpulan data di Google Spreadsheet. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi RAND() , yang menghasilkan angka acak antara 0 dan 1. Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini untuk memilih sampel acak di Google Spreadsheet. Langkah 1: Buat kumpulan data Pertama, kita [&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 memilih sampel acak di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih sampel acak di Google Sheets, dengan 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\/contoh-lembar-acak-google\/\" \/>\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 Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih sampel acak di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T22:19:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire1.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\/contoh-lembar-acak-google\/\",\"url\":\"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/\",\"name\":\"Cara memilih sampel acak di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T22:19:07+00:00\",\"dateModified\":\"2023-07-22T22:19:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih sampel acak di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memilih sampel acak di google sheets\"}]},{\"@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 Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara memilih sampel acak di Google Sheets, dengan 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\/contoh-lembar-acak-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memilih sampel acak di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara memilih sampel acak di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/","og_site_name":"Statorials","article_published_time":"2023-07-22T22:19:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echantillon-aleatoire1.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\/contoh-lembar-acak-google\/","url":"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/","name":"Cara memilih sampel acak di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T22:19:07+00:00","dateModified":"2023-07-22T22:19:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih sampel acak di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memilih sampel acak di google sheets"}]},{"@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\/2289"}],"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=2289"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2289\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}