{"id":1060,"date":"2023-07-27T19:50:04","date_gmt":"2023-07-27T19:50:04","guid":{"rendered":"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/"},"modified":"2023-07-27T19:50:04","modified_gmt":"2023-07-27T19:50:04","slug":"deviasi-rata-rata-absolut-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/","title":{"rendered":"Cara menghitung rata-rata deviasi absolut di google spreadsheet"},"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. 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> <strong><span style=\"color: #000000;\">Deviasi absolut rata-rata = (\u03a3 |x <sub>i<\/sub> \u2013 <span style=\"text-decoration: overline;\">x<\/span> |) \/ n<\/span><\/strong><\/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<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung rata-rata deviasi absolut suatu kumpulan data di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Rata-rata Deviasi Absolut di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk menghitung rata-rata deviasi absolut di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan semua nilai dari kumpulan data ke dalam satu kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10921 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/madsheets1.png\" alt=\"\" width=\"377\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan nilai rata-rata kumpulan data<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, gunakan fungsi <strong>AVERAGE()<\/strong> untuk mencari rata-rata kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10922 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/madsheets2.png\" alt=\"\" width=\"400\" height=\"458\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung deviasi absolut.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, gunakan fungsi <strong>ABS()<\/strong> untuk mencari deviasi absolut setiap observasi dari mean kumpulan data:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em>Rumus di kolom C menunjukkan cara menghitung nilai di kolom B.<\/em><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10924\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/madsheets3-1.png\" alt=\"Penyimpangan absolut di Google Spreadsheet\" width=\"456\" height=\"495\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung rata-rata deviasi absolut<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, hitung deviasi absolut rata-rata dari kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10925 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/madsheets4.png\" alt=\"Deviasi absolut rata-rata di Google Spreadsheet\" width=\"452\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata deviasi absolutnya adalah <strong>6,1867<\/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;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-mean-absolute-deviasi-di-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Mean Absolute Deviation di Excel<\/a><\/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 Menghitung Rata-rata Deviasi Absolut di Google Spreadsheet<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung rata-rata deviasi absolut suatu dataset di Google Sheets, 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\/deviasi-rata-rata-absolut-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rata-rata Deviasi Absolut di Google Spreadsheet\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung rata-rata deviasi absolut suatu dataset di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T19:50:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/madsheets1.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\/deviasi-rata-rata-absolut-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/\",\"name\":\"Cara Menghitung Rata-rata Deviasi Absolut di Google Spreadsheet\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T19:50:04+00:00\",\"dateModified\":\"2023-07-27T19:50:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung rata-rata deviasi absolut suatu dataset di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata deviasi absolut di google spreadsheet\"}]},{\"@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 Rata-rata Deviasi Absolut di Google Spreadsheet","description":"Penjelasan sederhana cara menghitung rata-rata deviasi absolut suatu dataset di Google Sheets, 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\/deviasi-rata-rata-absolut-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-rata Deviasi Absolut di Google Spreadsheet","og_description":"Penjelasan sederhana cara menghitung rata-rata deviasi absolut suatu dataset di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T19:50:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/madsheets1.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\/deviasi-rata-rata-absolut-google-sheet\/","url":"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/","name":"Cara Menghitung Rata-rata Deviasi Absolut di Google Spreadsheet","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T19:50:04+00:00","dateModified":"2023-07-27T19:50:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung rata-rata deviasi absolut suatu dataset di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/deviasi-rata-rata-absolut-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata deviasi absolut di google spreadsheet"}]},{"@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\/1060"}],"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=1060"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1060\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}