{"id":4715,"date":"2023-07-08T16:22:23","date_gmt":"2023-07-08T16:22:23","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/"},"modified":"2023-07-08T16:22:23","modified_gmt":"2023-07-08T16:22:23","slug":"excel-menghitung-persentase-terbalik","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/","title":{"rendered":"Cara menghitung persentase terbalik di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung persentase terbalik di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, <em><strong>nilai 48 mewakili 75% dari angka berapa?<\/strong><\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitungnya secara manual, Anda cukup melakukan 48 \/ 0.75 = <strong>64<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan perhitungan ini di Excel, dengan asumsi 48 ada di sel B2 dan 75% di sel C2, Anda bisa menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #3366ff;\">B2<\/span> \/ <span style=\"color: #ff0000;\">C2<\/span><\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini akan mengembalikan nilai <strong>64<\/strong> yang benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Persentase Terbalik di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan jumlah poin yang dicetak pada kuarter pertama oleh berbagai tim bola basket serta persentase total poin yang diwakili oleh poin kuarter pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36816 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rp1.png\" alt=\"\" width=\"539\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Mavs mencetak 25 poin di kuarter pertama, yang merupakan 20% dari total poin yang mereka cetak di keseluruhan pertandingan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung persentase invers, yaitu mencari jumlah total poin, kita dapat melakukan perhitungan berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jumlah poin = 25\/20% = 25 \/ 0,20 = <strong>125<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut ke dalam sel <strong>C2<\/strong> untuk melakukan perhitungan ini di spreadsheet kita:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #3366ff;\">B2<\/span> \/ <span style=\"color: #ff0000;\">C2<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36817\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rp2.png\" alt=\"Excel menghitung persentase terbalik\" width=\"534\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom D sekarang menampilkan total poin yang dicetak oleh masing-masing tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Mavs<\/strong> mencetak 25\/0,20 = <strong>125<\/strong> total poin.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Spurs<\/strong> mencetak 40\/0,25 = <strong>160<\/strong> total poin.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Rockets<\/strong> mencetak 30\/0,30 = <strong>100<\/strong> poin total.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Raja<\/strong> mencetak 30\/0,20 = <strong>150<\/strong> poin total.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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\/excel-menemukan-10-persen-teratas\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10% nilai teratas di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-rata-rata-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Rata-Rata di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara mencari persentase dua angka di excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menghitung persentase terbalik di Excel. Misalnya, nilai 48 mewakili 75% dari angka berapa? Untuk menghitungnya secara manual, Anda cukup melakukan 48 \/ 0.75 = 64 . Untuk melakukan perhitungan ini di Excel, dengan asumsi 48 ada di sel B2 dan 75% di sel C2, Anda bisa menggunakan rumus berikut: = B2 [&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 Persentase Terbalik di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persentase invers 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-menghitung-persentase-terbalik\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Persentase Terbalik di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persentase invers di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T16:22:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rp1.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-menghitung-persentase-terbalik\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/\",\"name\":\"Cara Menghitung Persentase Terbalik di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T16:22:23+00:00\",\"dateModified\":\"2023-07-08T16:22:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persentase invers di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase terbalik di excel\"}]},{\"@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 Persentase Terbalik di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung persentase invers 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-menghitung-persentase-terbalik\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Terbalik di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung persentase invers di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/","og_site_name":"Statorials","article_published_time":"2023-07-08T16:22:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rp1.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-menghitung-persentase-terbalik\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/","name":"Cara Menghitung Persentase Terbalik di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T16:22:23+00:00","dateModified":"2023-07-08T16:22:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persentase invers di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-persentase-terbalik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase terbalik di excel"}]},{"@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\/4715"}],"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=4715"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4715\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}