{"id":4516,"date":"2023-07-10T11:33:13","date_gmt":"2023-07-10T11:33:13","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/"},"modified":"2023-07-10T11:33:13","modified_gmt":"2023-07-10T11:33:13","slug":"vba-rata-rata-tertimbang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/","title":{"rendered":"Cara menghitung rata-rata tertimbang di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menghitung rata-rata tertimbang menggunakan VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindWeightedAverage()\n\nRange(\" <span style=\"color: #ff0000;\">E2<\/span> \") = _\n    WorksheetFunction.SumProduct(Range(\" <span style=\"color: #ff0000;\">B2:B7<\/span> \"), Range(\" <span style=\"color: #ff0000;\">C2:C7<\/span> \")) \/ _\n    WorksheetFunction.Sum(Range(\" <span style=\"color: #ff0000;\">C2:C7<\/span> \"))\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung rata-rata tertimbang menggunakan sel dalam rentang <strong>B2:B7<\/strong> sebagai nilai dan sel dalam rentang <strong>C2:C7<\/strong> sebagai bobot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata tertimbang kemudian ditampilkan di sel <strong>E2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Hitung Rata-Rata Tertimbang Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan berbagai penjualan yang dilakukan oleh karyawan sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35296 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wav1.png\" alt=\"\" width=\"490\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung rata-rata tertimbang harga, dengan menggunakan nilai pada kolom <strong>Jumlah<\/strong> sebagai nilai dan nilai pada kolom <strong>Harga<\/strong> sebagai bobot:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindWeightedAverage()\n\nRange(\" <span style=\"color: #ff0000;\">E2<\/span> \") = _\n    WorksheetFunction.SumProduct(Range(\" <span style=\"color: #ff0000;\">B2:B7<\/span> \"), Range(\" <span style=\"color: #ff0000;\">C2:C7<\/span> \")) \/ _\n    WorksheetFunction.Sum(Range(\" <span style=\"color: #ff0000;\">C2:C7<\/span> \"))\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35297 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wav2.png\" alt=\"\" width=\"525\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <strong>E2<\/strong> berisi nilai <strong>9.705882<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan menghitung rata-rata tertimbang secara manual.<\/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 harga rata-rata tertimbang:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rata-rata tertimbang = \u03a3w <sub>i<\/sub> X <sub>i<\/sub> \/ \u03a3w <sub>i<\/sub><\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata tertimbang = (1*8 + 3*5 + 2*6 + 2*7 + 5*12 + 4*14) \/ (1+3+2+2+5+4)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai rata-rata siswa A = <strong>9,705882<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini cocok dengan nilai yang kami hitung menggunakan makro.<\/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 VBA:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rata-rata-vba-jika\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menghitung rata-rata tertimbang menggunakan VBA: Sub FindWeightedAverage() Range(&#8221; E2 &#8220;) = _ WorksheetFunction.SumProduct(Range(&#8221; B2:B7 &#8220;), Range(&#8221; C2:C7 &#8220;)) \/ _ WorksheetFunction.Sum(Range(&#8221; C2:C7 &#8220;)) End Sub Contoh khusus ini menghitung rata-rata tertimbang menggunakan sel dalam rentang B2:B7 sebagai nilai dan sel dalam rentang C2:C7 sebagai bobot. Rata-rata tertimbang kemudian [&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 VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Excel menggunakan VBA, 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\/vba-rata-rata-tertimbang\/\" \/>\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 VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Excel menggunakan VBA, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T11:33:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wav1.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\/vba-rata-rata-tertimbang\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/\",\"name\":\"Cara Menghitung Rata-Rata Tertimbang di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T11:33:13+00:00\",\"dateModified\":\"2023-07-10T11:33:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Excel menggunakan VBA, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata tertimbang di vba (dengan contoh)\"}]},{\"@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 VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Excel menggunakan VBA, 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\/vba-rata-rata-tertimbang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-Rata Tertimbang di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Excel menggunakan VBA, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/","og_site_name":"Statorials","article_published_time":"2023-07-10T11:33:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wav1.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\/vba-rata-rata-tertimbang\/","url":"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/","name":"Cara Menghitung Rata-Rata Tertimbang di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T11:33:13+00:00","dateModified":"2023-07-10T11:33:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang di Excel menggunakan VBA, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata tertimbang di vba (dengan contoh)"}]},{"@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\/4516"}],"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=4516"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4516\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}