{"id":1853,"date":"2023-07-24T17:53:57","date_gmt":"2023-07-24T17:53:57","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/"},"modified":"2023-07-24T17:53:57","modified_gmt":"2023-07-24T17:53:57","slug":"excel-penyesuaian-polinomial","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/","title":{"rendered":"Cara menyesuaikan kurva polinomial di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>LINEST()<\/strong> di Excel untuk menyesuaikan kurva polinomial hingga derajat tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat menggunakan sintaks dasar berikut untuk menyesuaikan kurva polinomial derajat 3:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LINEST( <span style=\"color: #3366ff;\">known_ys<\/span> , <span style=\"color: #ff0000;\">known_xs<\/span> ^{1, 2, 3})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Fungsi ini mengembalikan serangkaian koefisien yang menggambarkan kecocokan polinomial.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsi ini agar sesuai dengan kurva polinomial 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 beberapa data untuk digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-17851 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyfit1.png\" alt=\"\" width=\"546\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Pasangkan kurva polinomial<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari kita gunakan fungsi <strong>LINEST()<\/strong> untuk menyesuaikan kurva polinomial derajat 3 ke kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-17852\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyfit2.png\" alt=\"Kesesuaian Polinomial Excel\" width=\"560\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Interpretasikan kurva polinomial<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>ENTER<\/strong> , tabel koefisien akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-17853 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyfit3.png\" alt=\"\" width=\"562\" height=\"499\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan koefisien-koefisien ini, kita dapat membuat persamaan berikut untuk menggambarkan hubungan antara x dan y:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = 0,0218x <sup>3<\/sup> \u2013 0,2239x <sup>2<\/sup> \u2013 0,6084x + 30,0915<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggunakan persamaan ini untuk menghitung nilai y yang diharapkan, mengingat nilai x.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, x = 4. Nilai y yang diharapkan adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = 0,0218(4) <sup>3<\/sup> \u2013 0,2239(4) <sup>2<\/sup> \u2013 0,6084(4) + 30,0915 = <strong>25,47<\/strong><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Polinomial di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-kuadrat-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi kuadrat di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-tren-kuadrat-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis tren kuadrat di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi LINEST() di Excel untuk menyesuaikan kurva polinomial hingga derajat tertentu. Misalnya, Anda dapat menggunakan sintaks dasar berikut untuk menyesuaikan kurva polinomial derajat 3: =LINEST( known_ys , known_xs ^{1, 2, 3}) Fungsi ini mengembalikan serangkaian koefisien yang menggambarkan kecocokan polinomial. Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsi ini agar [&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 Menyesuaikan Kurva Polinomial di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyesuaikan kurva polinomial 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\/excel-penyesuaian-polinomial\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menyesuaikan Kurva Polinomial di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyesuaikan kurva polinomial di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T17:53:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyfit1.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\/excel-penyesuaian-polinomial\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/\",\"name\":\"Cara Menyesuaikan Kurva Polinomial di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T17:53:57+00:00\",\"dateModified\":\"2023-07-24T17:53:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyesuaikan kurva polinomial di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menyesuaikan kurva polinomial 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":"Cara Menyesuaikan Kurva Polinomial di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara menyesuaikan kurva polinomial 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\/excel-penyesuaian-polinomial\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menyesuaikan Kurva Polinomial di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara menyesuaikan kurva polinomial di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/","og_site_name":"Statorials","article_published_time":"2023-07-24T17:53:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/polyfit1.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\/excel-penyesuaian-polinomial\/","url":"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/","name":"Cara Menyesuaikan Kurva Polinomial di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T17:53:57+00:00","dateModified":"2023-07-24T17:53:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyesuaikan kurva polinomial di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-penyesuaian-polinomial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menyesuaikan kurva polinomial 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\/1853"}],"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=1853"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1853\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}