{"id":3261,"date":"2023-07-18T10:05:35","date_gmt":"2023-07-18T10:05:35","guid":{"rendered":"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/"},"modified":"2023-07-18T10:05:35","modified_gmt":"2023-07-18T10:05:35","slug":"penyesuaian-kurva-di-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/","title":{"rendered":"Pemasangan kurva di google spreadsheet (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menemukan persamaan yang paling sesuai dengan kurva untuk sekumpulan data di Google Spreadsheet.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27639 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes1.jpg\" alt=\"\" width=\"564\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini cukup mudah dilakukan menggunakan fitur <strong>Trendline<\/strong> di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara menyesuaikan persamaan ke kurva di Google Spreadsheet.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data palsu untuk digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27640 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes2.jpg\" alt=\"\" width=\"476\" height=\"475\" 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, mari buat diagram sebar untuk memvisualisasikan kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sorot sel <strong>A2:B16<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27641 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes3.jpg\" alt=\"\" width=\"480\" height=\"537\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Google Sheets akan menyisipkan diagram garis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, kita dapat dengan mudah mengubahnya menjadi diagram sebar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, klik panah drop-down di sebelah <strong>Chart Type<\/strong> dan pilih <strong>Scatter Plot<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27642 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes4.jpg\" alt=\"\" width=\"335\" height=\"536\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27643 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes5.jpg\" alt=\"\" width=\"545\" height=\"353\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Garis Tren<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Di panel <strong>Chart Editor<\/strong> , klik tab <strong>Customize<\/strong> . Kemudian klik opsi tarik-turun <strong>Seri<\/strong> . Kemudian centang kotak di sebelah <strong>Trendline<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27644 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes6.jpg\" alt=\"\" width=\"313\" height=\"698\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian centang kotak di bawah yang bertuliskan <strong>Show R <sup>2<\/sup><\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Garis tren linier berikut secara otomatis akan ditambahkan ke plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27646 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes7-1.jpg\" alt=\"\" width=\"608\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">R-squared menunjukkan persentase variasi <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;\">R kuadrat untuk kurva khusus ini adalah <strong>0,363<\/strong> .<\/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\">Berapa nilai R-kuadrat yang bagus?<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Pilih Garis Tren Terbaik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Dari grafik di atas terlihat jelas bahwa garis tren linier gagal menangkap perilaku data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebagai gantinya, kita dapat memilih untuk menyesuaikan kurva polinomial.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik panah drop-down di bawah <strong>Type<\/strong> dan pilih <strong>Polynomial<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik panah tarik-turun di bawah <strong>Derajat Polinomial<\/strong> dan pilih <strong>4<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik panah tarik-turun di bawah <strong>Label<\/strong> dan klik <strong>Gunakan Persamaan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27647 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes8.jpg\" alt=\"\" width=\"355\" height=\"488\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini menghasilkan kurva berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-27648\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes9.jpg\" alt=\"penyesuaian kurva di Google Spreadsheet\" width=\"607\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Persamaan kurvanya adalah sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = -0,0192x <sup>4<\/sup> + 0,7081x <sup>3<\/sup> \u2013 8,3649x <sup>2<\/sup> + 35,823x \u2013 26,516<\/span><\/p>\n<p> <span style=\"color: #000000;\">R kuadrat untuk kurva khusus ini adalah <strong>0,971<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">R-kuadrat ini jauh lebih tinggi dibandingkan garis tren sebelumnya, yang menunjukkan bahwa garis tersebut lebih cocok dengan kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Persamaan kurva ini juga dapat kita gunakan untuk memprediksi nilai variabel respon berdasarkan variabel prediktor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya jika <em>x<\/em> = 4 maka kita prediksi <em>y<\/em> = <strong>23,34<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\">y = -0,0192(4) <sup>4<\/sup> + 0,7081(4) <sup>3<\/sup> \u2013 8,3649(4) <sup>2<\/sup> + 35,823(4) \u2013 26,516 = 23,34<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda mungkin perlu bermain-main dengan nilai derajat polinomial sampai Anda menemukan kurva yang tampaknya cocok dengan data tanpa <a href=\"https:\/\/statorials.org\/id\/pembelajaran-mesin-yang-berlebihan\/\" target=\"_blank\" rel=\"noopener\">overfitting<\/a> .<\/span><\/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 tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/regresi-linier-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi linier di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/deretan-lembar-google-yang-paling-cocok\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan baris yang paling sesuai di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perkiraan-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Perkiraan di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menemukan persamaan yang paling sesuai dengan kurva untuk sekumpulan data di Google Spreadsheet. Untungnya, hal ini cukup mudah dilakukan menggunakan fitur Trendline di Google Spreadsheet. Tutorial ini memberikan contoh langkah demi langkah tentang cara menyesuaikan persamaan ke kurva di Google Spreadsheet. Langkah 1: Buat datanya Pertama, mari buat kumpulan data palsu [&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>Pemasangan Kurva di Google Spreadsheet (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan pencocokan kurva 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\/penyesuaian-kurva-di-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pemasangan Kurva di Google Spreadsheet (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan pencocokan kurva di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T10:05:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes1.jpg\" \/>\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\/penyesuaian-kurva-di-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/\",\"name\":\"Pemasangan Kurva di Google Spreadsheet (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T10:05:35+00:00\",\"dateModified\":\"2023-07-18T10:05:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan pencocokan kurva di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pemasangan kurva di google spreadsheet (dengan contoh)\"}]},{\"@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":"Pemasangan Kurva di Google Spreadsheet (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara melakukan pencocokan kurva 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\/penyesuaian-kurva-di-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Pemasangan Kurva di Google Spreadsheet (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara melakukan pencocokan kurva di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-18T10:05:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-de-courbes1.jpg"}],"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\/penyesuaian-kurva-di-google-sheet\/","url":"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/","name":"Pemasangan Kurva di Google Spreadsheet (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T10:05:35+00:00","dateModified":"2023-07-18T10:05:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan pencocokan kurva di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pemasangan kurva di google spreadsheet (dengan contoh)"}]},{"@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\/3261"}],"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=3261"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3261\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}