{"id":953,"date":"2023-07-28T05:11:14","date_gmt":"2023-07-28T05:11:14","guid":{"rendered":"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/"},"modified":"2023-07-28T05:11:14","modified_gmt":"2023-07-28T05:11:14","slug":"korelasi-bergulir-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/","title":{"rendered":"Cara menghitung korelasi bergulir di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Korelasi bergulir<\/strong> adalah korelasi antara dua deret waktu dalam jendela geser. Salah satu manfaat dari jenis korelasi ini adalah Anda dapat memvisualisasikan korelasi antara dua rangkaian waktu dari waktu ke waktu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung dan memvisualisasikan korelasi bergulir di Excel.<\/span><\/p>\n<h3> <strong>Cara Menghitung Korelasi Bergulir di Excel<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dua deret waktu berikut di Excel yang menampilkan jumlah total produk yang terjual untuk dua produk berbeda selama periode 20 bulan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10037 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel1.png\" alt=\"\" width=\"404\" height=\"477\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung <strong>korelasi bergulir 3 bulan<\/strong> antara dua deret waktu, kita cukup menggunakan fungsi <strong>CORREL()<\/strong> di Excel. Misalnya, berikut cara menghitung korelasi bergulir 3 bulan pertama antara dua deret waktu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10038 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel2.png\" alt=\"Contoh korelasi geser di excel\" width=\"438\" height=\"472\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret rumus ini ke seluruh sel di kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10039 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel3.png\" alt=\"Korelasi Geser di Excel\" width=\"444\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap sel pada kolom berjudul \u201cKorelasi Bergulir 3 Bulan\u201d menunjukkan korelasi antara dua penjualan produk selama 3 bulan sebelumnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menggunakan penundaan pengguliran yang lebih lama jika kita menginginkannya. Misalnya, kita dapat menghitung korelasinya selama 6 bulan berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10040 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel4.png\" alt=\"Korelasi bergulir 6 bulan di Excel\" width=\"440\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong>Cara Memvisualisasikan Korelasi Bergulir di Excel<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Setelah kita menghitung korelasi bergulir antara dua deret waktu, kita dapat memvisualisasikan korelasi bergulir menggunakan grafik garis sederhana. Gunakan langkah-langkah berikut untuk melakukannya:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Sorot nilai korelasi bergulir.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, sorot nilai di cell range D7:D21.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10041 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel5.png\" alt=\"\" width=\"407\" height=\"480\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Sisipkan diagram garis.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas di Excel. Di grup <strong>Charts<\/strong> , klik opsi grafik pertama di bagian <strong>Line or Area Chart<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10042 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel6.png\" alt=\"\" width=\"600\" height=\"472\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik garis berikut akan otomatis muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10043 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel7.png\" alt=\"\" width=\"461\" height=\"375\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu y menampilkan korelasi bergulir 6 bulan antara dua deret waktu dan sumbu x menampilkan bulan akhir korelasi bergulir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengubah judul, label sumbu, dan warna agar bagan lebih estetis.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/matriks-korelasi-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Membuat dan Menafsirkan Matriks Korelasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/autokorelasi-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Autokorelasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/korelasi-nilai-p-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara mencari nilai P untuk koefisien korelasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Korelasi bergulir adalah korelasi antara dua deret waktu dalam jendela geser. Salah satu manfaat dari jenis korelasi ini adalah Anda dapat memvisualisasikan korelasi antara dua rangkaian waktu dari waktu ke waktu. Tutorial ini menjelaskan cara menghitung dan memvisualisasikan korelasi bergulir di Excel. Cara Menghitung Korelasi Bergulir di Excel Katakanlah kita memiliki dua deret waktu berikut [&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 Menghitung Rolling Correlation di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung dan memvisualisasikan korelasi bergulir di Excel.\" \/>\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\/korelasi-bergulir-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rolling Correlation di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung dan memvisualisasikan korelasi bergulir di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T05:11:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel1.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\/korelasi-bergulir-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/\",\"name\":\"Cara Menghitung Rolling Correlation di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T05:11:14+00:00\",\"dateModified\":\"2023-07-28T05:11:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung dan memvisualisasikan korelasi bergulir di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung korelasi bergulir 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 Menghitung Rolling Correlation di Excel - Statorials","description":"Penjelasan sederhana tentang cara menghitung dan memvisualisasikan korelasi bergulir di Excel.","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\/korelasi-bergulir-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rolling Correlation di Excel - Statorials","og_description":"Penjelasan sederhana tentang cara menghitung dan memvisualisasikan korelasi bergulir di Excel.","og_url":"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T05:11:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rollingcorrexcel1.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\/korelasi-bergulir-unggul\/","url":"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/","name":"Cara Menghitung Rolling Correlation di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T05:11:14+00:00","dateModified":"2023-07-28T05:11:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung dan memvisualisasikan korelasi bergulir di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/korelasi-bergulir-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung korelasi bergulir 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\/953"}],"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=953"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/953\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}