Pages Oom 7 Data File Gasoline Forecasting Gasoline Sales With Moving Averages Refer To The Gasoline Sales Time Se 1 (81.75 KiB) Viewed 22 times
Pages - OOM + 7. DATA file Gasoline Forecasting Gasoline Sales with Moving Averages. Refer to the gasoline sales time series data in Table 8.1 a. Compule four-week and five-week moving averages for the time serics. 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. 8 DATA file Gasoline Forecasting Gasoline Sales with Exponential Smoothing. With the gasoline time series data from Table 8.1, show the exponential smoothing forecasts
AutoSave M H gasoline (2) - Excel O Search (Alt+a) File Home Insert Page Layout Formulas Data Review View Help Comments Share 2 X Times New Roman 11 ~ A A = = = 2 Wrap Text General IIX LE 47 0 @ Paste BIU Sensitivity PA IDA Conditional Format as Cell Formatting Table Styles CA A Merge Center $ - % Insert Delete Format V do 8 Sort & Fird & Filter Select Analyze Data Cipboard Undo Fort Alignment Number Styles Edita Analysis Sensitivity [4 fx D E F Н. H 1 к к L M N 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 Accessibility: Good to go F 100% 51°F Cloudy 10:42 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!