{"id":5122,"date":"2023-07-03T05:31:17","date_gmt":"2023-07-03T05:31:17","guid":{"rendered":"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/"},"modified":"2023-07-03T05:31:17","modified_gmt":"2023-07-03T05:31:17","slug":"cara-menjumlahkan-nilai-r2-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/","title":{"rendered":"Cara menambahkan nilai r-kuadrat ke bagan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam analisis regresi, nilai <strong>R-squared<\/strong> (R <sup>2<\/sup> ) merupakan proporsi varians <a href=\"https:\/\/statorials.org\/id\/variabel-tanggapan-penjelas\/\" target=\"_blank\" rel=\"noopener\">variabel respon<\/a> yang dapat dijelaskan oleh variabel prediktor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menampilkan nilai R-kuadrat ini pada bagan di Excel, mirip dengan bagan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39914\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart1.png\" alt=\"Excel menambahkan nilai R kuadrat ke bagan\" width=\"578\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/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\">Apa yang dianggap sebagai nilai R-kuadrat yang baik?<\/a><\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai berikut untuk variabel prediktor (x) dan variabel respons (y) ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39915 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart2.png\" alt=\"\" width=\"443\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat diagram sebar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A2:B15<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Sisipkan Sebar<\/strong> di grup <strong>Grafik<\/strong> dan pilih opsi pertama untuk menyisipkan plot sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"566\" height=\"233\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39916 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart3.png\" alt=\"\" width=\"537\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan nilai R-kuadrat ke plot sebar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik di mana saja pada diagram sebar. Lalu klik tanda plus ( <strong>+<\/strong> ) di pojok kanan atas plot, lalu klik panah drop-down di samping <strong>Garis Tren<\/strong> , lalu klik <strong>Opsi Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39917 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart4.png\" alt=\"\" width=\"505\" height=\"390\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Trendline<\/strong> yang muncul, centang kotak di bagian paling bawah di samping <strong>Show Equation on Chart<\/strong> dan <strong>Show R Squared Value on Chart<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39918 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart5.png\" alt=\"\" width=\"308\" height=\"633\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Persamaan regresi dan nilai R-kuadrat sekarang akan ditampilkan di diagram sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39919 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart6.png\" alt=\"\" width=\"532\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai R-kuadrat untuk persamaan regresi ini adalah <strong>0,9302<\/strong> , yang berarti <strong>93,02%<\/strong> variasi variabel respon dapat dijelaskan oleh variabel prediktor.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 4: Sesuaikan bagan (opsional)<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Terakhir, jika Anda ingin membuat persamaan regresi linier dan nilai R-kuadrat lebih mudah dibaca, Anda dapat membuat font menjadi tebal dan menghapus garis kisi dari plot.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Plot terakhir akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39914\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart1.png\" alt=\"Excel menambahkan nilai R kuadrat ke bagan\" width=\"578\" height=\"360\" srcset=\"\" sizes=\"\"><\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/r-kuadrat-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung R-kuadrat di Excel<\/a><br \/> <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\/excel-regresi-linier-sederhana\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi linier sederhana di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-regresi-linier-berganda\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Linier Berganda di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam analisis regresi, nilai R-squared (R 2 ) merupakan proporsi varians variabel respon yang dapat dijelaskan oleh variabel prediktor. Seringkali, Anda mungkin ingin menampilkan nilai R-kuadrat ini pada bagan di Excel, mirip dengan bagan di bawah ini: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Terkait: Apa yang dianggap sebagai nilai R-kuadrat 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 Menambahkan Nilai R Kuadrat pada Bagan di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai R kuadrat ke bagan 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\/cara-menjumlahkan-nilai-r2-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambahkan Nilai R Kuadrat pada Bagan di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai R kuadrat ke bagan di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T05:31:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart1.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\/cara-menjumlahkan-nilai-r2-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/\",\"name\":\"Cara Menambahkan Nilai R Kuadrat pada Bagan di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T05:31:17+00:00\",\"dateModified\":\"2023-07-03T05:31:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan nilai R kuadrat ke bagan di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambahkan nilai r-kuadrat ke bagan 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 Menambahkan Nilai R Kuadrat pada Bagan di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menambahkan nilai R kuadrat ke bagan 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\/cara-menjumlahkan-nilai-r2-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambahkan Nilai R Kuadrat pada Bagan di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan nilai R kuadrat ke bagan di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-03T05:31:17+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2chart1.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\/cara-menjumlahkan-nilai-r2-di-excel\/","url":"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/","name":"Cara Menambahkan Nilai R Kuadrat pada Bagan di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T05:31:17+00:00","dateModified":"2023-07-03T05:31:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan nilai R kuadrat ke bagan di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cara-menjumlahkan-nilai-r2-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambahkan nilai r-kuadrat ke bagan 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\/5122"}],"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=5122"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5122\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}