A examine your y data excluding the hold out period to

Reference no: EM13374879

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: EM13374879

Questions Cloud

Questionmotorists have a choice between a petrol fuelled : questionmotorists have a choice between a petrol fuelled vehicle and a diesel equivalent which have different fixed and

1 capm numerical exercise consider the following three : 1. capm numerical exercise consider the following three assetswrite a computer program for example using matlab to

1 a bond with a 5 percent coupon 50 a year that matures : 1. a bond with a 5 percent coupon 50 a year that matures after eight years is selling for 779. what is the yield to

1 if the four-firm concentration ratio of an industry is 75 : 1. if the four-firm concentration ratio of an industry is 75 what does it mean?2. industry a is composed of five large

A examine your y data excluding the hold out period to : a examine your y data excluding the hold out period to determine if it needs to be differenced to make it stationary.

1 the following equations describe a particular : 1. the following equations describe a particular macroeconomic systemc 100000 .85yi 85000g 15000assume to start

Exercise 1a long time ago in a galaxy far far away the long : exercise 1a long time ago in a galaxy far far away the long run yearly demand and supply of moisture were qd 28 - p5

1 the demand function for a cola-type soft drink in general : 1. the demand function for a cola-type soft drink in general is q 20 - 2p where q stands for quantity and p stands for

Q1 consider the following macro modelwhere y p and m are : q1. consider the following macro modelwhere y p and m are the logs of real output prices and the money supply

User Account

All Pages