{"id":1400,"date":"2023-07-26T13:17:04","date_gmt":"2023-07-26T13:17:04","guid":{"rendered":"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/"},"modified":"2023-07-26T13:17:04","modified_gmt":"2023-07-26T13:17:04","slug":"tambahkan-garis-regresi-ke-scatterplot-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/","title":{"rendered":"Bagaimana cara menambahkan garis regresi ke scatterplot di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/regresi-linier-1\/\" target=\"_blank\" rel=\"noopener\">Garis regresi linier sederhana<\/a> mewakili garis yang paling \u201csesuai\u201d dengan kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara cepat menambahkan garis regresi linier sederhana ke plot sebar di Excel.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Langkah 1: Buat datanya<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data sederhana untuk digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13891 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg1.png\" alt=\"\" width=\"425\" height=\"473\" 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, sorot rentang sel <strong>A2:B21<\/strong> . Di pita atas, klik tab <strong>INSERT<\/strong> , lalu klik <strong>INSERT Scatter Plot (X, Y) atau Bubble Chart<\/strong> di grup <strong>Charts<\/strong> dan klik opsi pertama untuk membuat scatter plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13892 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg2.png\" alt=\"\" width=\"455\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13893 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg3.png\" alt=\"\" width=\"516\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Garis Regresi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik di mana saja pada diagram sebar. Kemudian klik tanda plus (+) di pojok kanan atas plot dan centang kotak bertuliskan <strong>Trendline<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini secara otomatis akan menambahkan garis regresi linier sederhana ke diagram sebar Anda:<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13894 size-full\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg4.png\" alt=\"Tambahkan garis regresi ke scatterplot di Excel\" width=\"1897\" height=\"1179\" srcset=\"\" sizes=\"\"><\/span><\/h3>\n<h3> <strong><span style=\"color: #000000;\">Langkah 4: Tambahkan persamaan garis regresi<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Anda juga dapat menambahkan persamaan garis regresi ke grafik dengan mengklik <strong>Opsi Lainnya.<\/strong> Pada kotak yang muncul di sebelah kanan, centang kotak di samping <strong>Tampilkan persamaan pada grafik<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Persamaan regresi linier sederhana akan otomatis muncul pada scatterplot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13895 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg5.png\" alt=\"Persamaan garis regresi pada scatterplot di Excel\" width=\"625\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh khusus ini, garis regresinya menjadi:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 0,917x + 12,462<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Cara menafsirkannya adalah:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Untuk setiap tambahan satu satuan kenaikan variabel <em>x<\/em> , rata-rata kenaikan variabel <em>y<\/em> adalah <strong>0,917<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jika variabel <em>x<\/em> sama dengan nol maka nilai rata-rata variabel <em>y<\/em> adalah <strong>12,462<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggunakan persamaan ini untuk memperkirakan nilai <em>y<\/em> berdasarkan nilai <em>x<\/em> . Misalnya, jika <em>x<\/em> adalah 15, nilai yang diharapkan untuk <em>y<\/em> adalah 26,217:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = 0,917*(15) + 12,462 = <strong>26,217<\/strong><\/span><\/p>\n<hr>\n<p> <span style=\"color: #000000;\">Temukan tutorial Excel lainnya di sini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Garis regresi linier sederhana mewakili garis yang paling \u201csesuai\u201d dengan kumpulan data. Tutorial ini memberikan contoh langkah demi langkah tentang cara cepat menambahkan garis regresi linier sederhana ke plot sebar di Excel. Langkah 1: Buat datanya Pertama, mari buat kumpulan data sederhana untuk digunakan: Langkah 2: Buat diagram sebar Selanjutnya, sorot rentang sel A2:B21 . [&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>Bagaimana cara menambahkan garis regresi ke scatterplot di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara cepat menambahkan garis regresi ke scatterplot di Excel, beserta sebuah contoh.\" \/>\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\/tambahkan-garis-regresi-ke-scatterplot-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menambahkan garis regresi ke scatterplot di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara cepat menambahkan garis regresi ke scatterplot di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T13:17:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg1.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\/tambahkan-garis-regresi-ke-scatterplot-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/\",\"name\":\"Bagaimana cara menambahkan garis regresi ke scatterplot di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T13:17:04+00:00\",\"dateModified\":\"2023-07-26T13:17:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara cepat menambahkan garis regresi ke scatterplot di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan garis regresi ke scatterplot 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":"Bagaimana cara menambahkan garis regresi ke scatterplot di Excel","description":"Tutorial ini menjelaskan cara cepat menambahkan garis regresi ke scatterplot di Excel, beserta sebuah contoh.","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\/tambahkan-garis-regresi-ke-scatterplot-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menambahkan garis regresi ke scatterplot di Excel","og_description":"Tutorial ini menjelaskan cara cepat menambahkan garis regresi ke scatterplot di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T13:17:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg1.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\/tambahkan-garis-regresi-ke-scatterplot-excel\/","url":"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/","name":"Bagaimana cara menambahkan garis regresi ke scatterplot di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T13:17:04+00:00","dateModified":"2023-07-26T13:17:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara cepat menambahkan garis regresi ke scatterplot di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan garis regresi ke scatterplot 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\/1400"}],"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=1400"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1400\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}