@Matt Macarty
#excel #forecasting
https://alphabench.com/data/excel-mov...


✅ Please SUBSCRIBE:
https://www.youtube.com/subscription_...
Forecast Moving Average Time Series Analysis

Part I of Introductory Time Series Forecasting Series

Introduction to Time Series Forecasting with Moving Averages

✅ Part II & III can be found at the links below:
Forecasting with Exponential Smoothing and Weighted moving average:
https://alphabench.com/data/excel-tim...

Testing the quality of the forecast with Theil's U:

https://alphabench.com/data/excel-the...

Introduction to time series forecasting using examples of moving average forecasting. We attempt to forecast the price of Gold using the GLD ETF as a proxy for the price of gold. Includes a discussion of commonly used error measures, mean absolute deviation (MAD), mean squared error (MSE, RMSE) and mean absolute percent error (MAPE). Error measures are used to determine how good your forecast is, in other words, they measure how far off your forecast is on average.