{"id":878,"date":"2023-07-28T11:15:18","date_gmt":"2023-07-28T11:15:18","guid":{"rendered":"https:\/\/statorials.org\/id\/autokorelasi-excel\/"},"modified":"2023-07-28T11:15:18","modified_gmt":"2023-07-28T11:15:18","slug":"autokorelasi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/autokorelasi-excel\/","title":{"rendered":"Cara menghitung autokorelasi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Autokorelasi<\/strong> mengukur tingkat kemiripan antara deret waktu dan versi yang tertinggal selama interval waktu yang berurutan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kadang-kadang juga disebut &#8220;korelasi serial&#8221; atau &#8220;korelasi tertinggal&#8221; karena mengukur hubungan antara nilai variabel saat ini dan nilai historisnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ketika autokorelasi dalam deret waktu tinggi, prediksi nilai masa depan menjadi mudah hanya dengan mengacu pada nilai masa lalu.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Autokorelasi di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tidak ada fungsi bawaan untuk menghitung autokorelasi di Excel, namun kita bisa menggunakan rumus tunggal untuk menghitung autokorelasi deret waktu untuk nilai lag tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki deret waktu berikut yang menunjukkan nilai variabel tertentu selama 15 periode waktu berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9468 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autocorrelationexcel1.png\" alt=\"Contoh Time Series di Excel\" width=\"458\" height=\"501\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung autokorelasi pada lag k =2.<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong>=(SUMPRODUCT( <span style=\"color: #3366ff;\">B2:B14<\/span> -AVERAGE( <span style=\"color: #ff6600;\">B2:B16<\/span> ), <span style=\"color: #993366;\">B4:B16<\/span> -AVERAGE( <span style=\"color: #ff6600;\">B2:B16<\/span> ))\/COUNT( <span style=\"color: #ff6600;\">B2:B16<\/span> ))\/VAR.P( <span style=\"color: #ff6600;\">B2:B16<\/span> )<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9469 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autocorrelationexcel2.png\" alt=\"Menghitung autokorelasi di Excel\" width=\"668\" height=\"268\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberikan nilai <strong>0,656325<\/strong> . Ini adalah autokorelasi pada lag k = 2.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Autokorelasi pada lag k = 3 dapat kita hitung dengan mengubah rentang nilai pada rumus:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong>=(SUMPRODUCT( <span style=\"color: #3366ff;\">B2:B13<\/span> -AVERAGE( <span style=\"color: #ff6600;\">B2:B16<\/span> ), <span style=\"color: #993366;\">B5:B16<\/span> -AVERAGE( <span style=\"color: #ff6600;\">B2:B16<\/span> ))\/COUNT( <span style=\"color: #ff6600;\">B2:B16<\/span> ))\/VAR.P( <span style=\"color: #ff6600;\">B2:B16<\/span> )<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9474 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autocorrelationexcel3-1.png\" alt=\"Fungsi autokorelasi untuk deret waktu di Excel\" width=\"668\" height=\"244\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberikan nilai <strong>0,49105<\/strong> . Ini adalah autokorelasi pada lag k = 3.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menemukan autokorelasi pada setiap lag menggunakan rumus serupa. Anda akan melihat bahwa semakin tinggi lag, semakin rendah autokorelasinya. Ini adalah tipikal proses deret waktu autoregresif.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9475 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autocorrelationexcel4.png\" alt=\"Autokorelasi pada lag yang berbeda di Excel\" width=\"536\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan lebih banyak tutorial deret waktu Excel di halaman ini .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Autokorelasi mengukur tingkat kemiripan antara deret waktu dan versi yang tertinggal selama interval waktu yang berurutan. Kadang-kadang juga disebut &#8220;korelasi serial&#8221; atau &#8220;korelasi tertinggal&#8221; karena mengukur hubungan antara nilai variabel saat ini dan nilai historisnya. Ketika autokorelasi dalam deret waktu tinggi, prediksi nilai masa depan menjadi mudah hanya dengan mengacu pada nilai masa lalu. Autokorelasi [&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 Autokorelasi di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung autokorelasi 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\/autokorelasi-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Autokorelasi di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung autokorelasi di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/autokorelasi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T11:15:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autocorrelationexcel1.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\/autokorelasi-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/autokorelasi-excel\/\",\"name\":\"Cara Menghitung Autokorelasi di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T11:15:18+00:00\",\"dateModified\":\"2023-07-28T11:15:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung autokorelasi di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/autokorelasi-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/autokorelasi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/autokorelasi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung autokorelasi 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 Autokorelasi di Excel - Statologi","description":"Penjelasan sederhana cara menghitung autokorelasi 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\/autokorelasi-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Autokorelasi di Excel - Statologi","og_description":"Penjelasan sederhana cara menghitung autokorelasi di Excel.","og_url":"https:\/\/statorials.org\/id\/autokorelasi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T11:15:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autocorrelationexcel1.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\/autokorelasi-excel\/","url":"https:\/\/statorials.org\/id\/autokorelasi-excel\/","name":"Cara Menghitung Autokorelasi di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T11:15:18+00:00","dateModified":"2023-07-28T11:15:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung autokorelasi di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/autokorelasi-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/autokorelasi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/autokorelasi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung autokorelasi 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\/878"}],"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=878"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/878\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}