{"id":1607,"date":"2023-07-25T16:37:05","date_gmt":"2023-07-25T16:37:05","guid":{"rendered":"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/"},"modified":"2023-07-25T16:37:05","modified_gmt":"2023-07-25T16:37:05","slug":"regresi-kubik-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/","title":{"rendered":"Regresi kubik di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Regresi kubik<\/strong> merupakan salah satu teknik regresi yang dapat digunakan jika hubungan antara variabel prediktor dan variabel respon bersifat nonlinier.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut memperlihatkan cara menyesuaikan model regresi kubik ke kumpulan data di Excel.<\/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 di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15945 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel1.png\" alt=\"\" width=\"456\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Lakukan regresi kubik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut di Excel agar sesuai dengan model regresi kubik di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LINEST( <span style=\"color: #3366ff;\">B2:B13<\/span> , <span style=\"color: #ff0000;\">A2:A13<\/span> ^{1,2,3})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara melakukan regresi kubik untuk contoh khusus kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15946 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel2.png\" alt=\"\" width=\"485\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan koefisien dari hasil tersebut, kita dapat menulis estimasi model regresi berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u0177 = -32,0118 + 9,832x \u2013 0,3214x <sup>2<\/sup> + 0,0033x <sup>3<\/sup><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Visualisasikan model regresi kubik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita juga dapat membuat plot sebar dengan garis regresi yang sesuai untuk memvisualisasikan model regresi kubik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, sorot datanya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15947 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel3.png\" alt=\"\" width=\"402\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas dan klik opsi pertama dari opsi <strong>Sisipkan Sebar (X,Y)<\/strong> di grup <strong>Grafik<\/strong> . Ini akan menghasilkan plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15949 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel4.png\" alt=\"\" width=\"591\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tanda plus berwarna hijau di pojok kanan atas chart dan klik tanda panah di sebelah kanan <strong>Trendline<\/strong> . Di menu tarik-turun yang muncul, klik <strong>Opsi lainnya<\/strong> &#8230;<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15950 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel5.png\" alt=\"\" width=\"605\" height=\"371\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik opsi <strong>Polynomial<\/strong> Trendline dan pilih <strong>3<\/strong> untuk pesanannya. Kemudian centang kotak di samping \u201cTampilkan persamaan pada grafik\u201d<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15951 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel6.png\" alt=\"\" width=\"296\" height=\"591\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis tren dan persamaan berikut akan muncul pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15952 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel.png\" alt=\"\" width=\"526\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa persamaan dalam grafik cocok dengan persamaan yang kita hitung menggunakan fungsi <strong>LINEST()<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <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><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Polinomial di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Regresi kubik merupakan salah satu teknik regresi yang dapat digunakan jika hubungan antara variabel prediktor dan variabel respon bersifat nonlinier. Contoh langkah demi langkah berikut memperlihatkan cara menyesuaikan model regresi kubik ke kumpulan data di Excel. Langkah 1: Buat datanya Pertama, mari buat kumpulan data palsu di Excel: Langkah 2: Lakukan regresi kubik Kemudian kita [&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 Kubik di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan regresi kubik 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\/regresi-kubik-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Regresi Kubik di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan regresi kubik di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T16:37:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel1.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-kubik-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/\",\"name\":\"Regresi Kubik di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T16:37:05+00:00\",\"dateModified\":\"2023-07-25T16:37:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan regresi kubik di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Regresi kubik di excel (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 Kubik di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara melakukan regresi kubik 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\/regresi-kubik-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Regresi Kubik di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan regresi kubik di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-25T16:37:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cubiqueexcel1.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-kubik-unggul\/","url":"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/","name":"Regresi Kubik di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T16:37:05+00:00","dateModified":"2023-07-25T16:37:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan regresi kubik di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/regresi-kubik-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/regresi-kubik-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Regresi kubik di excel (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\/1607"}],"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=1607"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1607\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}