Page 0 Oom B Compute The Mse For The Four Week And Five Week Moving Average Forecasts C What Appears To Be The 1 (85.2 KiB) Viewed 19 times
Page < 0 - OOM + b. Compute the MSE for the four-week and five-week moving average forecasts. c. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that the MSE for the three-week moving average is 10.22. 3 DATA file Gasoline Forecasting Gasoline Sales with Exponential Smoothing. With the gasoline time series data from Table 8.1, show the exponential smoothing forecasts using alpha=0.1. . a. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of alpha -0.1 or alpha -0.2 for the gasoline sales time series? b. Are the results the same if you apply MAE as the measure of accuracy? c. What are the results if MAPE is used?
AutoSave M H gasoline (3) - Excel O Search (Alt+0) File Home Insert Page Layout Formulas Data Review View Help Comments Share 2 X Times New Roman 11 = = = ~ A A Σ και 2 Wrap Text General II II 47 0 10) Paste BIU CA Sensitivity Merge Center PA Conditional Format as Cell Formatting Table Styles $ - % Insert Delete Format V do 8 Sort & Find & Filter Select Analyze Data Cipboard Undo Fort Alignment Number Styles Edita Analysis Sensitivity 64 fx D E F H 1 к к L M N 0 Р a R S т T U A B 1 Weck Sales (1000s of gallons) 2 1 17 3 2 21 4 3 3 19 5 1 23 6 5 18 7. 6 16 7 20 9 8 18 10 9 22 11 10 20 12 11 15 13 12 22 1 15 16 17 18 19 20 21 22 23 24 25 26 27 Gasoline Sales Data + Reacy F 100% Accessibility: Good to go 49°F Light rain 11:03 AM 5/4/2022
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!