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
|
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.
|