{"id":596,"date":"2023-07-29T09:32:51","date_gmt":"2023-07-29T09:32:51","guid":{"rendered":"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/"},"modified":"2023-07-29T09:32:51","modified_gmt":"2023-07-29T09:32:51","slug":"cara-menghitung-mean-square-mse-error-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/","title":{"rendered":"Cara menghitung mean square error (mse) di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Salah satu metrik yang paling umum digunakan untuk mengukur keakuratan prediksi suatu model adalah <strong>MSE<\/strong> , yang merupakan singkatan dari <strong>mean square error<\/strong> . Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>MSE<\/strong> = (1\/n) * \u03a3(aktual \u2013 perkiraan) <sup>2<\/sup><\/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;\">Semakin rendah nilai MSE, semakin akurat suatu model dalam memprediksi nilai.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Cara Menghitung UMK di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung MSE 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-5481 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mse1.png\" alt=\"Cara Menghitung UMK di Excel\" width=\"397\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung kesalahan kuadrat untuk setiap baris.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ingatlah bahwa kesalahan kuadrat dihitung sebagai berikut: (aktual \u2013 perkiraan) <sup>2<\/sup> . Kami akan menggunakan rumus ini untuk menghitung kesalahan kuadrat untuk setiap baris.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kolom D menunjukkan kesalahan kuadrat dan kolom E menunjukkan rumus yang kita gunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5483 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mse2.png\" alt=\"Kesalahan Berarti Kuadrat di Excel\" width=\"474\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi rumus ini untuk setiap baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5484 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mse3.png\" alt=\"Perhitungan UMK di Excel\" width=\"480\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung kesalahan kuadrat rata-rata.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Hitung MSE hanya dengan mencari rata-rata nilai di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5485 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mse4.png\" alt=\"UMK di Excel\" width=\"521\" height=\"397\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">MSE model ini ternyata <strong>5.917<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Dua metrik populer lainnya yang digunakan untuk mengevaluasi akurasi model adalah <strong>MAD<\/strong> \u2013 rata-rata deviasi absolut dan <strong>MAPE<\/strong> \u2013 rata-rata persentase kesalahan absolut. Tutorial berikut menjelaskan cara menghitung metrik ini di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean Absolute Deviation (MAD) di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kartu-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean Absolute Percentage Error (MAPE) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Salah satu metrik yang paling umum digunakan untuk mengukur keakuratan prediksi suatu model adalah MSE , yang merupakan singkatan dari mean square error . Ini dihitung sebagai berikut: MSE = (1\/n) * \u03a3(aktual \u2013 perkiraan) 2 Emas: \u03a3 \u2013 simbol mewah yang berarti \u201cjumlah\u201d n \u2013 ukuran sampel nyata \u2013 nilai sebenarnya dari data perkiraan [&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 Square Error (MSE) di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung MSE 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\/cara-menghitung-mean-square-mse-error-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 Mean Square Error (MSE) di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung MSE di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T09:32:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mse1.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\/cara-menghitung-mean-square-mse-error-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/\",\"name\":\"Cara Menghitung Mean Square Error (MSE) di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T09:32:51+00:00\",\"dateModified\":\"2023-07-29T09:32:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung MSE di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung mean square error (mse) 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 Square Error (MSE) di Excel - Statorials","description":"Penjelasan sederhana cara menghitung MSE 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\/cara-menghitung-mean-square-mse-error-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Mean Square Error (MSE) di Excel - Statorials","og_description":"Penjelasan sederhana cara menghitung MSE di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T09:32:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mse1.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\/cara-menghitung-mean-square-mse-error-di-excel\/","url":"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/","name":"Cara Menghitung Mean Square Error (MSE) di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T09:32:51+00:00","dateModified":"2023-07-29T09:32:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung MSE di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cara-menghitung-mean-square-mse-error-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung mean square error (mse) 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\/596"}],"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=596"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/596\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}