{"id":2779,"date":"2023-07-20T18:06:17","date_gmt":"2023-07-20T18:06:17","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/"},"modified":"2023-07-20T18:06:17","modified_gmt":"2023-07-20T18:06:17","slug":"rata-rata-tertimbang-jika-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/","title":{"rendered":"Cara menggunakan rumus if rata-rata tertimbang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan sintaks berikut di Excel untuk menerapkan rumus IF rata-rata tertimbang:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--( <span style=\"color: #3366ff;\">A2:A7<\/span> =\"A\"), <span style=\"color: #ff0000;\">B2:B7<\/span> , <span style=\"color: #800080;\">C2:C7<\/span> )\/SUMIF( <span style=\"color: #3366ff;\">A2:A7<\/span> , \"A\", <span style=\"color: #800080;\">C2:C7<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung rata-rata tertimbang dari nilai dalam rentang <strong>B2:B7<\/strong> , menggunakan <strong>C2:C7<\/strong> sebagai bobotnya, <em>hanya<\/em> untuk sel yang <strong>A2:A7<\/strong> sama dengan &#8220;A&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Rumus IF Rata-Rata Tertimbang di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut yang menunjukkan nilai dua siswa (Siswa A dan Siswa B) pada tiga ujian berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24404 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere1.jpg\" alt=\"\" width=\"459\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menggunakan rumus berikut untuk menghitung rata-rata tertimbang nilai ujian siswa A saja:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--( <span style=\"color: #3366ff;\">A2:A7<\/span> =\"A\"), <span style=\"color: #ff0000;\">B2:B7<\/span> , <span style=\"color: #800080;\">C2:C7<\/span> )\/SUMIF( <span style=\"color: #3366ff;\">A2:A7<\/span> , \"A\", <span style=\"color: #800080;\">C2:C7<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24405 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pondere2.jpg\" alt=\"Rumus IF Rata-Rata Tertimbang di Excel\" width=\"675\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai ujian rata-rata tertimbang Siswa A adalah <strong>78<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan menghitung secara manual nilai ujian rata-rata tertimbang Siswa A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ingatlah bahwa kami menggunakan rumus berikut untuk rata-rata tertimbang:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rata-rata tertimbang = \u03a3w <sub>i<\/sub> X <sub>i<\/sub> \/ \u03a3w <sub>i<\/sub><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>w <sub>i<\/sub><\/strong> = nilai bobot<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>X <sub>i<\/sub><\/strong> = nilai data<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat memasukkan nilai dari kumpulan data kita ke dalam rumus ini untuk menghitung rata-rata tertimbang nilai ujian Siswa A:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rata-rata tertimbang siswa A = \u03a3w <sub>i<\/sub> X <sub>i<\/sub> \/ \u03a3w <sub>i<\/sub><\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata tertimbang siswa A = (2*60 + 5*90 + 70*3) \/ (2+5+3)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai rata-rata siswa A = <strong>78<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini cocok dengan nilai yang kita hitung menggunakan rumus di Excel.<\/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\/rata-rata-pergerakan-eksponensial-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Pergerakan Eksponensial di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-bergerak-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Pergerakan Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-kumulatif-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Kumulatif di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan sintaks berikut di Excel untuk menerapkan rumus IF rata-rata tertimbang: =SUMPRODUCT(&#8211;( A2:A7 =&#8221;A&#8221;), B2:B7 , C2:C7 )\/SUMIF( A2:A7 , &#8220;A&#8221;, C2:C7 ) Rumus ini menghitung rata-rata tertimbang dari nilai dalam rentang B2:B7 , menggunakan C2:C7 sebagai bobotnya, hanya untuk sel yang A2:A7 sama dengan &#8220;A&#8221;. Contoh berikut menunjukkan cara menggunakan rumus ini [&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 Menggunakan Rumus IF Rata-Rata Tertimbang di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Excel, beserta contoh lengkapnya.\" \/>\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\/rata-rata-tertimbang-jika-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Rumus IF Rata-Rata Tertimbang di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T18:06:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/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\/rata-rata-tertimbang-jika-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/\",\"name\":\"Cara Menggunakan Rumus IF Rata-Rata Tertimbang di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T18:06:17+00:00\",\"dateModified\":\"2023-07-20T18:06:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan rumus if rata-rata 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 Menggunakan Rumus IF Rata-Rata Tertimbang di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Excel, beserta contoh lengkapnya.","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\/rata-rata-tertimbang-jika-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Rumus IF Rata-Rata Tertimbang di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-20T18:06:17+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/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\/rata-rata-tertimbang-jika-unggul\/","url":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/","name":"Cara Menggunakan Rumus IF Rata-Rata Tertimbang di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T18:06:17+00:00","dateModified":"2023-07-20T18:06:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan rumus if rata-rata 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\/2779"}],"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=2779"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2779\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}