{"id":4511,"date":"2023-07-10T12:30:30","date_gmt":"2023-07-10T12:30:30","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/"},"modified":"2023-07-10T12:30:30","modified_gmt":"2023-07-10T12:30:30","slug":"rata-rata-tertimbang-jika-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/","title":{"rendered":"Google spreadsheet: rumus if rata-rata tertimbang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut di Google Spreadsheet untuk menerapkan rumus IF rata-rata tertimbang:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--( <span style=\"color: #ff6600;\">A2:A7<\/span> =\" <span style=\"color: #008000;\">A<\/span> \"), <span style=\"color: #800080;\">B2:B7<\/span> , <span style=\"color: #008080;\">C2:C7<\/span> )\/SUMIF( <span style=\"color: #ff6600;\">A2:A7<\/span> , \" <span style=\"color: #008000;\">A<\/span> \", <span style=\"color: #008080;\">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<h2> <span style=\"color: #000000;\"><strong>Contoh: Rumus IF Rata-Rata Tertimbang di Google Spreadsheet<\/strong><\/span><\/h2>\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-35265 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wi1.png\" alt=\"\" width=\"494\" height=\"421\" 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: #ff6600;\">A2:A7<\/span> =\" <span style=\"color: #008000;\">A<\/span> \"), <span style=\"color: #800080;\">B2:B7<\/span> , <span style=\"color: #008080;\">C2:C7<\/span> )\/SUMIF( <span style=\"color: #ff6600;\">A2:A7<\/span> , \" <span style=\"color: #008000;\">A<\/span> \", <span style=\"color: #008080;\">C2:C7<\/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=\"aligncenter wp-image-35266\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wi2.png\" alt=\"Rumus IF Rata-Rata Tertimbang di Google Spreadsheet\" width=\"679\" height=\"431\" 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 kami hitung menggunakan rumus Google Sheets.<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-per-grup\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara menghitung rata-rata berdasarkan kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-tidak-termasuk-outlier\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: hitung rata-rata tidak termasuk outlier<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-antara-dua-tanggal\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: hitung rata-rata antara dua tanggal<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut di Google Spreadsheet untuk menerapkan rumus IF rata-rata tertimbang: =SUMPRODUCT(&#8211;( A2:A7 =&#8221; A &#8220;), B2:B7 , C2:C7 )\/SUMIF( A2:A7 , &#8221; A &#8220;, 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 [&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>Google Spreadsheet: Rumus IF Rata-Rata Tertimbang \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Google Sheets, 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\/rata-rata-tertimbang-jika-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Rumus IF Rata-Rata Tertimbang \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T12:30:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wi1.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\/rata-rata-tertimbang-jika-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/\",\"name\":\"Google Spreadsheet: Rumus IF Rata-Rata Tertimbang \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T12:30:30+00:00\",\"dateModified\":\"2023-07-10T12:30:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: rumus if rata-rata tertimbang\"}]},{\"@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":"Google Spreadsheet: Rumus IF Rata-Rata Tertimbang \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Google Sheets, 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\/rata-rata-tertimbang-jika-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Rumus IF Rata-Rata Tertimbang \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-10T12:30:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wi1.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\/rata-rata-tertimbang-jika-google-sheet\/","url":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/","name":"Google Spreadsheet: Rumus IF Rata-Rata Tertimbang \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T12:30:30+00:00","dateModified":"2023-07-10T12:30:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus IF rata-rata tertimbang di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-jika-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: rumus if rata-rata tertimbang"}]},{"@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\/4511"}],"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=4511"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4511\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}