Calculate the hold out period mse

Assignment Help Microeconomics
Reference no: EM13124299

a) Examine your Y data (excluding the hold out period) to determine if it needs to be differenced to make it stationary. Show a time series plot of the raw Y data and autocorrelation functions (ACFs).

b) From your time series data plot and AFCs determine if you have seasonality. If you do, use seasonal differences to remove it and run the ACFs and PACFs on the non seasonal Y data series.

c) Fill out the ARIMA seasonal menu (P,D,Q) appropriately. If you have no trend as shown by the seasonally differenced ACFs run the ARIMA model and note the significance of each coefficient. Make model adjustments accordingly to improve results.
Note: You maynotuse an ARIMA model with non significant coefficients to forecast. If the coeffcients are not signficant derive another model that has signficant coefficents and the lowest residual MS value.

d) If it requires differencing for trendto make it stationary do so and run another time series plot and ACFs on the differenced data. If this requires differencing again do so but run time series plots and ACFs each time you do.

e) Run and show the PACFs on your stationary data series and identify the appropriate ARIMA model and show the initial ARIMA non seasonal menu section(p,d,q) filled out appropriately and any seasonal (P,D,Q) components in the seasonal menu filled out.Explain

f) Run the ARIMA model and note the significance of each coefficient. Make model adjustments accordingly to improve results shown by the residual MS or MSE.Explain

g) Calculate the two error measures that you used in other model analysis and comment on the acceptability of the size of the measure.

h) Note the LBQ associated P values for the selected lags. They should each be significant (above .05) to declare the residuals random. If they are not random select an alternative ARIMA model form that has random residuals.

i) Run an ARIMA forecast for your hold out period and show a time series plot of the residuals (Y actual and Y forecast) for the hold out period.

j) Calculate the hold out period MSE, RMSE and MAPE (Refer back to earlier chapters for the error measure formulas) and compare them to the Fit period ARIMA error measures (from g above). Explain


Attachment:- Data.xlsx

Reference no: EM13124299

Questions Cloud

What is the molecular weight of the unknown acid hz : A 0.456 gram sample of an unknown monoprotic acid (lets call it HZ) was dissolved in some water . Then the acidic solution was titrated to the equivalence point with 32.5 mL of 0.174 M KOH.
Forgiveness is one way to positively manage conflict : Conflict within relationships is inevitable, but approaches to handling conflict can be positive or negative. Forgiveness is one way to positively manage conflict.
Solve s is a ring homomorphism : Show that if @:R -> S is a ring homomorphism, then the ker(@) is an ideal of R and that @ is injective if.
Discuss the strategic implications : Discuss what these traditional financial statements do well as well as the limitations of these financial statements for valuing information/knowledge age companies.
Calculate the hold out period mse : Examine your Y data (excluding the hold out period) to determine if it needs to be differenced to make it stationary. Show a time series plot of the raw Y data and autocorrelation functions (ACFs).
Company reported income : Wenger Company reported income before taxes of $600,000 and an extraordinary loss of $150,000. Assume that the company's tax rate is 30%. What amounts will be reported on the income statement for income before irregular items and extraordinary ite..
Illustrate what amount of gain or loss does michelle : Illustrate what amount of gain or loss does Michelle recognize in the complete liquidation and what is her tax basis in the building and land after the complete liquidation?
What is the amount of the taxable gift for federal gift tax : Assume for 2011 that Don made one transfer involving his granddaughter as follows: Don opened a joint checking account with his granddaughter, with right of survivorship, for her college expenses.
Characteristic polynomial of matrix : When we need to find eigenvalues and eigenvectors in algebra, we start by finding the characteristic polynomial of a matrix. In this problem, we will find the characteristic polynomial of a matrix, A.

Reviews

Write a Review

 

Microeconomics Questions & Answers

  What is the firm inverse demand function

Assume you're the manager of Alpha Enterprises, a firm that holds the patent that makes it the exclusive manufacturer of bubble memory chips. Based on the estimates provided by the consultant

  Question about national debt

About the topic of national debt, it just likes we lent money from our offspring. Most of us think the debt is bad.

  Price charged to local versus out of town visitors

Explain why the relationship between the prices charged to locals versus the prices charged to out of town visitors? Why does this happen?

  Develop production from the opportunity

Demonstrate that the expression on the right in fact represents the sum of the series on the left, Draw an appropriate cash flow diagram and indicate the formulas and factors used to evaluate the cash flow diagram

  Future economic glowth

Future economic glowth

  Define depository institution

Define depository institution, and discuss types of depository institutions are found in the U.S. and how do they act as intermediaries between savers and borrowers?

  Determine the pattern of production and trade

In our treatment of the Ricardian model We have focused on the case of trade involving only two nations. Assume that there are many nations capable of producing two goods

  Elaborate the logic of economics

What do we mean when we refer to basic economic difficulties of what to manufacture, how to manufacture, and for whom to manufacture?

  How big will that budget have to spend

How big will that budget have to be before he would spend a $1 buying a first cup of coffee?

  Description of cash flow analysis

Evaluate the cash flow for each year relevant to the analysis. Make a table of cash flows, by year. Compute the net present value of the proposed outpatient clinic. Should the administrator recommend the hospital's trustees that the clinic be built? ..

  Regulation of monopolies and potential monopolies

Why is the government so quick to regulate monopolies and potential monopolies? What are the major concerns and evils that arise from this market structure?

  Relatively price elastic or relatively price inelastic

Identify and enumerate the factors affecting the supply, demand, and price for the company's products and examine whether the demand for the company's products is relatively price elastic or relatively price inelastic and explain why.

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