{"id":1309,"date":"2023-07-26T22:27:51","date_gmt":"2023-07-26T22:27:51","guid":{"rendered":"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/"},"modified":"2023-07-26T22:27:51","modified_gmt":"2023-07-26T22:27:51","slug":"residu-yang-dinormalisasi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/","title":{"rendered":"Cara menghitung residu standar di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Residual<\/strong> adalah selisih antara nilai observasi dan nilai prediksi dalam <a href=\"https:\/\/statorials.org\/id\/regresi-linier-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">model regresi<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Sisa = Nilai yang diamati \u2013 Nilai yang diprediksi<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita memplot nilai observasi dan menempatkan garis regresi yang dipasang, residu untuk setiap <a href=\"https:\/\/statorials.org\/id\/pengamatan-dalam-statistik\/\" target=\"_blank\" rel=\"noopener\">observasi<\/a> akan menjadi jarak vertikal antara observasi dan garis regresi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12422 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residus1-1.png\" alt=\"Contoh residu dalam statistik\" width=\"487\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Salah satu jenis residu yang sering kita gunakan untuk mengidentifikasi outlier dalam model regresi disebut <strong>residu terstandarisasi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>r <sub>i<\/sub> = e <sub>i<\/sub> \/ s( <sub>ei<\/sub> )<\/strong> = <strong>e <sub>i<\/sub> \/ RSE\u221a <span style=\"border-top: 1px solid black;\">1-h <sub>ii<\/sub><\/span><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>e <sub>i<\/sub> :<\/strong> Residu <sup>ke<\/sup> -i<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>RSE:<\/strong> kesalahan standar sisa model<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>h <sub>ii<\/sub><\/strong> : Meningkatnya observasi <sup>ke-i<\/sup><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dalam praktiknya, kita sering menganggap residu terstandar yang nilai absolutnya lebih besar dari 3 sebagai outlier.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara menghitung residu standar 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, kita akan memasukkan nilai dari kumpulan data kecil ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12803 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sred1.png\" alt=\"\" width=\"407\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung residu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menavigasi ke tab <strong>Data<\/strong> di sepanjang pita atas dan klik <strong>Analisis Data<\/strong> di grup <strong>Analisis<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5292 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deuxsampexcel3.png\" alt=\"\" width=\"486\" height=\"185\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <em><span style=\"color: #000000;\">Jika Anda belum menginstal add-in ini, lihat <a href=\"https:\/\/statorials.org\/id\/cara-memuat-toolpak-analisis-di-excel\/\" target=\"_blank\" rel=\"noopener\">tutorial ini<\/a> untuk mempelajari caranya. Sangat mudah untuk menginstal dan sepenuhnya gratis.<\/span><\/em><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik Analisis Data, klik opsi yang bertuliskan <strong>Regresi<\/strong> , lalu klik <strong>OK<\/strong> . Di jendela baru yang muncul, isi informasi berikut dan klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12804 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sred2-2.png\" alt=\"\" width=\"525\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sisa tiap observasi akan muncul pada hasil:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12806 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sred3.png\" alt=\"Residu di Excel\" width=\"397\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Salin dan tempel sisa ini ke kolom baru di sebelah data asli:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12807 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sred4.png\" alt=\"\" width=\"406\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung Leverage<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menghitung leverage dari setiap observasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara melakukan ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12808 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sred5.png\" alt=\"Memanfaatkan Perhitungan di Excel untuk Statistik\" width=\"443\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah rumus yang digunakan di sel yang berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>B14:<\/strong> =JUMLAH(B2:B13)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>B15:<\/strong> = RATA-RATA (B2: B13)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>B16:<\/strong> =DEVSQ(B2:B13)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>E2:<\/strong> =1\/$B$14+(B2-$B$15)^2\/$B$16<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung residu standar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat menghitung residu terstandar menggunakan rumus:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>r <sub>i<\/sub> =<\/strong> <strong>e <sub>i<\/sub> \/ RSE\u221a <span style=\"border-top: 1px solid black;\">1-jam <sub>ii<\/sub><\/span><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>CSR<\/strong> model dapat dilihat pada hasil model sebelumnya. Ternyata menjadi <strong>4,44<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12809 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sred6.png\" alt=\"\" width=\"440\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Oleh karena itu, kita dapat menggunakan rumus berikut untuk menghitung sisa terstandar untuk setiap observasi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12810 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sred7.png\" alt=\"Residual terstandarisasi di Excel\" width=\"522\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasil tersebut, kita dapat melihat bahwa tidak ada satu pun residu terstandar yang melebihi nilai absolut 3. Dengan demikian, tidak ada satu pun observasi yang tampak outlier.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perlu dicatat bahwa dalam beberapa kasus, peneliti menganggap observasi yang residu terstandarnya melebihi nilai absolut 2 sebagai outlier.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terserah Anda apakah akan menggunakan nilai absolut 2 atau 3 sebagai ambang batas untuk outlier, bergantung pada masalah spesifik yang sedang Anda tangani.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/residu\/\" target=\"_blank\" rel=\"noopener\">Apa itu residu?<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/residu-terstandar\/\">Apa yang dimaksud dengan residu terstandar?<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-linier-berganda\/\" target=\"_blank\" rel=\"noopener\">Pengantar Regresi Linier Berganda<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Residual adalah selisih antara nilai observasi dan nilai prediksi dalam model regresi . Ini dihitung sebagai berikut: Sisa = Nilai yang diamati \u2013 Nilai yang diprediksi Jika kita memplot nilai observasi dan menempatkan garis regresi yang dipasang, residu untuk setiap observasi akan menjadi jarak vertikal antara observasi dan garis regresi: Salah satu jenis residu yang [&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 residu standar di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung residu terstandar di Excel, 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\/residu-yang-dinormalisasi-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung residu standar di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung residu terstandar di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T22:27:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residus1-1.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\/residu-yang-dinormalisasi-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/\",\"name\":\"Cara menghitung residu standar di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T22:27:51+00:00\",\"dateModified\":\"2023-07-26T22:27:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung residu terstandar di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung residu standar 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 residu standar di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung residu terstandar di Excel, 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\/residu-yang-dinormalisasi-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung residu standar di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung residu terstandar di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T22:27:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residus1-1.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\/residu-yang-dinormalisasi-excel\/","url":"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/","name":"Cara menghitung residu standar di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T22:27:51+00:00","dateModified":"2023-07-26T22:27:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung residu terstandar di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/residu-yang-dinormalisasi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung residu standar 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\/1309"}],"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=1309"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1309\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}