{"id":2769,"date":"2023-07-20T19:10:45","date_gmt":"2023-07-20T19:10:45","guid":{"rendered":"https:\/\/statorials.org\/id\/rasio-di-excel\/"},"modified":"2023-07-20T19:10:45","modified_gmt":"2023-07-20T19:10:45","slug":"rasio-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rasio-di-excel\/","title":{"rendered":"Cara menghitung rasio di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Rasio<\/strong> digunakan untuk membandingkan dua angka.<\/span> <span style=\"color: #000000;\">Rasio berguna untuk memahami ukuran suatu nilai relatif terhadap nilai lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, asumsikan A = 40 dan B = 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung rasio A terhadap B, kita dapat menggunakan proses dua langkah berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1<\/strong> : Temukan <a href=\"https:\/\/en.wikipedia.org\/wiki\/Greatest_common_divisor\" target=\"_blank\" rel=\"noopener\">pembagi persekutuan terbesar<\/a> (bilangan bulat terbesar yang akan membagi setiap nilai)<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai terbesar yang dapat dibagi 40 dan 10 adalah <strong>10<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2<\/strong> : Bagi setiap nilai dengan pembagi persekutuan terbesar dan tuliskan hasilnya sebagai A:B.<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rasio 40 banding 10 akan ditulis sebagai <strong>4:1<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menghitung perbandingan dua angka di Excel, kita bisa menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #3366ff;\">A2<\/span> \/GCD( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">B2<\/span> )&amp;\":\"&amp; <span style=\"color: #ff0000;\">B2<\/span> \/GCD( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">B2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung rasio antara nilai di sel <strong>A2<\/strong> dan nilai di sel <strong>B2<\/strong> , menggunakan fungsi <strong>GCD<\/strong> Excel untuk secara otomatis menemukan pembagi persekutuan terbesar antara kedua nilai tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: menghitung rasio di Excel<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua daftar nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24316 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ratioexcel1.jpg\" alt=\"\" width=\"423\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung perbandingan nilai 1 dengan nilai 2 pada setiap baris.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #3366ff;\">A2<\/span> \/GCD( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">B2<\/span> )&amp;\":\"&amp; <span style=\"color: #ff0000;\">B2<\/span> \/GCD( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">B2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24317 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ratioexcel2.jpg\" alt=\"\" width=\"537\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ternyata pembagi persekutuan terbesar dari 12 dan 5 adalah 1. Jadi, ketika kita membagi setiap nilai dengan 1, kita akan mendapatkan perbandingan <strong>12:5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menyalin dan menempelkan rumus ini di sel <strong>C2<\/strong> ke setiap sel yang tersisa di kolom C untuk menghitung rasio antara dua nilai di setiap baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24318 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ratioexcel3.jpg\" alt=\"menghitung rasio di Excel\" width=\"523\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Perbandingan antara 12 dan 5 adalah <strong>12:5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Perbandingan antara 40 dan 10 adalah <strong>4:1<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Perbandingan antara 20 dan 8 adalah <strong>5:2<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>GCD<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/gcd-function-d5107a51-69e3-461f-8e4c-ddfc21b5073a\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-nilai-unik-di-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menemukan nilai unik dari beberapa kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rasio digunakan untuk membandingkan dua angka. Rasio berguna untuk memahami ukuran suatu nilai relatif terhadap nilai lainnya. Misalnya, asumsikan A = 40 dan B = 10. Untuk menghitung rasio A terhadap B, kita dapat menggunakan proses dua langkah berikut: Langkah 1 : Temukan pembagi persekutuan terbesar (bilangan bulat terbesar yang akan membagi setiap nilai) Nilai [&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 Menghitung Rasio di Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rasio antara dua angka di Excel, beserta sebuah 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\/rasio-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rasio di Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rasio antara dua angka di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rasio-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T19:10:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ratioexcel1.jpg\" \/>\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\/rasio-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/rasio-di-excel\/\",\"name\":\"Cara Menghitung Rasio di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T19:10:45+00:00\",\"dateModified\":\"2023-07-20T19:10:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rasio antara dua angka di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rasio-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rasio-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rasio-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rasio di excel (dengan contoh)\"}]},{\"@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 Menghitung Rasio di Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menghitung rasio antara dua angka di Excel, beserta sebuah 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\/rasio-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rasio di Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rasio antara dua angka di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rasio-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T19:10:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ratioexcel1.jpg"}],"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\/rasio-di-excel\/","url":"https:\/\/statorials.org\/id\/rasio-di-excel\/","name":"Cara Menghitung Rasio di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T19:10:45+00:00","dateModified":"2023-07-20T19:10:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rasio antara dua angka di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rasio-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rasio-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rasio-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rasio di excel (dengan contoh)"}]},{"@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\/2769"}],"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=2769"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2769\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}