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
- We are evaluating a project that costs $868,000, has a life of eight years, and has...
- a.) Given sample data: 61.2, 61.9, 62.8, 63.1, 64.0, 64.3, 64.9, 65.5, 66.3 and 67.9, test...
- A research paper describes an experiment in which 74 men were assigned at random to one...
- 1. Which components would a retail organization consider while surveying/assessing the suitability of its products for...
- Design and inplement a synchronous counter that counts.
- Another common second-order R-K method is Ralston’s method. For this method, a2=2/3. Derive expressions for a1,...
- Venus Cellular Limited (“Venus”) is the leading, worldwide provider of a wide variety of telecommunications equipment...
ADVERTISEMENT