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
- 5) Three capacitors, all initially without any dielectrics inserted, of C1 = 3 micro-farads, C2 =...
- Consider the following problem Maximize Z=2x1 + 5x2 + x3 subject to 4x1+...
- what other elements does a star burn as fuel besides hydrogen?
- Ludwig van Beethoven is considered a transitional figure in music history and he is the first...
- Here are forecasts for next year for two stocks: Stock A Stock B Return on equity...
- Why are tangible assets depreciated? Briefly described two or three depreciation methods and how they work.
- I want flowchart process for this code c++ _____________________ #include<bits/stdc++.h> using namespace std; int main() {...
ADVERTISEMENT