{"id":1440,"date":"2023-07-26T09:34:24","date_gmt":"2023-07-26T09:34:24","guid":{"rendered":"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/"},"modified":"2023-07-26T09:34:24","modified_gmt":"2023-07-26T09:34:24","slug":"kesalahan-standar-regresi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/","title":{"rendered":"Cara menghitung standard error regresi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Kami menyesuaikan <a href=\"https:\/\/statorials.org\/id\/regresi-linier-1\/\" target=\"_blank\" rel=\"noopener\">model regresi linier<\/a> , modelnya mengambil bentuk berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Y = \u03b2 <sub>0<\/sub> + \u03b2 <sub>1<\/sub> X + \u2026 + \u03b2 <sub>saya<\/sub><\/span><\/p>\n<p> <span style=\"color: #000000;\">dimana \u03f5 adalah suku kesalahan yang tidak bergantung pada X.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tidak peduli bagaimana X dapat digunakan untuk memprediksi nilai Y, akan selalu ada kesalahan acak dalam model.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Salah satu cara untuk mengukur sebaran kesalahan acak ini adalah dengan menggunakan <strong>kesalahan standar model regresi<\/strong> , yaitu cara mengukur simpangan baku <a href=\"https:\/\/statorials.org\/id\/residu\/\" target=\"_blank\" rel=\"noopener\">dari residu<\/a> \u03f5.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara menghitung kesalahan standar model regresi di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, kita akan membuat kumpulan data yang berisi variabel berikut untuk 12 siswa berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Hasil ujian<\/span><\/li>\n<li> <span style=\"color: #000000;\">Berjam-jam dihabiskan untuk belajar<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kelas saat ini<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14241 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standregexcel1.png\" alt=\"\" width=\"504\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Sesuaikan model regresi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menyesuaikan model <a href=\"https:\/\/statorials.org\/id\/regresi-linier-berganda\/\" target=\"_blank\" rel=\"noopener\">regresi linier berganda<\/a> dengan menggunakan <em>nilai ujian<\/em> sebagai <a href=\"https:\/\/statorials.org\/id\/variabel-tanggapan-penjelas\/\" target=\"_blank\" rel=\"noopener\">variabel respon<\/a> dan <em>jam belajar<\/em> serta <em>nilai saat ini<\/em> sebagai variabel prediktor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik <strong>Analisis Data<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5292 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deuxsampexcel3.png\" alt=\"\" width=\"472\" height=\"180\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika opsi ini tidak tersedia, Anda harus <a href=\"https:\/\/statorials.org\/id\/cara-memuat-toolpak-analisis-di-excel\/\" target=\"_blank\" rel=\"noopener\">memuat Data Analysis ToolPak<\/a> terlebih dahulu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul, pilih <strong>Regresi<\/strong> . Di jendela baru yang muncul, berikan informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14242 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standregexcel2.png\" alt=\"\" width=\"605\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , keluaran model regresi akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14243 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standregexcel3.png\" alt=\"\" width=\"598\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tafsirkan kesalahan standar regresi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kesalahan standar model regresi adalah angka di sebelah <strong>kesalahan standar<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14244 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standregexcel4.png\" alt=\"Kesalahan standar regresi di Excel\" width=\"604\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kesalahan standar model regresi khusus ini adalah <strong>2.790029<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Angka ini mewakili jarak rata-rata antara hasil ujian sebenarnya dengan hasil ujian yang diprediksi oleh model.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa beberapa hasil ujian akan berjarak lebih dari 2,79 unit dari skor yang diprediksi, sementara hasil ujian lainnya akan lebih dekat. Namun rata-rata jarak antara hasil ujian sebenarnya dan hasil prediksi adalah <strong>2.790029<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa kesalahan standar regresi yang lebih kecil menunjukkan bahwa model regresi lebih cocok dengan kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, jika kita menyesuaikan model regresi baru ke kumpulan data dan memperoleh kesalahan standar, katakanlah, <strong>4,53<\/strong> , model baru ini akan kurang efektif dalam memprediksi nilai ujian dibandingkan model sebelumnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Cara umum lainnya untuk mengukur keakuratan model regresi adalah dengan menggunakan R-squared. Lihat <a href=\"https:\/\/statorials.org\/id\/regresi-kesalahan-standar\/\" target=\"_blank\" rel=\"noopener\">artikel ini<\/a> untuk penjelasan bagus tentang manfaat menggunakan kesalahan standar regresi untuk mengukur akurasi versus R-kuadrat.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kami menyesuaikan model regresi linier , modelnya mengambil bentuk berikut: Y = \u03b2 0 + \u03b2 1 X + \u2026 + \u03b2 saya dimana \u03f5 adalah suku kesalahan yang tidak bergantung pada X. Tidak peduli bagaimana X dapat digunakan untuk memprediksi nilai Y, akan selalu ada kesalahan acak dalam model. Salah satu cara untuk mengukur [&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 Standard Error Regresi di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung kesalahan standar model regresi di Excel, dengan sebuah contoh.\" \/>\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\/kesalahan-standar-regresi-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Standard Error Regresi di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung kesalahan standar model regresi di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T09:34:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standregexcel1.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\/kesalahan-standar-regresi-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/\",\"name\":\"Cara Menghitung Standard Error Regresi di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T09:34:24+00:00\",\"dateModified\":\"2023-07-26T09:34:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung kesalahan standar model regresi di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung standard error regresi 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 Standard Error Regresi di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung kesalahan standar model regresi di Excel, dengan sebuah contoh.","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\/kesalahan-standar-regresi-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Standard Error Regresi di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung kesalahan standar model regresi di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T09:34:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standregexcel1.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\/kesalahan-standar-regresi-excel\/","url":"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/","name":"Cara Menghitung Standard Error Regresi di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T09:34:24+00:00","dateModified":"2023-07-26T09:34:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung kesalahan standar model regresi di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kesalahan-standar-regresi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung standard error regresi 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\/1440"}],"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=1440"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1440\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}