{"id":764,"date":"2023-07-28T20:25:05","date_gmt":"2023-07-28T20:25:05","guid":{"rendered":"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/"},"modified":"2023-07-28T20:25:05","modified_gmt":"2023-07-28T20:25:05","slug":"regresi-polinomial-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/","title":{"rendered":"Cara melakukan regresi polinomial di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Analisis regresi digunakan untuk mengukur hubungan antara satu atau lebih variabel penjelas 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 penjelas 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 penjelas dan variabel respon tidak linier.<\/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 menjelaskan cara melakukan regresi polinomial di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Regresi Polinomial di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8178 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel4.png\" alt=\"Contoh Kumpulan Data di Excel\" width=\"388\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selesaikan langkah-langkah berikut untuk menyesuaikan persamaan regresi polinomial dengan kumpulan data ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Buat diagram sebar.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita perlu membuat diagram sebar. Pergi ke grup <strong>Charts<\/strong> pada tab <strong>Insert<\/strong> dan klik pada tipe grafik pertama di <strong>Scatter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8179 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel5.png\" alt=\"Plot sebar di Excel\" width=\"658\" height=\"212\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Titik awan secara otomatis akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8180 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel6.png\" alt=\"Hubungan kubik dalam diagram sebar di contoh Excel\" width=\"583\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Tambahkan garis tren.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menambahkan garis tren ke diagram sebar. Untuk melakukan ini, klik pada salah satu titik individual di titik cloud. Selanjutnya, klik kanan dan pilih <strong>Tambahkan Garis Tren\u2026<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8181 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel7.png\" alt=\"Garis tren untuk regresi polinomial di Excel\" width=\"612\" height=\"354\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jendela baru akan muncul dengan opsi untuk menentukan garis tren. Pilih <strong>Polinomial<\/strong> dan pilih nomor yang ingin Anda gunakan untuk <strong>Order<\/strong> . Kami akan menggunakan 3. Selanjutnya, centang kotak di bagian bawah yang bertuliskan <strong>Tampilkan persamaan pada grafik<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8183 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel8.png\" alt=\"Garis Tren Polinomial di Excel\" width=\"241\" height=\"513\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis tren dengan persamaan regresi polinomial akan otomatis muncul di scatterplot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8184 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polynomeexcel9.png\" alt=\"Regresi Polinomial di Excel\" width=\"500\" height=\"297\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Tafsirkan persamaan regresi.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh khusus ini, persamaan regresi polinomial kami adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = -0,1265x <sup>3<\/sup> + 2,6482x <sup>2<\/sup> \u2013 14,238x + 37,213<\/span><\/p>\n<p> <span style=\"color: #000000;\">Persamaan ini dapat digunakan untuk mencari nilai yang diharapkan dari variabel respon jika diberi nilai variabel penjelas tertentu. Misalnya, asumsikan x = 4. Nilai yang diharapkan untuk variabel respon, y, adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = -0,1265(4) <sup>3<\/sup> + 2,6482(4) <sup>2<\/sup> \u2013 14,238(4) + 37,213 = <strong>14,5362<\/strong> .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Analisis regresi digunakan untuk mengukur hubungan antara satu atau lebih variabel penjelas dan variabel respon . Jenis analisis regresi yang paling umum adalah regresi linier sederhana , digunakan ketika variabel penjelas dan variabel respons mempunyai hubungan linier. Namun terkadang hubungan antara variabel penjelas dan variabel respon tidak linier. 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>Cara Melakukan Regresi Polinomial di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara melakukan regresi polinomial 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\/regresi-polinomial-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Regresi Polinomial di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara melakukan regresi polinomial di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T20:25:05+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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\",\"name\":\"Cara Melakukan Regresi Polinomial di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T20:25:05+00:00\",\"dateModified\":\"2023-07-28T20:25:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara melakukan regresi polinomial di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan regresi polinomial 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 Melakukan Regresi Polinomial di Excel - Statologi","description":"Penjelasan sederhana tentang cara melakukan regresi polinomial 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\/regresi-polinomial-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Regresi Polinomial di Excel - Statologi","og_description":"Penjelasan sederhana tentang cara melakukan regresi polinomial di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T20:25:05+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":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/","url":"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/","name":"Cara Melakukan Regresi Polinomial di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T20:25:05+00:00","dateModified":"2023-07-28T20:25:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara melakukan regresi polinomial di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan regresi polinomial 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\/764"}],"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=764"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}