Using the 5 weeks of data below determine the MSE using a 3- week moving average. Week Sales 20 40 |15 38 36 1 2 3...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. 1 Week Sales (1000s of gallons) 17 2 20 21 11 14 22 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Moving Average Moving Average Week Sales 17 9 10 11 12 17 DE 23 21 C C 14 22 b. Compute the MSE for the four-week and five-week moving average forecasts. Round...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...
observation, and 1/6 for the third most recent observation, compute a three-week weighted moving average for the time series. 2. a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent Error Forecast Sales Week 17 21 19 23 18 16 20 18 10 20 15 12 b. Compute the MSE for the weighted moving average in part (a) MSE - c. Do you prefer this weighted moving average to the unweighted moving average...
A supermarket uses a four-week moving average to predict future sales of milk. Sales data (in gallons) over the past ten weeks are shown below. Week Sales Week Sales 1 8,000 6 10,000 2 8,000 7 8,000 3 13,500 8 11,000 4 10,500 9 9,000 5 12,000 10 12,000 On the basis of these data, what would be the store’s forecast for week 11? Select one: a. 12,000 b. 11,000 c. 9,000 d. 10,000
Consider the following time series data Week 1 2 3 4 5 6 Value 19 14 16 12 18 15 a. Which of the following is a correct time series plot for this data? 1 Time eries Value 15 10 Week 2 TimeSeries Value 15 10 5 Week 4 3 TimeSeries Value 15 10 -5 Week 4 5 Select your answer What type of pattern exists in the data? What type of pattern exists in the data? Horizontal b. Develop...
Consider the following time series data. Week 1 2 3 4 5 6 Value 17 13 15 11 15 13 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Horizontal PatternTrend PatternItem 2 (b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers...
Prepare weekly forecasts for week 15 for each product using Moving Average forecasting technique using a 2 -6 period moving average. Then use error analysis or forecast accuracy techniques for the 2 - 6 period moving averages. Week Product 1 Product 2 1 50 40 2 54 38 3 57 41 4 60 46 5 64 42 6 67 41 7 90 41 8 76 47 9 79 42 10 82 43 11 85 42 12 87 49 13 92...
Please help Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...