Question: Please answer all thank you! PART2 Consider the following time series data. b) Develop a three-week moving average for this time series. Compute MSE and

Please answer all thank you!

Please answer all thank you! PART2 Consider the following time series data.b) Develop a three-week moving average for this time series. Compute MSEand a forecast for week 7 . Do not round intermediate calculations.If required, round your answers to two decimal places. MSE: The forecast

PART2

for week 7 : (c) Use a=0.2 to compute the exponential smoothingvalues for the time series. Compute MSE and a forecast for week

Consider the following time series data. b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7 . Do not round intermediate calculations. If required, round your answers to two decimal places. MSE: The forecast for week 7 : (c) Use a=0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7 . Do not round intermediate calculations. If required, round your answers to two decimal places. MSE: The forecast for week 7 : e) Use trial and error to find a value of the exponential smoothing coefficient a that yields the minimum MSE. Do not round intermediate calculations. Use a two-decimal digit precision for the exponential smoothing coefficient. alpha: (a) Show the exponential smoothing forecasts using a=0.1, and a=0.2. (b) Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of a=0.1 or a=0.2 for the gasoline sales time series? An smoothing constant provides the more accurate forecast, with an overall MSE of 3. (c) Are the results the same if you apply MAE as the measure of accuracy? An smoothing constant provides the more accurate forecast, with an overall MAE of (d) What are the results if MAPE is used? An smoothing constant provides the more accurate forecast, with an overall MAPE of

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!