{"id":2707,"date":"2023-07-21T02:16:37","date_gmt":"2023-07-21T02:16:37","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/"},"modified":"2023-07-21T02:16:37","modified_gmt":"2023-07-21T02:16:37","slug":"rata-rata-pergerakan-eksponensial-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/","title":{"rendered":"Cara menghitung rata-rata pergerakan eksponensial di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam analisis deret waktu, <strong>rata-rata pergerakan<\/strong> hanyalah nilai rata-rata dari sejumlah periode sebelumnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rata-rata pergerakan eksponensial<\/strong> adalah jenis rata-rata bergerak yang memberi bobot lebih pada observasi terkini, yang berarti mampu menangkap tren terkini dengan lebih cepat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung rata-rata pergerakan eksponensial di Excel<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita masuk ke kumpulan data berikut yang menunjukkan total penjualan yang dilakukan oleh sebuah perusahaan selama 10 periode penjualan berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23845 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ema1.jpg\" alt=\"\" width=\"451\" height=\"347\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung Rata-Rata Pergerakan Eksponensial<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menghitung exponential moving average (EMA) dengan menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>EMV = [Latest Value - Previous EMA] * (2\/n+1) + Previous EMA\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam rumusnya, <strong>n<\/strong> mewakili jumlah periode yang digunakan untuk menghitung rata-rata pergerakan eksponensial. Ini adalah satu-satunya nomor yang perlu Anda tentukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebagai contoh, kami akan menghitung EMA 3 hari.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita masukkan nilai EMA pada sel <strong>B2<\/strong> agar sama dengan nilai pada sel <strong>A2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23846 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ema2.jpg\" alt=\"\" width=\"445\" height=\"363\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menggunakan rumus berikut untuk menghitung nilai EMA 3 hari pertama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">A3<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )*(2\/( <span style=\"color: #800080;\">$E$1<\/span> +1))+ <span style=\"color: #ff0000;\">B2\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23847\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ema3.jpg\" alt=\"rata-rata pergerakan eksponensial di Excel\" width=\"460\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, arahkan kursor ke pojok kanan bawah sel <strong>B3<\/strong> hingga muncul tanda silang kecil \u201c <strong>+<\/strong> \u201d. Klik dua kali tanda silang untuk menyalin dan menempelkan rumus ke sel sisa kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23848 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ema4.jpg\" alt=\"\" width=\"465\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom <strong>B<\/strong> sekarang menampilkan rata-rata pergerakan penjualan eksponensial 3 hari.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung rata-rata pergerakan eksponensial menggunakan jumlah periode yang berbeda, cukup ubah nilai di sel <strong>E1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menghitung rata-rata pergerakan penjualan eksponensial 4 hari hanya dengan mengubah nilai sel <strong>E1<\/strong> menjadi 4:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23851 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ema5-1.jpg\" alt=\"\" width=\"474\" height=\"384\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom <strong>B<\/strong> sekarang menampilkan rata-rata pergerakan penjualan eksponensial 4 hari.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam analisis deret waktu, rata-rata pergerakan hanyalah nilai rata-rata dari sejumlah periode sebelumnya. Rata-rata pergerakan eksponensial adalah jenis rata-rata bergerak yang memberi bobot lebih pada observasi terkini, yang berarti mampu menangkap tren terkini dengan lebih cepat. Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung rata-rata pergerakan eksponensial di Excel Langkah 1: Masukkan datanya Pertama, [&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 Eksponensial di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan eksponensial 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-eksponensial-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 Eksponensial di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan eksponensial di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T02:16:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ema1.jpg\" \/>\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-eksponensial-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/\",\"name\":\"Cara Menghitung Rata-Rata Pergerakan Eksponensial di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T02:16:37+00:00\",\"dateModified\":\"2023-07-21T02:16:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan eksponensial di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata pergerakan eksponensial 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 Eksponensial di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan eksponensial 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-eksponensial-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-Rata Pergerakan Eksponensial di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan eksponensial di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-21T02:16:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ema1.jpg"}],"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-eksponensial-excel\/","url":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/","name":"Cara Menghitung Rata-Rata Pergerakan Eksponensial di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T02:16:37+00:00","dateModified":"2023-07-21T02:16:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan eksponensial di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-pergerakan-eksponensial-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata pergerakan eksponensial 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\/2707"}],"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=2707"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2707\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}