{"id":3517,"date":"2023-07-17T01:54:55","date_gmt":"2023-07-17T01:54:55","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/"},"modified":"2023-07-17T01:54:55","modified_gmt":"2023-07-17T01:54:55","slug":"rata-rata-tertimbang-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/","title":{"rendered":"Cara menghitung rata-rata tertimbang di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan salah satu metode berikut untuk menghitung rata-rata tertimbang di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan RATA-RATA.WEIGHTED<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGE.WEIGHTED( <span dir=\"auto\" style=\"color: #ff6600;\">B2:B5<\/span> , <span dir=\"auto\" style=\"color: #800080;\">C2:C5<\/span> )\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan SUMPRODUK<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=SUMPRODUCT( <span dir=\"auto\" style=\"color: #ff6600;\">B2:B5<\/span> , <span dir=\"auto\" style=\"color: #800080;\">C2:C5<\/span> )\/SUM( <span style=\"color: #800080;\">C2:C5<\/span> )<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kedua rumus tersebut mengasumsikan nilai berada dalam rentang <strong>B2:B5<\/strong> dan bobot berada dalam rentang <strong>C2:C5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kedua rumus akan memberikan hasil yang sama, tetapi metode <strong>AVERAGE.WEIGHTED<\/strong> memerlukan lebih sedikit pengetikan.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29245 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wa1.jpg\" alt=\"\" width=\"482\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung rata-rata tertimbang menggunakan AVERAGE.WEIGHTED<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk menghitung rata-rata tertimbang nilai ujian siswa tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGE.WEIGHTED( <span dir=\"auto\" style=\"color: #ff6600;\">B2:B5<\/span> , <span dir=\"auto\" style=\"color: #800080;\">C2:C5<\/span> )<\/span><\/strong><\/span><\/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-29246\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wa2.jpg\" alt=\"rata-rata tertimbang di Google Spreadsheet\" width=\"578\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Dari hasil tersebut terlihat rata-rata tertimbang nilai ujian adalah <strong>79,5<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara rumus <strong>AVERAGE.WEIGHTED<\/strong> menghitung nilai ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata tertimbang = (90*.15 + 80*.15 + 85*.15 + 75*.55) \/ (.15 + .15 + .15 + .55) = <strong>79.5<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung rata-rata tertimbang menggunakan SUMPRODUK<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita juga dapat mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk menghitung rata-rata tertimbang nilai ujian siswa tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=SUMPRODUCT( <span dir=\"auto\" style=\"color: #ff6600;\">B2:B5<\/span> , <span dir=\"auto\" style=\"color: #800080;\">C2:C5<\/span> )\/SUM( <span style=\"color: #800080;\">C2:C5<\/span> )<\/span><\/strong><\/span><\/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-29247 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wa3.jpg\" alt=\"\" width=\"571\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasil tersebut terlihat rata-rata tertimbang nilai ujian adalah <strong>79,5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan rata-rata tertimbang yang kami hitung pada contoh sebelumnya.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika sel berisi teks di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata per bulan di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata baris yang difilter di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan salah satu metode berikut untuk menghitung rata-rata tertimbang di Google Spreadsheet: Metode 1: Gunakan RATA-RATA.WEIGHTED =AVERAGE.WEIGHTED( B2:B5 , C2:C5 ) Metode 2: Gunakan SUMPRODUK =SUMPRODUCT( B2:B5 , C2:C5 )\/SUM( C2:C5 ) Kedua rumus tersebut mengasumsikan nilai berada dalam rentang B2:B5 dan bobot berada dalam rentang C2:C5 . Kedua rumus akan memberikan hasil [&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 rata-rata tertimbang di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Google Sheets, dengan dua 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-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung rata-rata tertimbang di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Google Sheets, dengan dua contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T01:54:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wa1.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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/\",\"name\":\"Cara menghitung rata-rata tertimbang di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T01:54:55+00:00\",\"dateModified\":\"2023-07-17T01:54:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Google Sheets, dengan dua contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata tertimbang di google spreadsheet\"}]},{\"@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 rata-rata tertimbang di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Google Sheets, dengan dua 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-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung rata-rata tertimbang di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Google Sheets, dengan dua contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-17T01:54:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wa1.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-google-sheet\/","url":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/","name":"Cara menghitung rata-rata tertimbang di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T01:54:55+00:00","dateModified":"2023-07-17T01:54:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Google Sheets, dengan dua contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-tertimbang-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata tertimbang di google spreadsheet"}]},{"@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\/3517"}],"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=3517"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3517\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}