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?

Reviews

Write a Review

 

International Economics Questions & Answers

  Alternative trade: legacies for the future

explain how  Alternative Trade: Legacies for the Future  supports or challenges your conceptualizations of trade and development. Are there themes that some of you agree upon? Do you disagree on others? Describe your conversation.

  Consider two countries that share the same technology

Consider two Countries that share the same technology, South Africa and the UK, and two goods, Diamonds and Tea

  Find the equilibrium interest rate

The consumption function is given by C = 200 + 0.75(Y - T ). The investment function is I = 200 - 25r, r is the real interest rate. Government buy and taxes are both 100.

  Buying imports versus buying domestic products

Determine the advantages or disadvantages of buying imports versus buying domestic products in relation to fashion industry.

  Calculating economic profit

Sydney is wants to start a new business, but would have to give up a job with a total compensation of $100,000 every year. After researching the new business opportunity, Syndey created following estimates.

  Country economic and trade summary reports

Global marketing managers must understand economics and trade rules of countries and regions within which they trade.

  Burger king beefs up global operations

Burger King Beefs Up Global Operations

  Calculate the forward discount

Calculate the forward discount or Premium for the Mexican peso whose 90-day forward rate is $.102 and spot rate is $.10. State whether your answer is a discount or premium.

  Questions based on international business

Questions based on International Business

  Find best the governance system of the eu

Which political system describes best the governance system of the EU? Is the governance system of the EU democratic? Why ‘yes', or why ‘not'?

  Calculate the value of the intraindustry trade

Calculate the value of the Intraindustry Trade

  What will be the effects of an increase in the money supply

What will be the effects of an increase in the money supply

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd