No video

Weighted Moving Average Forecast in Excel

  Рет қаралды 7,813

Math with Neilu

Math with Neilu

Күн бұрын

This video demonstrates how to do a weighted moving average forecast using Excel

Пікірлер: 3
@davidmcmahon8731
@davidmcmahon8731 Жыл бұрын
Thank you for this.
@nwabuezeprecious457
@nwabuezeprecious457 Жыл бұрын
Having done this what do you use the error for in terms of your forecast.
@mathwithneilu7458
@mathwithneilu7458 Жыл бұрын
The error measurements are used in multiple ways, such as checking the quality of our forecast, adjusting the weights in the forecast to improve accuracy, and ensuring we have adequate accuracy in our forecast. QUALITY: First and foremost, we want to ensure that the weighted average approach is a suitable forecast model. We can plot the errors to see if there are any patterns in the errors (we do NOT want patterns as that means we failed to predict something). If the errors appear random, good. We would also do a quantitative check for autocorrelation. ACCURACY: We can calculate a summary metric for the errors (such as RMSE, MAE, or MAPE). We can adjust the weights used in the forecast to try to get a more accurate forecast. For example, we could try weights W1 = 35%, W2 = 30%, W3 = 20% and W4 = 15% to see if it gives a lower RMSE. The weights that provide the lower RMSE would be more accurate (have less error). ENOUGH ACCURACY: The summary metric (such as RMSE, MAE, MAPE) also give us an idea of the overall accuracy of our model. We can compare the accuracy from this model to the accuracy from other models to see which model is most accurate. Alternatively, if the accuracy is insufficient, we may choose to get more data or examine additional explanatory variables to see if we can improve the accuracy.
Weighted Moving Average Example
12:23
Barry Cobb
Рет қаралды 19 М.
Forecasting in Excel Tutorial
11:23
Kevin Stratvert
Рет қаралды 288 М.
拉了好大一坨#斗罗大陆#唐三小舞#小丑
00:11
超凡蜘蛛
Рет қаралды 14 МЛН
WILL IT BURST?
00:31
Natan por Aí
Рет қаралды 28 МЛН
Parenting hacks and gadgets against mosquitoes 🦟👶
00:21
Let's GLOW!
Рет қаралды 13 МЛН
Мы сделали гигантские сухарики!  #большаяеда
00:44
Dynamic Moving Average in Excel: Mastering the AVERAGE + OFFSET Combo
5:21
PK: An Excel Expert
Рет қаралды 7 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 168 М.
Forecasting: Moving Averages, MAD, MSE, MAPE
4:52
Joshua Emmanuel
Рет қаралды 975 М.
Excel Weighted Moving Average (WMA) with Customizable Weights
8:22
Chris Menard
Рет қаралды 4,7 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 294 М.
Moving Average Time Series Forecasting with Excel
11:00
Matt Macarty
Рет қаралды 211 М.
Centered Moving Average
8:07
Gregory Green
Рет қаралды 42 М.
How To... Forecast Using Exponential Smoothing in Excel 2013
6:22
Eugene O'Loughlin
Рет қаралды 222 М.
拉了好大一坨#斗罗大陆#唐三小舞#小丑
00:11
超凡蜘蛛
Рет қаралды 14 МЛН