Question: Help! I do not know how to do a= 0.2. Please show me how to do it in excel. Thank you for your help. (b)

Help! I do not know how to do a= 0.2. Please showHelp! I do not know how to do a= 0.2. Please show me how to do it in excel. Thank you for your help.

(b) Compare the three-month moving average forecast with the exponential smoothing forecast using a = 0.2. (Round your answers to two decimal places.) Month Time Series Value (in $ millions) 3-Month Moving Average Forecast (in $ millions) a = 0.2 Forecast (in $ millions) 1 240 2 360 3 230 4 260 276.67 5 290 283.33 6 330 260.00 7 210 293.33 8 310 276.67 9 250 283.33 10 310 256.67 11 230 290.00 12 240 263.33

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!