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

Question

Basic Math

  • eBook

Refer to the gasoline sales time series data in the giventable.

WeekSales (1,000s of gallons)
117
221
316
424
517
618
722
820
921
1019
1116
1225
(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
117
221
316
424
517
618
722
820
921
1019
1116
1225
(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!
Become a Member

Other questions asked by students