{"id":1441,"date":"2023-07-26T09:26:27","date_gmt":"2023-07-26T09:26:27","guid":{"rendered":"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/"},"modified":"2023-07-26T09:26:27","modified_gmt":"2023-07-26T09:26:27","slug":"r-persegi-excel-menyesuaikan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/","title":{"rendered":"Cara menghitung r-squared yang disesuaikan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>R-squared<\/strong> , sering ditulis <sup>R2<\/sup> , adalah proporsi varians <a href=\"https:\/\/statorials.org\/id\/variabel-tanggapan-penjelas\/\" target=\"_blank\" rel=\"noopener noreferrer\">variabel respon<\/a> yang dapat dijelaskan oleh variabel prediktor dalam <a href=\"https:\/\/statorials.org\/id\/regresi-linier-berganda\/\" target=\"_blank\" rel=\"noopener noreferrer\">model regresi linier<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai R squared dapat berkisar antara 0 hingga 1. Nilai 0 menunjukkan bahwa variabel respon sama sekali tidak dapat dijelaskan oleh variabel prediktor, sedangkan nilai 1 menunjukkan bahwa variabel respon dapat dijelaskan oleh variabel prediktor. dijelaskan dengan sempurna tanpa kesalahan oleh prediktor. variabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>R-squared yang disesuaikan<\/strong> adalah versi modifikasi dari R-squared yang menyesuaikan jumlah prediktor dalam model regresi. Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Disesuaikan R <sup>2<\/sup> = 1 \u2013 [(1-R <sup>2<\/sup> )*(n-1)\/(nk-1)]<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>R <sup>2<\/sup><\/strong> : R <sup>2<\/sup> model<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> : Jumlah observasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>k<\/strong> : Banyaknya variabel prediktor<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Karena <sup>R2<\/sup> selalu meningkat saat Anda menambahkan prediktor ke model, <sup>R2<\/sup> yang disesuaikan dapat berfungsi sebagai metrik yang memberi tahu Anda seberapa berguna suatu model, <em>disesuaikan berdasarkan jumlah prediktor dalam model<\/em> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara menghitung <sup>R2<\/sup> yang disesuaikan untuk model regresi di R.<\/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 menyesuaikan model ini, 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 R-kuadrat yang telah disesuaikan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">R-kuadrat yang disesuaikan dari model regresi adalah angka di sebelah <strong>R-kuadrat yang disesuaikan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14249 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/adjrexcel1.png\" alt=\"R-kuadrat yang disesuaikan di Excel\" width=\"608\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">R-kuadrat yang disesuaikan untuk model ini ternyata <strong>0,946019<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai ini sangat tinggi, menunjukkan bahwa variabel prediktor <em>Jam Belajar<\/em> dan <em>Nilai Saat Ini<\/em> berfungsi dengan baik dalam memprediksi <em>nilai ujian<\/em> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/nilai-r-kuadrat-yang-bagus\/\" target=\"_blank\" rel=\"noopener\">Berapa nilai R-kuadrat yang bagus?<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/r-kotak-di-r-cocok\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung R-kuadrat yang disesuaikan di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/r-persegi-dengan-python-menyesuaikan\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung R-kuadrat yang disesuaikan dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>R-squared , sering ditulis R2 , adalah proporsi varians variabel respon yang dapat dijelaskan oleh variabel prediktor dalam model regresi linier . Nilai R squared dapat berkisar antara 0 hingga 1. Nilai 0 menunjukkan bahwa variabel respon sama sekali tidak dapat dijelaskan oleh variabel prediktor, sedangkan nilai 1 menunjukkan bahwa variabel respon dapat dijelaskan oleh [&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 R-squared yang disesuaikan di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung R-kuadrat yang disesuaikan di Excel, termasuk 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\/r-persegi-excel-menyesuaikan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung R-squared yang disesuaikan di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung R-kuadrat yang disesuaikan di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T09:26:27+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\/r-persegi-excel-menyesuaikan\/\",\"url\":\"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/\",\"name\":\"Cara menghitung R-squared yang disesuaikan di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T09:26:27+00:00\",\"dateModified\":\"2023-07-26T09:26:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung R-kuadrat yang disesuaikan di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung r-squared yang disesuaikan 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 R-squared yang disesuaikan di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung R-kuadrat yang disesuaikan di Excel, termasuk 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\/r-persegi-excel-menyesuaikan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung R-squared yang disesuaikan di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung R-kuadrat yang disesuaikan di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/","og_site_name":"Statorials","article_published_time":"2023-07-26T09:26:27+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\/r-persegi-excel-menyesuaikan\/","url":"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/","name":"Cara menghitung R-squared yang disesuaikan di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T09:26:27+00:00","dateModified":"2023-07-26T09:26:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung R-kuadrat yang disesuaikan di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung r-squared yang disesuaikan 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\/1441"}],"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=1441"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1441\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}