Excel Weighted Moving Average (WMA) with Customizable Weights

A Weighted Moving Average (WMA) assigns more weight to recent data and less weight to past data. You can use a weighted moving average for any numeric data - stock prices, revenue, orders, support calls, temperature, and profit. A weighted moving average will follow data more closely than a Simple Moving Average (SMA). For example, if you are using an SMA and looking at the last 12 months, say January through December, December should have more weight than June, and June should have more weight than January. The weight decreases with each previous data point. The data points could be days, weeks, months, or years. You decide how many data points to move. In my video, I did 5 days, but I could have done 3 days or however many days I wanted to follow.
Chapters:
00:00 Introduction
00:41 What is a Weighted Moving Average?
01:46 Simple Moving Average
02:33 Weighted Moving Average
04:29 Add changeable weights
07:15 Example file
07:44 Closing remarks
Terms and abbreviations:
WMA - Weighted Moving Average
SMA - Simple Moving Average
Chris Menard Simple Moving Average video
• Excel Moving Average w...
Article from Fidelity Investment on WMA
www.fidelity.com/learning-cen...
#msexcel #exceltraining #chrismenardtraining #chrismenard #microsoftexcel
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ TH-cam keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
#weightedaverage #movingaverage #excel

[@Haashimnhimoh1234]

How to use this method for 12-month forecasting? Like you have data for Jan-Dec. 2023 and wanted to forecast Jan-Dec. 2024?