{"id":635,"date":"2023-07-29T06:33:35","date_gmt":"2023-07-29T06:33:35","guid":{"rendered":"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/"},"modified":"2023-07-29T06:33:35","modified_gmt":"2023-07-29T06:33:35","slug":"peta-excel-tertimbang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/","title":{"rendered":"Cara menghitung mape tertimbang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Salah satu metrik yang paling umum digunakan untuk mengukur keakuratan perkiraan model adalah <strong>MAPE<\/strong> , yang merupakan singkatan dari <strong>persentase kesalahan absolut rata-rata<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung MAPE adalah sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>MAPE<\/strong> = (1\/n) * \u03a3(|aktual \u2013 perkiraan| \/ |aktual|) * 100<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3<\/strong> \u2013 simbol mewah yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> \u2013 ukuran sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>nyata<\/strong> \u2013 nilai sebenarnya dari data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>perkiraan<\/strong> \u2013 nilai yang diharapkan dari data<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">MAPE umum digunakan karena mudah diinterpretasikan dan dijelaskan. Misalnya nilai MAPE 8% berarti selisih rata-rata antara nilai prediksi dan nilai sebenarnya adalah 8%.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun,<\/span> <span style=\"color: #000000;\">MAPE berkinerja buruk dengan volume data yang rendah. Misalnya, jika permintaan aktual suatu barang adalah 2 dan perkiraannya adalah 1, nilai persentase kesalahan absolutnya adalah |2-1| \/ |2| = 50%, yang membuat kesalahan perkiraan tampak cukup tinggi, meskipun perkiraan hanya meleset 1 satuan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, alternatif MAPE adalah <strong>MAPE<\/strong> <strong>tertimbang<\/strong> , yang dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>MAPE tertimbang<\/strong> = \u03a3(|aktual \u2013 perkiraan| \/ |aktual|) * 100 * aktual \/ \u03a3(aktual)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan menimbang persentase kesalahan berdasarkan volume, kita bisa mendapatkan gambaran lebih baik tentang kesalahan sebenarnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung MAPE tertimbang di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: MAPE tertimbang di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung MAPE tertimbang di Excel, kita dapat melakukan langkah-langkah berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai aktual dan nilai prediksi dalam dua kolom terpisah.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6005 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wmape1.png\" alt=\"Data mentah di Excel\" width=\"377\" height=\"350\" srcset=\"\" sizes=\"\"><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung kesalahan tertimbang untuk setiap baris.<\/strong><\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\">Ingatlah bahwa kesalahan tertimbang dihitung sebagai berikut: |perkiraan aktual| \/ |nyata| *100* nyata. Kami akan menggunakan rumus ini untuk menghitung kesalahan tertimbang untuk setiap baris.<\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\">Kolom D menunjukkan kesalahan tertimbang dan kolom E menunjukkan rumus yang kita gunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6006 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wmape2.png\" alt=\"Rumus MAPE Tertimbang di Excel\" width=\"532\" height=\"322\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengulangi rumus ini untuk setiap baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6007 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wmape3.png\" alt=\"MAPE tertimbang di Excel\" width=\"558\" height=\"351\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan jumlah nilai sebenarnya.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6008 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wmape4.png\" alt=\"Contoh MAPE Tertimbang di Excel\" width=\"559\" height=\"342\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung MAPE tertimbang.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan menghitung MAPE tertimbang dengan membagi total kesalahan tertimbang dengan jumlah nilai sebenarnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6009 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wmape5.png\" alt=\"Rumus MAPE Tertimbang di Excel\" width=\"577\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">MAPE tertimbang ternyata <strong>5,92<\/strong> <strong>%<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/kartu-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean Absolute Percentage Error (MAPE) di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean Square Error (MSE) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Salah satu metrik yang paling umum digunakan untuk mengukur keakuratan perkiraan model adalah MAPE , yang merupakan singkatan dari persentase kesalahan absolut rata-rata . Rumus untuk menghitung MAPE adalah sebagai berikut: MAPE = (1\/n) * \u03a3(|aktual \u2013 perkiraan| \/ |aktual|) * 100 Emas: \u03a3 \u2013 simbol mewah yang berarti \u201cjumlah\u201d n \u2013 ukuran sampel nyata [&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 MAPE Tertimbang di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung MAPE tertimbang di Excel, termasuk contoh langkah demi langkah.\" \/>\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\/peta-excel-tertimbang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung MAPE Tertimbang di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung MAPE tertimbang di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T06:33:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wmape1.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\/peta-excel-tertimbang\/\",\"url\":\"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/\",\"name\":\"Cara Menghitung MAPE Tertimbang di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T06:33:35+00:00\",\"dateModified\":\"2023-07-29T06:33:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung MAPE tertimbang di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung mape 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 Menghitung MAPE Tertimbang di Excel \u2013 Statologi","description":"Penjelasan sederhana cara menghitung MAPE tertimbang di Excel, termasuk contoh langkah demi langkah.","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\/peta-excel-tertimbang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung MAPE Tertimbang di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara menghitung MAPE tertimbang di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/","og_site_name":"Statorials","article_published_time":"2023-07-29T06:33:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wmape1.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\/peta-excel-tertimbang\/","url":"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/","name":"Cara Menghitung MAPE Tertimbang di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T06:33:35+00:00","dateModified":"2023-07-29T06:33:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung MAPE tertimbang di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/peta-excel-tertimbang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/peta-excel-tertimbang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung mape 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\/635"}],"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=635"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/635\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}