{"id":1612,"date":"2023-07-25T16:09:28","date_gmt":"2023-07-25T16:09:28","guid":{"rendered":"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/"},"modified":"2023-07-25T16:09:28","modified_gmt":"2023-07-25T16:09:28","slug":"kemiringan-garis-tren-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/","title":{"rendered":"Cara menemukan kemiringan garis tren di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mencari kemiringan garis tren di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, ini cukup mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya.<\/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 untuk digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15991 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente1.png\" alt=\"\" width=\"411\" height=\"407\" 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, mari buat diagram sebar untuk memvisualisasikan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, sorot datanya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15992 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente2.png\" alt=\"\" width=\"435\" height=\"430\" 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-15993 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente3.png\" alt=\"\" width=\"501\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Garis Tren<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari tambahkan garis tren ke diagram sebar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, klik di mana saja pada plot sebar. Kemudian klik tanda plus berwarna hijau (+) di pojok kanan atas chart dan klik kotak di samping <strong>Trendline<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15994 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente4.png\" alt=\"\" width=\"581\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Tunjukkan kemiringan garis tren<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menemukan kemiringan garis tren, klik panah kanan di samping <strong>Garis Tren<\/strong> dan klik <strong>Opsi Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15995 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente5.png\" alt=\"\" width=\"621\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul di sisi kanan layar, centang kotak di sebelah <strong>Tampilkan persamaan pada grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15996 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente6.png\" alt=\"\" width=\"281\" height=\"548\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Persamaan garis tren secara otomatis akan muncul pada scatterplot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15997 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente7.png\" alt=\"Kemiringan garis tren di Excel\" width=\"501\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Persamaan garis trennya menjadi <strong>y = 2,4585x \u2013 1,3553<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya intersepnya adalah <strong>-1.3553<\/strong> dan kemiringannya <strong>2.4585<\/strong> .<\/span><\/p>\n<hr>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan tutorial Excel lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mencari kemiringan garis tren di Excel. Untungnya, ini cukup mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya. Langkah 1: Buat datanya Pertama, mari buat kumpulan data palsu untuk digunakan: Langkah 2: Buat diagram sebar Selanjutnya, mari buat diagram sebar untuk memvisualisasikan data. Untuk melakukan ini, sorot datanya: Kemudian [&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 Menemukan Kemiringan Garis Tren di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari kemiringan garis tren 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\/kemiringan-garis-tren-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menemukan Kemiringan Garis Tren di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T16:09:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente1.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\/kemiringan-garis-tren-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/\",\"name\":\"Cara Menemukan Kemiringan Garis Tren di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T16:09:28+00:00\",\"dateModified\":\"2023-07-25T16:09:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menemukan kemiringan garis tren 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 Menemukan Kemiringan Garis Tren di Excel","description":"Tutorial ini menjelaskan cara mencari kemiringan garis tren 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\/kemiringan-garis-tren-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menemukan Kemiringan Garis Tren di Excel","og_description":"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T16:09:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente1.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\/kemiringan-garis-tren-excel\/","url":"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/","name":"Cara Menemukan Kemiringan Garis Tren di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T16:09:28+00:00","dateModified":"2023-07-25T16:09:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menemukan kemiringan garis tren 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\/1612"}],"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=1612"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1612\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}