{"id":2849,"date":"2023-07-20T10:26:56","date_gmt":"2023-07-20T10:26:56","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/"},"modified":"2023-07-20T10:26:56","modified_gmt":"2023-07-20T10:26:56","slug":"persentase-tertimbang-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/","title":{"rendered":"Cara menghitung persentase tertimbang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung persentase tertimbang di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT( <span style=\"color: #3366ff;\">A:A<\/span> , <span style=\"color: #ff0000;\">B:B<\/span> )\/SUM( <span style=\"color: #ff0000;\">B:B<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mengasumsikan kolom <strong>A<\/strong> berisi nilai persentase dan kolom <strong>B<\/strong> berisi bobot.<\/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 Tertimbang di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan nilai yang diterima siswa pada berbagai ujian beserta bobot untuk setiap ujian:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24956 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-pondere1.jpg\" alt=\"\" width=\"468\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung persentase tertimbang nilai akhir mereka di kelas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT( <span style=\"color: #3366ff;\">B2:B6<\/span> , <span style=\"color: #ff0000;\">C2:C6<\/span> )\/SUM( <span style=\"color: #ff0000;\">C2:C6<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24957 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-pondere2.jpg\" alt=\"\" width=\"530\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai akhirnya adalah <strong>85%<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan menghitung persentase nilai tertimbang secara manual:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Persentase tertimbang: (90%*10%) + (91%*10%) + (81%*10%) + (78%*10%) + (85%*60%)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase tertimbang: 9% + 9,1% + 8,1% + 7,8% + 51%<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase tertimbang = <strong>85%<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Persentase tertimbang ini sesuai dengan nilai yang kita hitung menggunakan rumus sebelumnya.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>SUMPRODUK<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/rata-rata-bergerak-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Rata-Rata Pergerakan Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menggunakan Rumus IF Rata-Rata Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Deviasi Standar Tertimbang di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghitung persentase tertimbang di Excel: =SUMPRODUCT( A:A , B:B )\/SUM( B:B ) Rumus ini mengasumsikan kolom A berisi nilai persentase dan kolom B berisi bobot. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Menghitung Persentase Tertimbang di Excel Misalkan kita memiliki kumpulan data berikut yang menunjukkan 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 Persentase Tertimbang di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persentase tertimbang di Excel, dengan 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\/persentase-tertimbang-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Persentase Tertimbang di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persentase tertimbang di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T10:26:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-pondere1.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\/persentase-tertimbang-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/\",\"name\":\"Cara Menghitung Persentase Tertimbang di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T10:26:56+00:00\",\"dateModified\":\"2023-07-20T10:26:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persentase tertimbang di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase tertimbang 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 Tertimbang di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung persentase tertimbang di Excel, dengan 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\/persentase-tertimbang-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Tertimbang di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung persentase tertimbang di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-20T10:26:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-pondere1.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\/persentase-tertimbang-unggul\/","url":"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/","name":"Cara Menghitung Persentase Tertimbang di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T10:26:56+00:00","dateModified":"2023-07-20T10:26:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persentase tertimbang di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase tertimbang 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\/2849"}],"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=2849"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2849\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}