Question: Forecasts tab: use the data in columns A - B and apply the 4 forecasting models below in columns C - F ( yellow cells

Forecasts tab: use the data in columns A-B and apply the 4 forecasting models below in columns C-F(yellow cells). The graph will be created automatically.
3-Week-Moving-Average
3-Week-Weighted-Moving-Average [wt-1=0.5,wt-2=0.3,wt-3=0.2]
Exponential-Smoothing [alpha=0.25]
Linear-Regression
Next, complete the MAD, MSE & MAPE tabs.
MAD tab: Copy the yellow cells from the Forecasts tab into the tan cells. In columns G-J (yellow), find the absolute error for each method on each period . Finally, in row 22, calculate the MAD for each method (over the 15 rounds).
MSE tab: Copy the yellow cells from the Forecasts tab into the tan cells. In columns G-J (yellow), find the squared error for each method on each period . Finally, in row 22, calculate the MAD for each method (over the 15 rounds).
MAPE tab: Copy the yellow cells from the Forecasts tab into the tan cells. In columns G-J (yellow), find the absolute percentage error for each method on each period. Finally, in row 22, calculate the MAD for each method (over the 15 rounds).
What is the best forecasting model?
 Forecasts tab: use the data in columns A-B and apply the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!