{"id":4002,"date":"2023-07-14T05:53:27","date_gmt":"2023-07-14T05:53:27","guid":{"rendered":"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/"},"modified":"2023-07-14T05:53:27","modified_gmt":"2023-07-14T05:53:27","slug":"kemiringan-tren-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/","title":{"rendered":"Cara menemukan kemiringan garis tren di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Kemiringan<\/strong> garis tren mewakili kenaikan rata-rata nilai y untuk kenaikan satu satuan nilai x.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengetahui kemiringan garis tren di Google Sheets, kita dapat menggunakan fungsi <b>SLOPE<\/b> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>LERENG(data_y, data_x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>data_y<\/strong> : Rentang nilai y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>data_x<\/strong> : Rentang nilai x<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya untuk menghitung kemiringan garis tren di Google Spreadsheet.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Buat datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data dengan dua variabel di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32013 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente1.jpg\" alt=\"\" width=\"455\" height=\"512\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung kemiringan garis tren<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan rumus berikut ke dalam sel <strong>E1<\/strong> untuk menghitung kemiringan garis tren kumpulan data ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SLOPE( <span style=\"color: #ff6600;\">B2:B21<\/span> , <span style=\"color: #800080;\">A2:A21<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32014\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente2.jpg\" alt=\"kemiringan garis tren di Google Spreadsheet\" width=\"547\" height=\"534\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari keluarannya, kita dapat melihat bahwa kemiringannya kira-kira <strong>0,917<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya nilai y meningkat rata-rata sebesar <strong>0,917<\/strong> untuk kenaikan x satu satuan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Visualisasikan Kemiringan Garis Tren<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk memvisualisasikan nilai kemiringan, kita dapat membuat plot sebar dan menambahkan garis tren.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot nilai dalam rentang <strong>A2:B21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Bagan<\/strong> di menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32015 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente3.jpg\" alt=\"\" width=\"499\" height=\"544\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela <strong>editor bagan<\/strong> yang muncul di sisi kanan layar, pilih <strong>Scatter Plot<\/strong> sebagai <strong>Chart Type<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik tab <strong>Kustomisasi<\/strong> , gulir ke bawah ke <strong>Seri<\/strong> , lalu centang kotak di samping <strong>Garis Tren<\/strong> dan klik <strong>Gunakan Persamaan<\/strong> di daftar drop-down di bawah <strong>Label<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32016 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente4.jpg\" alt=\"\" width=\"325\" height=\"666\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis tren dan persamaan garis tren akan ditampilkan pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32017\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente5.jpg\" alt=\"menghitung kemiringan garis tren di Google Sheets\" width=\"574\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat rumus garis tren linier:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 0,917x + 12,5<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Hal ini menunjukkan bahwa perpotongan y dari garis tren adalah <strong>12,5<\/strong> dan kemiringannya adalah <strong>0,917<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya nilai y meningkat rata-rata sebesar <strong>0,917<\/strong> untuk kenaikan x satu satuan.<\/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\/penyesuaian-kurva-di-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Pemasangan Kurva di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-tren-google\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis tren ke grafik di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kemiringan garis tren mewakili kenaikan rata-rata nilai y untuk kenaikan satu satuan nilai x. Untuk mengetahui kemiringan garis tren di Google Sheets, kita dapat menggunakan fungsi SLOPE . Fungsi ini menggunakan sintaks berikut: LERENG(data_y, data_x) Emas: data_y : Rentang nilai y data_x : Rentang nilai x Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya [&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 Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Google Sheets, 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-tren-google-sheet\/\" \/>\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 Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T05:53:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente1.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=\"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-tren-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/\",\"name\":\"Cara menemukan kemiringan garis tren di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T05:53:27+00:00\",\"dateModified\":\"2023-07-14T05:53:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menemukan kemiringan garis tren di google spreadsheet\"}]},{\"@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 Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Google Sheets, 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-tren-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menemukan kemiringan garis tren di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-14T05:53:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pente1.jpg"}],"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-tren-google-sheet\/","url":"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/","name":"Cara menemukan kemiringan garis tren di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T05:53:27+00:00","dateModified":"2023-07-14T05:53:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari kemiringan garis tren di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menemukan kemiringan garis tren di google spreadsheet"}]},{"@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\/4002"}],"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=4002"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4002\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}