Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose these data show the number of gallons of gasoline sold by a gasoline distributor In Bennington, Vermont, over the past 12 weeks. Week Sales

image text in transcribed
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor In Bennington, Vermont, over the past 12 weeks. Week Sales (1,000s of gallons) 18 21 19 24 18 6 17 7 20 8 18 22 10 21 11 16 12 22 (a) Compute four-week and five-week moving averages for the time series. 4-Week 5-Week Week Time Series Moving Moving Value Average Average Forecast Forecast 18 21 19 24 18 17 20 8 18 9 22 10 21 11 16 12 22 (b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) (c) What appears to be the best number of Three weeks appears to be be data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 9.21. O Three w allest MSE. ks appear O Four we vides the largest MSE. Five week mallest MSE. Nor ge provides the smallest MSE. same MSE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Mathematics With Early Integers

Authors: Charles P McKeague

1st Edition

1936368978, 9781936368976

More Books

Students also viewed these Mathematics questions

Question

1. Too reflect on self-management

Answered: 1 week ago

Question

Food supply

Answered: 1 week ago