{"id":595,"date":"2023-07-29T09:36:52","date_gmt":"2023-07-29T09:36:52","guid":{"rendered":"https:\/\/statorials.org\/id\/kartu-excel\/"},"modified":"2023-07-29T09:36:52","modified_gmt":"2023-07-29T09:36:52","slug":"kartu-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kartu-excel\/","title":{"rendered":"Cara menghitung mean absolute percentage error (mape) 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 sebesar 11,5% berarti selisih rata-rata antara nilai prediksi dengan nilai sebenarnya adalah 11,5%.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Semakin rendah nilai MAPE, semakin baik suatu model mampu memprediksi nilai. Misalnya model dengan MAPE 2% lebih akurat dibandingkan model dengan MAPE 10%.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Cara Menghitung MAPE di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung MAPE 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-5467 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mape1.png\" alt=\"Cara Menghitung MAPE di Excel\" width=\"431\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung persentase kesalahan absolut untuk setiap baris.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ingatlah bahwa persentase kesalahan absolut dihitung sebagai berikut: |perkiraan aktual| \/ |nyata| * 100. Kita akan menggunakan rumus ini untuk menghitung persentase kesalahan absolut untuk setiap baris.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kolom D menunjukkan persentase kesalahan absolut dan kolom E menunjukkan rumus yang kita gunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5469 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mape2-1.png\" alt=\"Contoh MAPE di Excel\" width=\"566\" height=\"370\" 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-5470 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mape3.png\" alt=\"MAPE dalam perhitungan Excel\" width=\"568\" height=\"310\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung persentase kesalahan absolut rata-rata.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Hitung MAPE hanya dengan mencari rata-rata nilai di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5472 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mape4.png\" alt=\"Contoh MAPE di Excel\" width=\"576\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">MAPE model ini ternyata <strong>6,47%<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Catatan tentang penggunaan MAPE<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Meskipun MAPE mudah untuk dihitung dan diinterpretasikan, ada beberapa potensi kelemahan dalam penggunaannya:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Karena rumus menghitung persentase kesalahan absolut adalah |perkiraan aktual| \/ |nyata| ini berarti tidak akan disetel jika salah satu nilai sebenarnya adalah nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> MAPE tidak boleh digunakan dengan data bervolume rendah. Misalnya, jika permintaan aktual suatu barang adalah 2 dan perkiraannya adalah 1, maka 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> <em><span style=\"color: #000000;\">Cara umum lainnya untuk mengukur keakuratan perkiraan model adalah MAD \u2013 deviasi absolut rata-rata. Pelajari cara menghitung MAD di Excel <a href=\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/em><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\" target=\"_blank\" rel=\"noopener\">Apa yang dianggap sebagai nilai bagus untuk MAPE?<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/smape-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung SMAPE di excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung MAE 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 Mean Absolute Percentage Error (MAPE) di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung Mean Absolute Percentage Error (MAPE) di Excel.\" \/>\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\/kartu-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Mean Absolute Percentage Error (MAPE) di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung Mean Absolute Percentage Error (MAPE) di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kartu-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T09:36:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mape1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/kartu-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kartu-excel\/\",\"name\":\"Cara Menghitung Mean Absolute Percentage Error (MAPE) di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T09:36:52+00:00\",\"dateModified\":\"2023-07-29T09:36:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung Mean Absolute Percentage Error (MAPE) di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kartu-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kartu-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kartu-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung mean absolute percentage error (mape) 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 Mean Absolute Percentage Error (MAPE) di Excel - Statologi","description":"Penjelasan sederhana cara menghitung Mean Absolute Percentage Error (MAPE) di Excel.","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\/kartu-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Mean Absolute Percentage Error (MAPE) di Excel - Statologi","og_description":"Penjelasan sederhana cara menghitung Mean Absolute Percentage Error (MAPE) di Excel.","og_url":"https:\/\/statorials.org\/id\/kartu-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T09:36:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mape1.png"}],"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\/kartu-excel\/","url":"https:\/\/statorials.org\/id\/kartu-excel\/","name":"Cara Menghitung Mean Absolute Percentage Error (MAPE) di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T09:36:52+00:00","dateModified":"2023-07-29T09:36:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung Mean Absolute Percentage Error (MAPE) di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kartu-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kartu-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kartu-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung mean absolute percentage error (mape) 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\/595"}],"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=595"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/595\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}