{"id":3503,"date":"2023-07-17T03:44:48","date_gmt":"2023-07-17T03:44:48","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/"},"modified":"2023-07-17T03:44:48","modified_gmt":"2023-07-17T03:44:48","slug":"tabel-pivot-excel-rata-rata-tertimbang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/","title":{"rendered":"Excel: cara menghitung rata-rata tertimbang dalam tabel pivot"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung rata-rata tertimbang dalam tabel pivot di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan dataset berikut yang berisi informasi tentang pemain bola basket dari dua tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29156 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poids1.jpg\" alt=\"\" width=\"415\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Kolom Dukungan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat tabel pivot yang merangkum jumlah permainan masing-masing tim serta rata-rata poin yang dicetak per pemain di setiap tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung rata-rata poin yang dicetak per pemain, kita perlu menggunakan rata-rata tertimbang yang memperhitungkan rata-rata poin serta total pertandingan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena tabel pivot di Excel tidak memungkinkan Anda menghitung rata-rata tertimbang, pertama-tama kita perlu membuat kolom pembantu di kumpulan data asli kita.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #3366ff;\">C2<\/span> * <span style=\"color: #ff0000;\">D2\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke sel yang tersisa di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29157 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poids2.jpg\" alt=\"\" width=\"419\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat PivotTable<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk membuat PivotTable, kita akan menyorot sel dalam rentang <strong>A1:E9<\/strong> lalu klik ikon <strong>PivotTable<\/strong> di tab <strong>Sisipkan<\/strong> di pita atas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada panel PivotTable Fields yang muncul, kita akan menyeret <strong>Team<\/strong> ke area Rows dan <strong>Games<\/strong> ke area Values:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29158 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wt3.jpg\" alt=\"\" width=\"360\" height=\"609\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29159 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poids4.jpg\" alt=\"\" width=\"646\" height=\"337\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Tambahkan Kolom Rata-Rata Tertimbang ke PivotTable<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menambahkan kolom rata-rata tertimbang yang menampilkan poin rata-rata per permainan per pemain untuk setiap tim, klik sel mana saja di PivotTable, lalu klik ikon bernama <strong>Bidang, Item &amp; Kumpulan<\/strong> di <strong>tab Analisis di PivotTable<\/strong> , lalu klik <strong>Bidang Terhitung<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29160 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poids5.jpg\" alt=\"\" width=\"457\" height=\"338\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, ketik <strong>=Helper\/Games<\/strong> pada kotak Formula, lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29161 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poids6.jpg\" alt=\"\" width=\"537\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom baru yang menunjukkan rata-rata poin per game per pemain untuk setiap tim akan ditambahkan ke tabel pivot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-29162\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wt7.jpg\" alt=\"Rata-rata Tertimbang PivotTable Excel\" width=\"679\" height=\"293\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat mengonfirmasi bahwa rata-rata poin per pertandingan per pemain sudah benar dengan menghitungnya secara manual dari kumpulan data asli.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menghitung rata-rata poin per game per pemain untuk Tim A sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Poin rata-rata per game dan per pemain: (22*3 + 20*4 + 15*4 + 13*5) \/ (3+4+4+5) = <strong>16,9375<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini cocok dengan nilai yang muncul di tabel pivot.<\/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\/membuat-tabel-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara membuat tabel di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-bulan-dan-tahun\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan berdasarkan bulan dan tahun dalam tabel pivot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung rata-rata tertimbang dalam tabel pivot di Excel. Langkah 1: Masukkan datanya Pertama, masukkan dataset berikut yang berisi informasi tentang pemain bola basket dari dua tim berbeda: Langkah 2: Buat Kolom Dukungan Katakanlah kita ingin membuat tabel pivot yang merangkum jumlah permainan masing-masing tim serta rata-rata poin [&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>Excel: Cara menghitung rata-rata tertimbang dalam tabel pivot - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang dalam tabel pivot 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\/tabel-pivot-excel-rata-rata-tertimbang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung rata-rata tertimbang dalam tabel pivot - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang dalam tabel pivot di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T03:44:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poids1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/\",\"name\":\"Excel: Cara menghitung rata-rata tertimbang dalam tabel pivot - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T03:44:48+00:00\",\"dateModified\":\"2023-07-17T03:44:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang dalam tabel pivot di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung rata-rata tertimbang dalam tabel pivot\"}]},{\"@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":"Excel: Cara menghitung rata-rata tertimbang dalam tabel pivot - Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang dalam tabel pivot 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\/tabel-pivot-excel-rata-rata-tertimbang\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung rata-rata tertimbang dalam tabel pivot - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang dalam tabel pivot di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/","og_site_name":"Statorials","article_published_time":"2023-07-17T03:44:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poids1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/","name":"Excel: Cara menghitung rata-rata tertimbang dalam tabel pivot - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T03:44:48+00:00","dateModified":"2023-07-17T03:44:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata tertimbang dalam tabel pivot di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-excel-rata-rata-tertimbang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung rata-rata tertimbang dalam tabel pivot"}]},{"@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\/3503"}],"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=3503"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3503\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}