Question: Data covering the most recent 3 0 days are given in the following table for the price per gallon of regular gasoline at a local

Data covering the most recent 30 days are given in the following table for the price per gallon of regular gasoline at a local station.
Day Price Day Price
12.53162.46
22.35172.60
31.91182.10
42.20192.01
51.77202.14
63.26212.03
71.63222.68
82.73232.59
92.41242.99
102.72252.94
112.87261.77
121.49272.62
132.92283.19
143.53293.01
152.74302.10
a.Compute a forecast for the next day's price by using a 3-day moving average. What is the forecast? What is the MSE for the last five observations?
b.Can you reduce the MSE for the last five observations by changing the moving-average window? (Try 4- to 10-day windows.)
c. Compute a forecast for the next day's price by using exponential smoothing with a =0.25. What is the forecast? What is the MSE for the last five
observations?
d.Can you improve the MSE for the last five observations by changing the smoothing constant a?
Data covering the most recent 3 0 days are given

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!