{"id":2077,"date":"2023-07-23T19:45:27","date_gmt":"2023-07-23T19:45:27","guid":{"rendered":"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/"},"modified":"2023-07-23T19:45:27","modified_gmt":"2023-07-23T19:45:27","slug":"outlier-di-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/","title":{"rendered":"Cara mudah menemukan pencilan di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Outlier<\/strong> adalah observasi yang jaraknya sangat jauh dari nilai lain dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita sering mendefinisikan suatu observasi sebagai outlier jika observasi tersebut 1,5 kali rentang antarkuartil di atas kuartil ketiga atau 1,5 kali rentang antarkuartil di bawah kuartil pertama.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan:<\/strong> Rentang interkuartil adalah selisih antara kuartil ketiga (persentil ke-75) dan kuartil pertama (persentil ke-25) suatu kumpulan data. Ini mengukur distribusi rata-rata 50% nilai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan rumus ini untuk menemukan outlier dalam kumpulan data di Google Spreadsheet.<\/span><\/p>\n<h3> <strong>Langkah 1: Masukkan datanya<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai dari kumpulan data berikut ke Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19343 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-aberrantes1.png\" alt=\"\" width=\"566\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung rentang interkuartil<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari kita hitung rentang kuartil pertama, kuartil ketiga, dan interkuartil dari kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19344 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-aberrantes2.png\" alt=\"\" width=\"583\" height=\"506\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Identifikasi Pencilan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk memberikan nilai &#8220;1&#8221; pada outlier mana pun dalam kumpulan data:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">IF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">A2<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">&lt;<\/span> <span dir=\"auto\" style=\"color: #993366;\">$B$18<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">-<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">$B$20<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">*<\/span> <span class=\"number\" dir=\"auto\">1.5<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\">1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">IF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">A2<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">&gt;<\/span> <span dir=\"auto\" style=\"color: #ff0000;\">$B$19<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">+<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">$B$20<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">*<\/span> <span class=\"number\" dir=\"auto\">1.5<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\">1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\">0<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini memeriksa apakah suatu pengamatan 1,5 kali rentang antarkuartil di atas kuartil ketiga atau 1,5 kali rentang antarkuartil di bawah kuartil pertama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika salah satu benar, observasi tersebut diberi nilai \u201c1\u201d untuk menetapkannya sebagai outlier.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-19345 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-aberrantes3.png\" alt=\"Temukan pencilan di Google Spreadsheet\" width=\"591\" height=\"516\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami melihat bahwa hanya satu nilai dalam kumpulan data kami yang merupakan outlier: <strong>164<\/strong> .<\/span><\/p>\n<h3> <strong>Cara menangani outlier<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Jika ada outlier dalam data Anda, Anda memiliki beberapa opsi:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Pastikan outlier tersebut bukan akibat kesalahan entri data.<\/strong><\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\">Terkadang data sederhana tidak disimpan dengan benar. Jika terdapat outlier, verifikasi terlebih dahulu bahwa nilai yang dimasukkan benar dan bukan kesalahan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> <strong>Tetapkan nilai baru pada outlier<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika outlier adalah akibat dari kesalahan entri data, Anda dapat memutuskan untuk memberinya nilai baru seperti mean atau median dari kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>3. Hapus outlier.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilainya benar-benar outlier, Anda dapat memilih untuk menghapusnya jika nilai tersebut akan berdampak signifikan pada analisis Anda secara keseluruhan. Pastikan untuk menyebutkan dalam laporan akhir Anda bahwa Anda menghapus outlier.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menghilangkan outlier pada software statistik lainnya:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menghapus-outlier-r\/\" target=\"_blank\" rel=\"noopener\">Cara menghilangkan outlier di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/menghapus-pencilan-python\/\" target=\"_blank\" rel=\"noopener\">Cara Menghapus Pencilan dengan Python<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/spss-outlier\/\" target=\"_blank\" rel=\"noopener\">Cara menghilangkan outlier di SPSS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Outlier adalah observasi yang jaraknya sangat jauh dari nilai lain dalam kumpulan data. Kita sering mendefinisikan suatu observasi sebagai outlier jika observasi tersebut 1,5 kali rentang antarkuartil di atas kuartil ketiga atau 1,5 kali rentang antarkuartil di bawah kuartil pertama. Catatan: Rentang interkuartil adalah selisih antara kuartil ketiga (persentil ke-75) dan kuartil pertama (persentil ke-25) [&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 Menemukan Pencilan di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengidentifikasi outlier di Google Spreadsheet, dengan 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\/outlier-di-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mudah Menemukan Pencilan di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengidentifikasi outlier di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T19:45:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-aberrantes1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/\",\"name\":\"Cara Mudah Menemukan Pencilan di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T19:45:27+00:00\",\"dateModified\":\"2023-07-23T19:45:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengidentifikasi outlier di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mudah menemukan pencilan 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 Mudah Menemukan Pencilan di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengidentifikasi outlier di Google Spreadsheet, dengan 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\/outlier-di-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mudah Menemukan Pencilan di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengidentifikasi outlier di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-23T19:45:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-aberrantes1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/","url":"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/","name":"Cara Mudah Menemukan Pencilan di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T19:45:27+00:00","dateModified":"2023-07-23T19:45:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengidentifikasi outlier di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/outlier-di-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mudah menemukan pencilan 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\/2077"}],"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=2077"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2077\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}