{"id":1622,"date":"2023-07-25T15:16:04","date_gmt":"2023-07-25T15:16:04","guid":{"rendered":"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/"},"modified":"2023-07-25T15:16:04","modified_gmt":"2023-07-25T15:16:04","slug":"berarti-kesalahan-mutlak-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/","title":{"rendered":"Cara menghitung mean absolute error di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, <strong>mean absolute error<\/strong> (MAE) adalah cara untuk mengukur keakuratan model tertentu. Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">MAE = (1\/n) * \u03a3|y <sub>saya<\/sub> \u2013 x <sub>saya<\/sub> |<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3:<\/strong> Simbol Yunani yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>y <sub>i<\/sub> :<\/strong> Nilai observasi untuk observasi <sup>ke-i<\/sup><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> nilai prediksi pengamatan <sup>ke-i<\/sup><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n :<\/strong> Jumlah total observasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung rata-rata kesalahan absolut 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, masukkan daftar nilai yang diamati dan diprediksi dalam dua kolom terpisah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16061 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mae_excel1.png\" alt=\"\" width=\"503\" height=\"472\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan:<\/strong> Gunakan <a href=\"https:\/\/statorials.org\/id\/perkiraan-regresi-berganda-unggul\/\" target=\"_blank\" rel=\"noopener\">tutorial ini<\/a> jika Anda perlu mempelajari cara menggunakan model regresi untuk menghitung nilai prediksi.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung perbedaan absolut<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan rumus berikut untuk menghitung perbedaan absolut antara nilai yang diamati dan nilai prediksi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16062 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mae_excel2.png\" alt=\"\" width=\"492\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung MAE<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan rumus berikut untuk menghitung rata-rata kesalahan absolut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16063\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mae_excel3.png\" alt=\"Berarti Kesalahan Absolut di Excel\" width=\"669\" height=\"480\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata kesalahan absolut (MAE) ternyata <strong>2,5625<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini memberitahu kita bahwa rata-rata selisih mutlak antara nilai yang diamati dan nilai yang diprediksi adalah 2,5625.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara umum, semakin rendah nilai MAE, semakin baik kemampuan suatu model untuk menyesuaikan dengan kumpulan data. Saat kita membandingkan dua model berbeda, kita dapat membandingkan MAE masing-masing model untuk mengetahui model mana yang paling sesuai dengan kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Bonus:<\/strong> Jangan ragu untuk menggunakan kalkulator kesalahan absolut rata-rata ini untuk menghitung MAE secara otomatis untuk daftar nilai yang diamati dan diprediksi.<\/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\/smape-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung SMAPE di excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, mean absolute error (MAE) adalah cara untuk mengukur keakuratan model tertentu. Ini dihitung sebagai berikut: MAE = (1\/n) * \u03a3|y saya \u2013 x saya | Emas: \u03a3: Simbol Yunani yang berarti \u201cjumlah\u201d y i : Nilai observasi untuk observasi ke-i x i : nilai prediksi pengamatan ke-i n : Jumlah total observasi Contoh [&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 Error di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung mean absolute error (MAE) 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\/berarti-kesalahan-mutlak-unggul\/\" \/>\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 Error di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung mean absolute error (MAE) di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T15:16:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mae_excel1.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\/berarti-kesalahan-mutlak-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/\",\"name\":\"Cara Menghitung Mean Absolute Error di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T15:16:04+00:00\",\"dateModified\":\"2023-07-25T15:16:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung mean absolute error (MAE) di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung mean absolute error di excel (langkah demi langkah)\"}]},{\"@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 Error di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara menghitung mean absolute error (MAE) 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\/berarti-kesalahan-mutlak-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Mean Absolute Error di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara menghitung mean absolute error (MAE) di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-25T15:16:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mae_excel1.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\/berarti-kesalahan-mutlak-unggul\/","url":"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/","name":"Cara Menghitung Mean Absolute Error di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T15:16:04+00:00","dateModified":"2023-07-25T15:16:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung mean absolute error (MAE) di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/berarti-kesalahan-mutlak-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung mean absolute error di excel (langkah demi langkah)"}]},{"@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\/1622"}],"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=1622"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1622\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}