{"id":1632,"date":"2023-07-25T14:21:20","date_gmt":"2023-07-25T14:21:20","guid":{"rendered":"https:\/\/statorials.org\/id\/smape-di-excel\/"},"modified":"2023-07-25T14:21:20","modified_gmt":"2023-07-25T14:21:20","slug":"smape-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/smape-di-excel\/","title":{"rendered":"Cara menghitung smape di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Symmetric Mean Absolute Percentage Error (SMAPE)<\/strong> digunakan untuk mengukur akurasi prediksi model. Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>SMAPE<\/strong> = (1\/n) * \u03a3(|perkiraan \u2013 aktual| \/ ((|aktual| + |perkiraan|)\/2) * 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 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;\">Semakin kecil nilai SMAPE maka semakin baik akurasi prediksi suatu model.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menjelaskan cara menghitung SMAPE di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, kami akan memasukkan data palsu mengenai penjualan aktual dan perkiraan penjualan selama 12 periode penjualan berturut-turut untuk bisnis tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16122 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smapeexcel1.png\" alt=\"\" width=\"508\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung perbedaan SMAPE<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menghitung selisih SMAPE setiap periode penjualan dengan rumus sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16124 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smapeexcel2.png\" alt=\"\" width=\"576\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung SMAPE<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan menggunakan rumus berikut untuk menghitung SMAPE:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16126\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smapeexcel3-1.png\" alt=\"SMAPE di Excel\" width=\"570\" height=\"520\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">SMAPE untuk model khusus ini ternyata <strong>9,89<\/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 MAPE di Excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung MAE di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kesalahan-akar-rata-rata-kuadrat-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung RMSE di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Symmetric Mean Absolute Percentage Error (SMAPE) digunakan untuk mengukur akurasi prediksi model. Ini dihitung sebagai berikut: SMAPE = (1\/n) * \u03a3(|perkiraan \u2013 aktual| \/ ((|aktual| + |perkiraan|)\/2) * 100 Emas: \u03a3 \u2013 simbol yang berarti \u201cjumlah\u201d n \u2013 ukuran sampel nyata \u2013 nilai sebenarnya dari data perkiraan \u2013 nilai yang diharapkan dari data Semakin kecil [&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 SMAPE di Excel (Dengan Contoh)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung Symmetric Mean Absolute Percentage Error (SMAPE) di Excel, beserta contohnya.\" \/>\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\/smape-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung SMAPE di Excel (Dengan Contoh)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung Symmetric Mean Absolute Percentage Error (SMAPE) di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/smape-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T14:21:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smapeexcel1.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\/smape-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/smape-di-excel\/\",\"name\":\"Cara Menghitung SMAPE di Excel (Dengan Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T14:21:20+00:00\",\"dateModified\":\"2023-07-25T14:21:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung Symmetric Mean Absolute Percentage Error (SMAPE) di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/smape-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/smape-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/smape-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung smape di excel (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 SMAPE di Excel (Dengan Contoh)","description":"Tutorial ini menjelaskan cara menghitung Symmetric Mean Absolute Percentage Error (SMAPE) di Excel, beserta contohnya.","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\/smape-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung SMAPE di Excel (Dengan Contoh)","og_description":"Tutorial ini menjelaskan cara menghitung Symmetric Mean Absolute Percentage Error (SMAPE) di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/smape-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T14:21:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smapeexcel1.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\/smape-di-excel\/","url":"https:\/\/statorials.org\/id\/smape-di-excel\/","name":"Cara Menghitung SMAPE di Excel (Dengan Contoh)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T14:21:20+00:00","dateModified":"2023-07-25T14:21:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung Symmetric Mean Absolute Percentage Error (SMAPE) di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/smape-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/smape-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/smape-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung smape di excel (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\/1632"}],"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=1632"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1632\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}