{"id":4606,"date":"2023-07-09T16:55:51","date_gmt":"2023-07-09T16:55:51","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/"},"modified":"2023-07-09T16:55:51","modified_gmt":"2023-07-09T16:55:51","slug":"excel-menghasilkan-angka-acak-antar-rentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/","title":{"rendered":"Excel: menghasilkan nomor acak antar rentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Ada dua cara untuk menghasilkan angka acak antar rentang di Excel:<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Metode 1: Gunakan RANDBETWEEN() untuk menghasilkan bilangan bulat acak dalam suatu rentang<\/span><\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RANDBETWEEN(1, 10)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan menghasilkan bilangan bulat acak antara 1 dan 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Metode 2: Gunakan RAND() untuk menghasilkan angka acak dengan angka desimal dalam rentang tersebut<\/span><\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RANDBETWEEN(5, 14) + RAND()<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan menghasilkan nilai acak dengan tempat desimal antara 5 dan 15.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h2> <strong>Langkah 1: <span style=\"color: #000000;\">Gunakan RANDBETWEEN() untuk menghasilkan bilangan bulat acak dalam rentang tersebut<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghasilkan bilangan acak antara 1 dan 10:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RANDBETWEEN(1, 10)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>A1<\/strong> dan tekan <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35949 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rbet1.png\" alt=\"\" width=\"399\" height=\"359\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>RANDBETWEEN()<\/strong> menghasilkan bilangan bulat acak <strong>9<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa mengklik dan menyeret rumus ini ke sel lain di kolom yang sama untuk menghasilkan daftar bilangan bulat acak antara 1 dan 10:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-35950\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rbet2.png\" alt=\"Excel menghasilkan bilangan bulat acak antar rentang\" width=\"473\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Masing-masing sel di kolom A sekarang berisi bilangan bulat acak antara 1 dan 10.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan RAND() untuk menghasilkan angka acak dengan angka desimal dalam rentang tersebut<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghasilkan bilangan acak dengan tempat desimal antara 5 dan 15:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RANDBETWEEN(5, 14) + RAND()<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>A1<\/strong> dan tekan <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-35951\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rbet3.png\" alt=\"Excel menghasilkan nilai acak antara rentang dengan tempat desimal\" width=\"461\" height=\"369\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya menghasilkan nilai <strong>8.22564<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Begini cara kerja rumus ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pertama, <strong>RANDBETWEEN()<\/strong> menghasilkan bilangan bulat acak antara <strong>5<\/strong> dan <strong>14<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian <strong>RAND()<\/strong> menghasilkan desimal acak antara <strong>0<\/strong> dan <strong>1<\/strong> dan menambahkannya ke bilangan bulat.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Hasilnya adalah nilai acak dengan tempat desimal antara 5 dan 15.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga bisa menyeret dan mengisi rumus ini ke sel lain di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35952 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rbet4.png\" alt=\"\" width=\"472\" height=\"397\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Masing-masing sel di kolom A sekarang berisi nilai acak dengan tempat desimal antara 5 dan 15.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/seleksi-acak-excel-dengan-kriteria\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sel secara acak berdasarkan kriteria di Excel<\/a><br \/> <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\/rata-rata-excel-jika-antara-dua-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata antara dua nilai di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada dua cara untuk menghasilkan angka acak antar rentang di Excel: Metode 1: Gunakan RANDBETWEEN() untuk menghasilkan bilangan bulat acak dalam suatu rentang =RANDBETWEEN(1, 10) Rumus khusus ini akan menghasilkan bilangan bulat acak antara 1 dan 10. Metode 2: Gunakan RAND() untuk menghasilkan angka acak dengan angka desimal dalam rentang tersebut =RANDBETWEEN(5, 14) + RAND() [&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>Excel: menghasilkan nomor acak antar rentang \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghasilkan angka acak antara rentang tertentu di Excel, dengan beberapa contoh.\" \/>\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\/excel-menghasilkan-angka-acak-antar-rentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: menghasilkan nomor acak antar rentang \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghasilkan angka acak antara rentang tertentu di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T16:55:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rbet1.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\/excel-menghasilkan-angka-acak-antar-rentang\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/\",\"name\":\"Excel: menghasilkan nomor acak antar rentang \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T16:55:51+00:00\",\"dateModified\":\"2023-07-09T16:55:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghasilkan angka acak antara rentang tertentu di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: menghasilkan nomor acak antar rentang\"}]},{\"@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":"Excel: menghasilkan nomor acak antar rentang \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghasilkan angka acak antara rentang tertentu di Excel, dengan beberapa contoh.","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\/excel-menghasilkan-angka-acak-antar-rentang\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: menghasilkan nomor acak antar rentang \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghasilkan angka acak antara rentang tertentu di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/","og_site_name":"Statorials","article_published_time":"2023-07-09T16:55:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rbet1.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\/excel-menghasilkan-angka-acak-antar-rentang\/","url":"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/","name":"Excel: menghasilkan nomor acak antar rentang \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T16:55:51+00:00","dateModified":"2023-07-09T16:55:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghasilkan angka acak antara rentang tertentu di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: menghasilkan nomor acak antar rentang"}]},{"@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\/4606"}],"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=4606"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4606\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}