Forecasting with moving average method

Assignment Help International Economics

Reference no: EM1376396

Information covering the most recent thirty days are given in the following table for the rate per gallon of regular gasoline at a local station.

Day Price Day Price
1 2.53 16 2.46
2 2.35 17 2.60
3 1.91 18 2.10
4 2.20 19 2.01
5 1.77 20 2.14
6 3.26 21 2.03
7 1.63 22 2.68
8 2.73 23 2.59
9 2.41 24 2.99
10 2.72 25 2.94
11 2.87 26 1.77
12 1.49 27 2.62
13 2.92 28 3.19
14 3.53 29 3.01
15 2.74 30 2.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-to10-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?

Reference no: EM1376396

Questions Cloud

Differences in principle of comparative & absolute advantage : Are there any similarities and differences between the principle of comparative advantage and absolute advantage?

Explain decision center leaders : Jan van der Schmidt was the organizer of a successful chain of restaurants located at Europe. He died unexpectedly at the ages of fifty-five.

Estimate the probability of a successful market : Mr. and Mrs. Smith have enjoyed sailing small boats since they were seven years old. They wish to begin a firm to produce small sailboats.

Abatement efficient level : Use a graph of the pollution abatement market, model a condition in which allocatively efficient level of abatement occurs at 100%, or equivalently where pollution is zero

Forecasting with moving average method : Information covering the most recent thirty days are given in the following table for the rate per gallon of regular gasoline at a local station.

Free trade direction of the country policy : Assume that a country declares that it is moving toward free trade through decreasing its tariffs on intermediate inputs while maintaining its tariffs on final goods.

Valuation of european call option : A European Call Option on a non dividend paying stock where the stock price is $40, strike price is $40, the risk free rate is 4 percent per year, the volatility is 30 percent per year,

Immigration of production workers : Several industrialized nations such as the U.S. attempt to seriously restrict immigration of production workers, but are more open to immigrants who are highly skilled.

Advantages of buying imports versus buying domestic products : Briefly discuss the advantages or disadvantages of buying imports versus buying domestic products in relation to the fashion industry.

User Account

All Pages