{"id":3388,"date":"2023-07-17T18:20:26","date_gmt":"2023-07-17T18:20:26","guid":{"rendered":"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/"},"modified":"2023-07-17T18:20:26","modified_gmt":"2023-07-17T18:20:26","slug":"r-kuadratkan-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/","title":{"rendered":"Cara menghitung r-kuadrat di google sheets"},"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\/regresi-linier-lembar-google\/\" 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 <strong>0<\/strong> menunjukkan bahwa variabel respon sama sekali tidak dapat dijelaskan oleh variabel prediktor.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>1<\/strong> menunjukkan bahwa variabel respon dapat dijelaskan dengan sempurna tanpa kesalahan oleh variabel prediktor.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung R kuadrat untuk dua variabel di Google Spreadsheet.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: menghitung R-squared di Google Sheets<\/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=\"528\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menyesuaikan <a href=\"https:\/\/statorials.org\/id\/regresi-linier-1\/\" target=\"_blank\" rel=\"noopener\">model regresi linier sederhana<\/a> , 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 kuadrat model ini, kita dapat menggunakan fungsi Google Sheets <strong>RSQ()<\/strong> , 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;\">Dalam contoh kita, kita bisa mengetikkan rumus berikut di sel D2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RSQ( <span style=\"color: #ff6600;\">A2:A21<\/span> , <span style=\"color: #800080;\">B2:B21<\/span> )<\/strong><\/pre>\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-28423\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-r2.jpg\" alt=\"R kuadrat di Google Spreadsheet\" width=\"484\" height=\"570\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai R-squarednya ternyata berada dikisaran <strong>0.7273<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya <strong>72,73%<\/strong> variasi nilai ujian dapat dijelaskan oleh jumlah jam belajar.<\/span><\/p>\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<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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/deretan-lembar-google-yang-paling-cocok\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan baris yang paling sesuai di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-linier-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi linier di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perkiraan-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Perkiraan di Google Sheets (dengan Contoh)<\/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 Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung R kuadrat di Google Sheets, 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\/r-kuadratkan-lembar-google\/\" \/>\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 Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung R kuadrat di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T18:20:26+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-kuadratkan-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/\",\"name\":\"Cara menghitung R-kuadrat di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T18:20:26+00:00\",\"dateModified\":\"2023-07-17T18:20:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung R kuadrat di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung r-kuadrat di google sheets\"}]},{\"@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 Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung R kuadrat di Google Sheets, 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\/r-kuadratkan-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung R-kuadrat di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung R kuadrat di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-17T18:20:26+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-kuadratkan-lembar-google\/","url":"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/","name":"Cara menghitung R-kuadrat di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T18:20:26+00:00","dateModified":"2023-07-17T18:20:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung R kuadrat di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/r-kuadratkan-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung r-kuadrat di google sheets"}]},{"@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\/3388"}],"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=3388"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3388\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}