Sitemap
DataDrivenInvestor

empowerment through data, knowledge, and expertise. Join DDI community at https://join.datadriveninvestor.com

Forecasting with Moving Averages

Part 4 of Forecasting by Hand by Dr. Alvin Ang

3 min readMay 23, 2023

--

Press enter or click to view image in full size

Moving Average (MA)

Press enter or click to view image in full size

How to Calculate Mean Absolute Deviation (MAD):

Press enter or click to view image in full size

Weighted Moving Average (WMA)

Press enter or click to view image in full size

How to Calculate Mean Absolute Deviation (MAD):

Press enter or click to view image in full size

Exponential Moving Average (EMA)

Press enter or click to view image in full size

Formula for Simple EMA

How to Calculate Mean Absolute Deviation (MAD):

Press enter or click to view image in full size

MSE vs MAD

Press enter or click to view image in full size

MA has lowest MSE and MAD.

Other Types of Fitting Error

Root Mean Squared Error (RMSE):

  • Where et : Error (= Real Value — Forecasted Value)

Mean Absolute Percentage Error (MAPE):

  • Where Y: Actual Real Value

About Dr. Alvin Ang

www.AlvinAng.sg

Dr. Alvin Ang earned his Ph.D., Masters and Bachelor degrees from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background He is a scientist, entrepreneur, as well as a personal/business advisor.

Get Dr. Alvin Ang’s stories in your inbox

Join Medium for free to get updates from this writer.

More about him at www.AlvinAng.sg.

Subscribe to DDIntel Here.

Have a unique story to share? Submit to DDIntel at https://datadriveninvestor.com/ddintelsubmission

DDIntel captures the more notable pieces from our main site and our popular DDI Medium publication. Check us out for more insightful work from our community.

Register on AItoolverse (alpha) to get 50 DDINs

Join our network here: https://datadriveninvestor.com/collaborate

DDI Official Telegram Channel: https://t.me/+tafUp6ecEys4YjQ1

Follow us on LinkedIn, Twitter, YouTube, and Facebook.

--