{"id":4785,"date":"2023-07-07T23:43:31","date_gmt":"2023-07-07T23:43:31","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/"},"modified":"2023-07-07T23:43:31","modified_gmt":"2023-07-07T23:43:31","slug":"rata-rata-pergerakan-7-hari-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/","title":{"rendered":"Excel: cara menghitung rata-rata pergerakan 7 hari"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam analisis deret waktu, <strong>rata-rata pergerakan 7 hari<\/strong> hanyalah nilai rata-rata dari 7 hari sebelum dan termasuk tanggal tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menghitung rata-rata pergerakan 7 hari untuk kumpulan data di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Hitung Rata-Rata Pergerakan 7 Hari di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut yang menunjukkan total penjualan yang dilakukan oleh sebuah perusahaan selama 20 hari berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37349 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour1.png\" alt=\"\" width=\"486\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk menghitung rata-rata pergerakan nilai penjualan 7 hari, kita dapat mengetikkan rumus berikut di sel <strong>C8<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=AVERAGE( <span style=\"color: #3366ff;\">B2:B8<\/span> )\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37350\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-2.png\" alt=\"Excel menghitung rata-rata pergerakan 7 hari\" width=\"535\" height=\"514\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai di kolom C mewakili rata-rata 7 hari dari nilai di kolom penjualan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, rata-rata penjualan 7 hari untuk 1\/7\/2023 adalah <strong>10.8571<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat mengonfirmasi kebenarannya dengan menghitung secara manual rata-rata penjualan selama tujuh hari hingga dan termasuk tanggal ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37353 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour4.png\" alt=\"\" width=\"495\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata penjualan selama 7 hari. per 01\/07\/2023: (8+10+12+12+13+10+11) \/ 7 = <strong>10,571<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung dengan rumus kami.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena kita mengklik dan menyeret rumus ini ke setiap sel di kolom C, rumus tersebut secara otomatis diperbarui untuk menggunakan 7 hari terbaru untuk menghitung rata-rata pergerakan 7 hari.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, sel <strong>C21<\/strong> menggunakan rentang <strong>B15:B21<\/strong> untuk menghitung rata-rata pergerakan 7 hari:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37351 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour3.png\" alt=\"\" width=\"514\" height=\"504\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami harus mengetikkan rumus kami mulai dari sel <strong>C8<\/strong> karena ini mewakili tanggal pertama yang memiliki 7 hari untuk digunakan menghitung rata-rata pergerakan 7 hari.<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/rata-rata-bergerak-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Pergerakan Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-kumulatif-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Kumulatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Pergerakan Eksponensial di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam analisis deret waktu, rata-rata pergerakan 7 hari hanyalah nilai rata-rata dari 7 hari sebelum dan termasuk tanggal tertentu. Contoh berikut memperlihatkan cara menghitung rata-rata pergerakan 7 hari untuk kumpulan data di Excel. Contoh: Hitung Rata-Rata Pergerakan 7 Hari di Excel Katakanlah kita memiliki kumpulan data berikut yang menunjukkan total penjualan yang dilakukan oleh sebuah [&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>Excel: Cara menghitung rata-rata pergerakan 7 hari - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 7 hari 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\/rata-rata-pergerakan-7-hari-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung rata-rata pergerakan 7 hari - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 7 hari di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T23:43:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour1.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\/rata-rata-pergerakan-7-hari-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/\",\"name\":\"Excel: Cara menghitung rata-rata pergerakan 7 hari - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T23:43:31+00:00\",\"dateModified\":\"2023-07-07T23:43:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 7 hari di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung rata-rata pergerakan 7 hari\"}]},{\"@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":"Excel: Cara menghitung rata-rata pergerakan 7 hari - Statorial","description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 7 hari 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\/rata-rata-pergerakan-7-hari-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung rata-rata pergerakan 7 hari - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 7 hari di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T23:43:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour1.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\/rata-rata-pergerakan-7-hari-excel\/","url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/","name":"Excel: Cara menghitung rata-rata pergerakan 7 hari - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T23:43:31+00:00","dateModified":"2023-07-07T23:43:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 7 hari di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-7-hari-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung rata-rata pergerakan 7 hari"}]},{"@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\/4785"}],"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=4785"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4785\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}