{"id":540,"date":"2023-07-29T14:03:46","date_gmt":"2023-07-29T14:03:46","guid":{"rendered":"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/"},"modified":"2023-07-29T14:03:46","modified_gmt":"2023-07-29T14:03:46","slug":"cara-mudah-menghitung-mean-absolute-deviasi-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/","title":{"rendered":"Cara mudah menghitung mean absolut deviasi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Deviasi absolut rata-rata<\/strong> adalah cara untuk mengukur sebaran sekumpulan nilai data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata deviasi absolut yang rendah menunjukkan bahwa nilai data terkonsentrasi dengan ketat.<\/span> <span style=\"color: #000000;\">Nilai mean deviasi absolut yang lebih tinggi menunjukkan bahwa nilai data lebih tersebar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung rata-rata simpangan mutlak adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Deviasi absolut rata-rata<\/strong> = (\u03a3 |x <sub>i<\/sub> \u2013 <span style=\"text-decoration: overline;\">x<\/span> |) \/ n<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3<\/strong> \u2013 hanya simbol mewah yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub><\/strong> \u2013 nilai data <sup>ke<\/sup> i<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"text-decoration: overline;\">x<\/span><\/strong> \u2013 nilai rata-rata<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> \u2013 ukuran sampel<\/span><\/li>\n<\/ul>\n<h2> <span style=\"color: #000000;\"><strong>Cara Menghitung Mean Absolut Deviasi di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung <strong>Mean Absolute Deviation<\/strong> di Excel, kita dapat melakukan langkah-langkah berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong> . Untuk contoh ini, kita akan memasukkan 15 nilai data ke dalam sel A2:A16.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan nilai rata-ratanya<\/strong> . Di sel D1, ketik rumus berikut: <strong>=AVERAGE(A2:A16)<\/strong> . Ini menghitung nilai rata-rata dari nilai data, yang ternyata adalah <strong>15.8<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung deviasi absolut.<\/strong> Di sel B2, ketik rumus berikut: <strong>=ABS(A2-$D$1)<\/strong> . Ini menghitung deviasi absolut nilai di sel A2 dari nilai rata-rata di kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik sel B2. Selanjutnya, arahkan kursor ke pojok kanan bawah sel hingga muncul tanda <strong>+<\/strong> hitam. Klik dua kali tanda <strong>+<\/strong> untuk mengisi sisa nilai pada kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung rata-rata deviasi absolut<\/strong> . Di sel B17, ketikkan rumus berikut: <strong>=AVERAGE(B2:B16)<\/strong> . Ini menghitung deviasi absolut rata-rata untuk nilai data, yang ternyata adalah <strong>6,1866<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda dapat menggunakan empat langkah ini untuk menghitung deviasi absolut rata-rata untuk sejumlah nilai data. Dalam contoh ini, kami menggunakan 15 nilai data, namun Anda dapat menggunakan langkah-langkah tepat ini untuk menghitung deviasi absolut rata-rata untuk 5 nilai data atau 5.000 nilai data.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em>Cara umum lainnya untuk mengukur keakuratan prediksi model adalah MAPE \u2013 rata-rata persentase kesalahan absolut. Pelajari cara menghitung MAPE di Excel <a href=\"https:\/\/statorials.org\/id\/kartu-excel\/\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Deviasi absolut rata-rata adalah cara untuk mengukur sebaran sekumpulan nilai data. Nilai rata-rata deviasi absolut yang rendah menunjukkan bahwa nilai data terkonsentrasi dengan ketat. Nilai mean deviasi absolut yang lebih tinggi menunjukkan bahwa nilai data lebih tersebar. Rumus untuk menghitung rata-rata simpangan mutlak adalah: Deviasi absolut rata-rata = (\u03a3 |x i \u2013 x |) \/ [&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 Mudah Menghitung Mean Absolute Deviation di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata deviasi absolut untuk sekumpulan nilai data 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\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mudah Menghitung Mean Absolute Deviation di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata deviasi absolut untuk sekumpulan nilai data di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T14:03:46+00:00\" \/>\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-mudah-menghitung-mean-absolute-deviasi-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/\",\"name\":\"Cara Mudah Menghitung Mean Absolute Deviation di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T14:03:46+00:00\",\"dateModified\":\"2023-07-29T14:03:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata deviasi absolut untuk sekumpulan nilai data di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mudah menghitung mean absolut deviasi 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 Mudah Menghitung Mean Absolute Deviation di Excel - Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata deviasi absolut untuk sekumpulan nilai data 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\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mudah Menghitung Mean Absolute Deviation di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata deviasi absolut untuk sekumpulan nilai data di Excel.","og_url":"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T14:03:46+00:00","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-mudah-menghitung-mean-absolute-deviasi-di-excel\/","url":"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/","name":"Cara Mudah Menghitung Mean Absolute Deviation di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T14:03:46+00:00","dateModified":"2023-07-29T14:03:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata deviasi absolut untuk sekumpulan nilai data di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mudah menghitung mean absolut deviasi 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\/540"}],"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=540"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/540\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}