Reducing observations by changing the moving average window

Assignment Help International Economics

Reference no: EM1367143

Information covering the most recent thirty days are given in the following table for the value 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?

*Please show all work, use excel and identify the value and units measured.

Reference no: EM1367143

Questions Cloud

Price elasticity of demand-soft rock cafe : What price would Soft Rock have to charge to sell 2,000 T shirts? Compute the own price elasticity of demand when the price goes from $5 to $4.

Interactional model of communication theory : Analyse the situation described in Case Study using an Interactional model of Communication and discuss the strengths and limitations of this theory also explain what could have been done to prevent these communication breakdowns.

How far does tina drive before passing david : A train is travelling up a 3.73 degree incline at a speed of 3.25m/s as the last car breaks free. How far does last car travel before its speed momentarily reaches zero.

Development of personal value : I would like help in writing a paper on Development of Personal Value talk about personal values challenged and tie into pre-conventional and post conventional include when value changed and when change strengthen.

Reducing observations by changing the moving average window : Information covering the most recent thirty days are given in the following table for the value per gallon of regular gasoline at a local station.

Describing equilibrium quantity and price : Assume that the demand changes to QD = 600-2P and the supply function stays the same. Graph the new situation in Excel. Find the new equilibrium price and quantity, and show it on your graph.

Company-s interpretation of requirement of system : You have taken job with a software user who has contracted previous employer to develop a system for them. You discover that your company's interpretation of requirements is different from interpretation.

Various problems with infant health : Maternal smoking during pregnancy has been implicated in various problems with infant health.

Primary and secondary sites of the cancer : When presented with a medical record that states the patient's cancer has metastasized, what process do you use to determine the primary and secondary sites of the cancer?

User Account

All Pages