{"id":4787,"date":"2023-07-07T23:07:22","date_gmt":"2023-07-07T23:07:22","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/"},"modified":"2023-07-07T23:07:22","modified_gmt":"2023-07-07T23:07:22","slug":"rata-rata-pergerakan-pusat-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/","title":{"rendered":"Cara menghitung rata-rata pergerakan terpusat di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam analisis deret waktu, <strong>rata-rata pergerakan terpusat<\/strong> adalah rata-rata pergerakan sejumlah nilai, <em>yang dipusatkan<\/em> pada periode tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menghitung rata-rata pergerakan terpusat untuk kumpulan data di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Menghitung Rata-Rata Pergerakan Terpusat 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;\">Katakanlah kita ingin menghitung rata-rata pergerakan nilai penjualan terpusat selama 3 bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C3<\/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=\"aligncenter wp-image-37366\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/centre1.png\" alt=\"rata-rata bergerak terpusat di Excel\" width=\"501\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai di kolom C mewakili rata-rata pergerakan terpusat 3 bulan dari nilai di kolom penjualan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, rata-rata pergerakan penjualan terpusat 3 bulan di bulan Februari adalah <strong>25.667<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya menggunakan nilai penjualan bulan Januari, Februari, dan Maret untuk menghitung rata-rata berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37367 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/centre2.png\" alt=\"\" width=\"567\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata pergerakan berpusat pada 3 bulan. penjualan bulan Februari: (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;\">Kita juga dapat menggunakan jumlah bulan yang berbeda untuk menghitung nilai rata-rata pergerakan terpusat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat mengetikkan rumus berikut di sel <strong>C4<\/strong> untuk menghitung rata-rata pergerakan penjualan terpusat dalam 5 bulan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=AVERAGE( <span style=\"color: #3366ff;\">B2:B6<\/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-37368 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/centre3.png\" alt=\"\" width=\"536\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai-nilai di kolom C sekarang mewakili rata-rata pergerakan terpusat 5 bulan dari nilai-nilai di kolom penjualan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, rata-rata pergerakan penjualan terpusat 5 bulan di bulan Maret adalah <strong>28<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya menggunakan nilai penjualan bulan Januari, Februari, Maret, April dan Mei untuk menghitung rata-rata berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata pergerakan berpusat pada 5 bulan. Penjualan di bulan Maret: (22+25+30+34+29) \/ 5 = <strong>28<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung dengan rumus kami.<\/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 terpusat adalah rata-rata pergerakan sejumlah nilai, yang dipusatkan pada periode tertentu. Contoh berikut memperlihatkan cara menghitung rata-rata pergerakan terpusat untuk kumpulan data di Excel. Contoh: Cara Menghitung Rata-Rata Pergerakan Terpusat di Excel Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan selama 12 bulan berturut-turut oleh [&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 Rata-Rata Pergerakan Terpusat di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan terpusat 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-pusat-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rata-Rata Pergerakan Terpusat di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan terpusat di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T23:07:22+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-pusat-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/\",\"name\":\"Cara Menghitung Rata-Rata Pergerakan Terpusat di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T23:07:22+00:00\",\"dateModified\":\"2023-07-07T23:07:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan terpusat di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata pergerakan terpusat 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 Rata-Rata Pergerakan Terpusat di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan terpusat 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-pusat-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-Rata Pergerakan Terpusat di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan terpusat di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T23:07:22+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-pusat-excel\/","url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/","name":"Cara Menghitung Rata-Rata Pergerakan Terpusat di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T23:07:22+00:00","dateModified":"2023-07-07T23:07:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan terpusat di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-pusat-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata pergerakan terpusat 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\/4787"}],"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=4787"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4787\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}