Question
In: Other
Refer to the gasoline sales time series data in the given table.
Refer to the gasoline sales time series data in the given table.
a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.
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 =
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 MSE for the three-week moving average is 11.94.
Solutions
Expert Solution
(A) Four week moving average
Five week moving average:
(B) MSE for four week average is 13.12 while MSE for five week average is 10.63 is is calculated below
Four week average
Five week average
As MSE for 5 week average is least as 10.63 hence preferred.
Amanda K answered 2 years agoRelated Solutions
Refer to the gasoline sales time series data in the given table.
Refer to the gasoline sales time series data in the given table.
Week
Sales (1000s of gallons)
1
17
2
21
3
19
4
24
5
19
6
15
7
21
8
19
9
23
10
19
11
15
12
22
Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.
Week
Sales
4-WeekMoving Average
5-WeekMoving Average
1
17
2
21
3
19
4
24
...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
18
2
22
3
15
4
24
5
18
6
15
7
21
8
19
9
21
10
20
11
16
12
22
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
18
2
22
3
15
4
24
5
18...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
18
2
22
3
15
4
24
5
18
6
15
7
21
8
19
9
21
10
20
11
16
12
22
(a)
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
18
2
22
3
15
4
24
5...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1000s of gallons)
1
18
2
22
3
18
4
24
5
19
6
16
7
21
8
19
9
22
10
19
11
16
12
23
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
18
2
22
3
18
4
24
5
19
6
16
7
21...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
17
2
21
3
19
4
23
5
18
6
16
7
20
8
18
9
22
10
20
11
15
12
22
(a)
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
17
2
21
3
19
4
23
5...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
17
2
23
3
14
4
25
5
17
6
16
7
22
8
19
9
21
10
19
11
17
12
23
(a)
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
17
2
23
3
14
4
25
5...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
17
2
21
3
16
4
24
5
17
6
18
7
22
8
20
9
21
10
19
11
16
12
25
(a)
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
17
2
21
3
16
4
24
5...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1000s of gallons)
1
17
2
20
3
18
4
22
5
17
6
16
7
22
8
17
9
23
10
21
11
14
12
22
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
18
4
22
5
17
6
16
7
22...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
16
2
22
3
17
4
23
5
15
6
17
7
21
8
19
9
20
10
18
11
15
12
23
(a)
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
16
2
22
3
17
4
23
5...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
17
2
21
3
19
4
23
5
18
6
16
7
20
8
18
9
22
10
20
11
15
12
22
(a)
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
17
2
21
3
19
4
23
5...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Describe the principles and operations of movement sensors: Doppler-Effect Velocity sensor and Spring-Mass Accelerometor; State the...
- This is all one question, thank you so much in advance. The Bigbee Bottling Company is...
- For Questions 1-3: consider the following code: public class A { private int number; protected String...
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
ADVERTISEMENT