{"id":4786,"date":"2023-07-07T23:19:38","date_gmt":"2023-07-07T23:19:38","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/"},"modified":"2023-07-07T23:19:38","modified_gmt":"2023-07-07T23:19:38","slug":"rata-rata-pergerakan-3-bulan-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/","title":{"rendered":"Excel: cara menghitung rata-rata pergerakan 3 bulan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam analisis deret waktu, <strong>rata-rata pergerakan 3 bulan<\/strong> hanyalah nilai rata-rata dari 3 bulan sebelum dan termasuk bulan tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menghitung rata-rata pergerakan 3 bulan untuk kumpulan data di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Rata-Rata Pergerakan 3 Bulan di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan selama 12 bulan berturut-turut oleh sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37358 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moismove1.png\" alt=\"\" width=\"465\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung rata-rata nilai penjualan selama 3 bulan, kita dapat mengetikkan rumus berikut di sel <strong>C4<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=AVERAGE( <span style=\"color: #3366ff;\">B2:B4<\/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=\" wp-image-37359 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moismove2.png\" alt=\"\" width=\"499\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai di kolom C mewakili rata-rata pergerakan 3 bulan dari nilai di kolom penjualan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, rata-rata pergerakan penjualan 3 bulan di bulan Maret adalah <strong>25.667<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memastikan kebenarannya dengan menghitung secara manual rata-rata penjualan selama tiga bulan sebelum dan termasuk bulan ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37360 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moismove3.png\" alt=\"\" width=\"517\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata pergerakan 3 bulan. penjualan bulan Maret: (22+25+30) \/ 3 = <strong>25.667<\/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 3 bulan terbaru untuk menghitung rata-rata pergerakan setiap 3 bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, sel <b>C13<\/b> menggunakan rentang <strong>C11:C13<\/strong> untuk menghitung rata-rata pergerakan 3 bulannya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37361 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moismove4.png\" alt=\"\" width=\"528\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami harus mengetikkan rumus kami mulai dari sel <strong>C4<\/strong> karena ini mewakili tanggal pertama yang memiliki 3 bulan yang akan digunakan untuk menghitung rata-rata pergerakan 3 bulan.<\/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 3 bulan hanyalah nilai rata-rata dari 3 bulan sebelum dan termasuk bulan tertentu. Contoh berikut memperlihatkan cara menghitung rata-rata pergerakan 3 bulan untuk kumpulan data di Excel. Contoh: Menghitung Rata-Rata Pergerakan 3 Bulan di Excel Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan selama 12 [&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 3 bulan \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 3 bulan di Excel, dengan contoh lengkap.\" \/>\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-3-bulan-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 3 bulan \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 3 bulan di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T23:19:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moismove1.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-3-bulan-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/\",\"name\":\"Excel: Cara menghitung rata-rata pergerakan 3 bulan \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T23:19:38+00:00\",\"dateModified\":\"2023-07-07T23:19:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 3 bulan di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-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 3 bulan\"}]},{\"@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 3 bulan \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 3 bulan di Excel, dengan contoh lengkap.","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-3-bulan-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung rata-rata pergerakan 3 bulan \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 3 bulan di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T23:19:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moismove1.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-3-bulan-excel\/","url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/","name":"Excel: Cara menghitung rata-rata pergerakan 3 bulan \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T23:19:38+00:00","dateModified":"2023-07-07T23:19:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan 3 bulan di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-3-bulan-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 3 bulan"}]},{"@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\/4786"}],"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=4786"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4786\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}