Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 17 2 20 3 19 4 24
Refer to the gasoline sales time series data in the given table.
Week | Sales (1000s of gallons) |
1 | 17 |
2 | 20 |
3 | 19 |
4 | 24 |
5 | 17 |
6 | 15 |
7 | 21 |
8 | 17 |
9 | 23 |
10 | 21 |
11 | 15 |
12 | 22 |
A. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.
Week | Sales | 4-Week Moving Average | 5-Week Moving Average |
1 | 17 | ||
2 | 20 | ||
3 | 19 | ||
4 | 24 | ||
5 | 17 | ||
6 | 15 | ||
7 | 21 | ||
8 | 17 | ||
9 | 23 | ||
10 | 21 | ||
11 | 15 | ||
12 | 22 |
B. Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started