{"id":4748,"date":"2023-07-08T08:26:23","date_gmt":"2023-07-08T08:26:23","guid":{"rendered":"https:\/\/statorials.org\/id\/korelasi-silang-excel\/"},"modified":"2023-07-08T08:26:23","modified_gmt":"2023-07-08T08:26:23","slug":"korelasi-silang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/korelasi-silang-excel\/","title":{"rendered":"Cara menghitung korelasi silang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Korelasi silang<\/strong> adalah cara untuk mengukur tingkat kemiripan antara suatu deret waktu dan versi tertinggal dari deret waktu lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jenis korelasi ini berguna untuk dihitung karena dapat memberi tahu kita apakah nilai dalam satu deret waktu merupakan prediksi nilai masa depan dalam deret waktu lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan kata lain, ini dapat memberi tahu kita apakah suatu deret waktu merupakan indikator utama untuk deret waktu lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menghitung korelasi silang antara dua deret waktu di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Menghitung Korelasi Silang di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dua deret waktu berikut di Excel yang memperlihatkan total pengeluaran pemasaran (dalam ribuan) untuk perusahaan tertentu serta total pendapatan (dalam ribuan) selama 12 bulan berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37074 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crosscor1.png\" alt=\"\" width=\"486\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menghitung korelasi silang untuk lag yang berbeda antara dua deret waktu dengan mengetikkan rumus berikut di sel <strong>E2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=CORREL(OFFSET( <span style=\"color: #3366ff;\">A$2:A$13<\/span> ,0,0,COUNT( <span style=\"color: #3366ff;\">A$2:A$13<\/span> )- <span style=\"color: #ff0000;\">D2<\/span> ,1),OFFSET( <span style=\"color: #800080;\">B$2:B$13<\/span> , <span style=\"color: #ff0000;\">D2<\/span> ,0,COUNT( <span style=\"color: #800080;\">B$2:B$13<\/span> )- <span style=\"color: #ff0000;\">D2,1<\/span> ))\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke sel yang tersisa di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37075\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crosscor2.png\" alt=\"korelasi silang di Excel\" width=\"535\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Korelasi pada lag 0 (yaitu korelasi normal antara dua deret waktu tanpa lag) adalah <strong>0.77<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Korelasi pada lag 1 adalah <strong>0,93<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Korelasi pada lag 2 adalah <strong>0,95<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa korelasinya paling tinggi pada jeda <strong>2<\/strong> antara dua deret waktu.<\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/matriks-korelasi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Matriks Korelasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/korelasi-peringkat-spearman-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Korelasi Rank Spearman di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung korelasi parsial di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/titik-korelasi-biserial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung korelasi titik-biserial di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Korelasi silang adalah cara untuk mengukur tingkat kemiripan antara suatu deret waktu dan versi tertinggal dari deret waktu lainnya. Jenis korelasi ini berguna untuk dihitung karena dapat memberi tahu kita apakah nilai dalam satu deret waktu merupakan prediksi nilai masa depan dalam deret waktu lainnya. Dengan kata lain, ini dapat memberi tahu kita apakah suatu [&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 Korelasi Silang di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung korelasi silang di Excel, dengan 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\/korelasi-silang-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Korelasi Silang di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung korelasi silang di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/korelasi-silang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T08:26:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crosscor1.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-silang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/korelasi-silang-excel\/\",\"name\":\"Cara Menghitung Korelasi Silang di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T08:26:23+00:00\",\"dateModified\":\"2023-07-08T08:26:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung korelasi silang di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/korelasi-silang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/korelasi-silang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/korelasi-silang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung korelasi silang 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 Korelasi Silang di Excel - Statorials","description":"Tutorial ini menjelaskan cara menghitung korelasi silang di Excel, dengan 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\/korelasi-silang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Korelasi Silang di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung korelasi silang di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/korelasi-silang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-08T08:26:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crosscor1.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-silang-excel\/","url":"https:\/\/statorials.org\/id\/korelasi-silang-excel\/","name":"Cara Menghitung Korelasi Silang di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T08:26:23+00:00","dateModified":"2023-07-08T08:26:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung korelasi silang di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/korelasi-silang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/korelasi-silang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/korelasi-silang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung korelasi silang 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\/4748"}],"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=4748"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4748\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}