{"id":1447,"date":"2023-07-26T08:45:28","date_gmt":"2023-07-26T08:45:28","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/"},"modified":"2023-07-26T08:45:28","modified_gmt":"2023-07-26T08:45:28","slug":"lembar-google-regresi-polinomial","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/","title":{"rendered":"Regresi polinomial di google spreadsheet (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Analisis regresi digunakan untuk mengukur hubungan antara satu atau lebih variabel prediktor dan <a href=\"https:\/\/statorials.org\/id\/variabel-tanggapan-penjelas\/\" target=\"_blank\" rel=\"noopener noreferrer\">variabel respon<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jenis analisis regresi yang paling umum adalah <a href=\"https:\/\/statorials.org\/id\/regresi-linier-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">regresi linier sederhana<\/a> , digunakan ketika variabel prediktor dan variabel respons mempunyai hubungan linier.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8174 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel1.png\" alt=\"Hubungan linier antara dua variabel\" width=\"475\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Namun terkadang hubungan antara variabel prediktor dan variabel respon bersifat nonlinier.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8175 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel2.png\" alt=\"Contoh hubungan kuadrat\" width=\"472\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8176 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel3.png\" alt=\"Contoh hubungan kubik\" width=\"473\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam kasus ini, masuk akal untuk menggunakan <strong>regresi polinomial<\/strong> , yang dapat menjelaskan hubungan nonlinier antar variabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan regresi polinomial di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data palsu dengan nilai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14306 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles1.png\" alt=\"\" width=\"452\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat diagram sebar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat scatterplot untuk memvisualisasikan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, sorot sel <strong>A2:B11<\/strong> sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14307 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles2.png\" alt=\"\" width=\"399\" height=\"365\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Bagan<\/strong> dari menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14308 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles3.png\" alt=\"\" width=\"431\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Google Spreadsheet akan menyisipkan diagram sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14309 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles4.png\" alt=\"\" width=\"459\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan Persamaan Regresi Polinomial<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, klik dua kali di mana saja pada diagram sebar untuk menampilkan jendela <strong>editor grafik<\/strong> di sebelah kanan:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14310 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles5.png\" alt=\"\" width=\"280\" height=\"488\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, <strong>klikSeri<\/strong> . Selanjutnya, gulir ke bawah dan centang kotak di sebelah <strong>Trendline<\/strong> dan ubah Type menjadi <strong>Polynomial<\/strong> . Untuk Label, pilih <strong>Use Equation<\/strong> , lalu centang kotak di samping <strong>Show <sup>R2<\/sup><\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14311 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles6.png\" alt=\"\" width=\"262\" height=\"518\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menyebabkan rumus berikut muncul di atas diagram sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14313 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles7.png\" alt=\"Regresi polinomial di Google Spreadsheet\" width=\"553\" height=\"339\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa persamaan regresi polinomial yang dipasang adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 9,45 + 2,1x \u2013 0,0188x <sup>2<\/sup><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">R-kuadrat untuk model ini adalah <strong>0,718<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em>Ingatlah bahwa <a href=\"https:\/\/statorials.org\/id\/nilai-r-kuadrat-yang-bagus\/\" target=\"_blank\" rel=\"noopener\">R kuadrat<\/a> menunjukkan persentase variasi dalam variabel respons yang dapat dijelaskan oleh variabel prediktor. Semakin tinggi nilainya, semakin baik modelnya.<\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, ubah derajat polinomial menjadi 3 di editor grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14314 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles8.png\" alt=\"Ubah derajat polinomial di Google Spreadsheet\" width=\"269\" height=\"539\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menyebabkan rumus berikut muncul di atas diagram sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14315 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyregfeuilles9.png\" alt=\"Regresi Kubik di Google Spreadsheet\" width=\"555\" height=\"333\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini mengubah persamaan regresi polinomial yang dipasang menjadi:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 37,2 \u2013 14,2x + 2,64x <sup>2<\/sup> \u2013 0,126x <sup>3<\/sup><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">R-kuadrat untuk model ini adalah <strong>0,976<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa R-kuadrat model ini jauh lebih tinggi dibandingkan model regresi polinomial dengan derajat 2. Hal ini menunjukkan bahwa model regresi ini jauh lebih baik dalam menangkap tren data yang mendasarinya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda mengubah derajat polinomial menjadi 4, R kuadratnya hampir tidak bertambah menjadi <strong>0,981<\/strong> . Hal ini menunjukkan bahwa model regresi polinomial derajat 3 sudah cukup untuk menangkap tren pada data tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan persamaan regresi yang dipasang untuk menemukan nilai yang diharapkan dari variabel respon dengan nilai tertentu dari variabel prediktor. Misalnya, jika <em>x<\/em> = 4 maka nilai <em>y<\/em> yang diharapkan adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = 37,2 \u2013 14,2(4) + 2,64(4) <sup>2<\/sup> \u2013 0,126(4) <sup>3<\/sup> = <strong>14,576<\/strong><\/span><\/p>\n<hr>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan tutorial Google Sheets lainnya di halaman ini .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Analisis regresi digunakan untuk mengukur hubungan antara satu atau lebih variabel prediktor dan variabel respon . Jenis analisis regresi yang paling umum adalah regresi linier sederhana , digunakan ketika variabel prediktor dan variabel respons mempunyai hubungan linier. Namun terkadang hubungan antara variabel prediktor dan variabel respon bersifat nonlinier. Dalam kasus ini, masuk akal untuk menggunakan [&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>Regresi Polinomial di Google Spreadsheet (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan regresi polinomial di Google Spreadsheet, 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\/lembar-google-regresi-polinomial\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Regresi Polinomial di Google Spreadsheet (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan regresi polinomial di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T08:45:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel1.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\/lembar-google-regresi-polinomial\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/\",\"name\":\"Regresi Polinomial di Google Spreadsheet (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T08:45:28+00:00\",\"dateModified\":\"2023-07-26T08:45:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan regresi polinomial di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Regresi polinomial di google spreadsheet (langkah demi langkah)\"}]},{\"@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":"Regresi Polinomial di Google Spreadsheet (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara melakukan regresi polinomial di Google Spreadsheet, 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\/lembar-google-regresi-polinomial\/","og_locale":"id_ID","og_type":"article","og_title":"Regresi Polinomial di Google Spreadsheet (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara melakukan regresi polinomial di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/","og_site_name":"Statorials","article_published_time":"2023-07-26T08:45:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel1.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\/lembar-google-regresi-polinomial\/","url":"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/","name":"Regresi Polinomial di Google Spreadsheet (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T08:45:28+00:00","dateModified":"2023-07-26T08:45:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan regresi polinomial di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Regresi polinomial di google spreadsheet (langkah demi langkah)"}]},{"@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\/1447"}],"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=1447"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1447\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}