{"id":906,"date":"2023-07-28T08:56:24","date_gmt":"2023-07-28T08:56:24","guid":{"rendered":"https:\/\/statorials.org\/id\/r-kuadrat-excel\/"},"modified":"2023-07-28T08:56:24","modified_gmt":"2023-07-28T08:56:24","slug":"r-kuadrat-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/r-kuadrat-excel\/","title":{"rendered":"Cara menghitung r-squared di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>R-squared<\/strong> , sering ditulis <sup>r2<\/sup> , adalah ukuran seberapa cocok <a href=\"https:\/\/statorials.org\/id\/excel-regresi-linier-sederhana\/\" target=\"_blank\" rel=\"noopener\">model regresi linier<\/a> dengan sekumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara teknis, proporsi varians pada variabel respon yang dapat dijelaskan oleh variabel prediktor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai r <sup>2<\/sup> dapat berkisar dari 0 hingga 1:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai 0 menunjukkan bahwa variabel respon sama sekali tidak dapat dijelaskan oleh variabel prediktor.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai 1 menunjukkan bahwa variabel respon dapat dijelaskan dengan sempurna tanpa kesalahan oleh variabel prediktor.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/nilai-r-kuadrat-yang-bagus\/\" target=\"_blank\" rel=\"noopener\">Berapa nilai R-kuadrat yang bagus?<\/a><\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung r <sup>2<\/sup> untuk dua variabel di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghitung R Kuadrat di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai data jumlah jam belajar dan nilai ujian yang diperoleh 20 siswa sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9664 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsquared_excel1.png\" alt=\"\" width=\"473\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin memasukkan model regresi linier sederhana ke data ini, menggunakan &#8220;jam&#8221; sebagai variabel prediktor dan &#8220;skor&#8221; sebagai variabel respons.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari r <sup>2<\/sup> data ini, kita dapat menggunakan fungsi RSQ() di Excel, yang menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>=RSQ(diketahui_ys, diketahui_xs)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>unknown_ys:<\/strong> nilai variabel respon<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>unknown_xs:<\/strong> nilai variabel prediktor<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Seperti inilah rumus dalam contoh kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9665 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsquared_excel2.png\" alt=\"Menghitung R Square di Excel\" width=\"518\" height=\"491\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, <strong>72,73%<\/strong> variasi nilai ujian dijelaskan oleh jumlah jam belajar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika kita memasukkan <a href=\"https:\/\/statorials.org\/id\/excel-regresi-linier-sederhana\/\" target=\"_blank\" rel=\"noopener\">model regresi linier sederhana<\/a> ke data ini, hasilnya akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6288 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/simpleregressionexcel5.png\" alt=\"\" width=\"627\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai R Square pada tabel pertama adalah <strong>0,7273<\/strong> , yang merupakan hasil yang diperoleh dengan menggunakan fungsi <strong>RSQ()<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/r-persegi-excel-menyesuaikan\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung R-squared yang disesuaikan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung SST, SSR dan SSE di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/cara-membuat-sisa-jejak-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Sisa di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>R-squared , sering ditulis r2 , adalah ukuran seberapa cocok model regresi linier dengan sekumpulan data. Secara teknis, proporsi varians pada variabel respon yang dapat dijelaskan oleh variabel prediktor. Nilai r 2 dapat berkisar dari 0 hingga 1: Nilai 0 menunjukkan bahwa variabel respon sama sekali tidak dapat dijelaskan oleh variabel prediktor. Nilai 1 menunjukkan [&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-kuadrat di Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung R kuadrat di excel 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\/r-kuadrat-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung R-kuadrat di Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung R kuadrat di excel beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/r-kuadrat-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T08:56:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsquared_excel1.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\/r-kuadrat-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/r-kuadrat-excel\/\",\"name\":\"Cara Menghitung R-kuadrat di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T08:56:24+00:00\",\"dateModified\":\"2023-07-28T08:56:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung R kuadrat di excel beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/r-kuadrat-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/r-kuadrat-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/r-kuadrat-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung r-squared di excel (dengan contoh)\"}]},{\"@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-kuadrat di Excel (dengan Contoh) - Statorials","description":"Penjelasan sederhana cara menghitung R kuadrat di excel 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\/r-kuadrat-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung R-kuadrat di Excel (dengan Contoh) - Statorials","og_description":"Penjelasan sederhana cara menghitung R kuadrat di excel beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/r-kuadrat-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T08:56:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsquared_excel1.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\/r-kuadrat-excel\/","url":"https:\/\/statorials.org\/id\/r-kuadrat-excel\/","name":"Cara Menghitung R-kuadrat di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T08:56:24+00:00","dateModified":"2023-07-28T08:56:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung R kuadrat di excel beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/r-kuadrat-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/r-kuadrat-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/r-kuadrat-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung r-squared di excel (dengan contoh)"}]},{"@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\/906"}],"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=906"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/906\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}