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!




PART2


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
Get step-by-step solutions from verified subject matter experts
