eBook
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...
70.2K
Verified Solution
Link Copied!
Question
Basic Math
eBook
Refer to the gasoline sales time series data in the giventable.
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 timeseries.
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
17
6
18
7
22
8
20
9
21
10
19
11
16
12
25
(b)
Compute the MSE for the four-week and five-week moving averageforecasts.
If required, round your final answers to three decimalplaces.
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?Consider that the MSE for the three-week moving average is12.852.
Answer & Explanation
Solved by verified expert
4.4 Ratings (1068 Votes)
a Compute fourweek moving averageCompute fiveweek moving averages for the time
See Answer
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
