Question: a. Calculate and display the first 50 autocorrelations for the four data series in the accompanying table, labeled A, B, C, and D; consider each

a. Calculate and display the first 50 autocorrelations for the four data series in the accompanying table, labeled A, B, C, and D; consider each of the four data series to be a quarterly time series. How many of the autocorrelations fall outside the 95 percent confidence interval (positive or negative)?

b. Is there a pattern to those autocorrelation coefficients falling outside the 95 percent confidence interval?

c. Calculate and display the first 50 partial autocorrelations for the 100 time-series observations. How many of the partial autocorrelation coefficients fall outside the 95 percent confidence interval?

d. Is there a pattern to those partial autocorrelation coefficients falling outside the 95 percent confidence interval?

e. Estimate the appropriate model as determined from your inspections carried out in parts a through d and forecast for four quarters into the future. Calculate the RMSE for each model.

A. Calculate and display the first 50 autocorrelations for the

A. Calculate and display the first 50 autocorrelations for the

1.02 0.70 3.84 18.39 0.72 0.74 3.60 18.98 0.79 0.52 3.43 19.50 0.77 0.26 3.43 20.21 1.18 0.21 3.69 20.85 1.26 1.06 3.85 21.69 0.81 1.27 4.20 22.69 1.05 1.63 4.05 23.56 0.63 0.98 4.33 24.65 0.71 0.98 4.76 25.92 1.02 1.13 4.79 26.87 0.79 1.30 4.69 28.07 1.22 1.61 4.65 29.63 1.01 1.31 4.49 30.41 0.43 1.20 4.91 31.42 0.27 1.26 5.01 32.66 0.41 1.32 4.59 33.49 0.94 0.85 4.62 34.23 1.42 1.13 4.83 35.00 1.22 1.24 4.86 36.27 1.31 1.08 4.53 37.07 0.67 0.85 4.44 37.25 0.22 1.32 4.74 38.10 0.50 1.53 4.54 39.51 0.64 1.75 4.13 40.20 0.41 1.11 4.22 40.27 0.40 0.80 3.97 40.68 1.13 0.41 4.29 41.19 1.06 0.93 4.22 41.58 0.31 0.66 4.34 42.23 0.67 1.29 4.85 43.33 0.68 1.11 4.39 44.27 0.72 1.16 4.74 44.89 0.58 1.52 5.09 45.41 0.74 1.28 4.83 45.69 1.14 0.76 5.21 46.39 1.42 0,74 4.74 46.96 0.94 0.53 4.90 47.34 0.59 0.44 5.06 47.61 0.32 0.92 5.29 48.21 0.68 0.57 4.90 48.77 1.40 0.33 4.90 49.17 1.52 0.99 4.80 49.85 1.20 1.24 4.88 50.55 1.33 0.77 4.46 51.55 0.69 0.48 5.09 52.20 0.30 1.16 4.56 53.06 0.49 0.62 4.37 54.46 0.43 0.83 4.20 55.70 0.95 0.62 4.65 56.51 1.50 1.11 4.3757.41 1.58 0.73 467 58.81 0.92 0.61 5.00 60.10 0.40 0.90 5.03 61.00 0.47 1.01 4.78 61.69 1.03 1.01 5.21 62.63 1.33 0.61 5.3 63.12 1.11 1.13 5.14 63.28 0.60 1.05 5.18 63.52 0.30 0.89 4.92 64.08 0.93 1.21 5.24 64.45 0.92 1.48 4.80 64.62 0.85 1.625.37 64.78 0.52 1.15 5.19 65.52 0.07 1.43 4.71 66.18 0.41 1.33 4.62 67.16 1.21 1.26 4.42 68.63 0.96 1.16 5.00 69.67 0.31 1.04 4.53 70.17 0.33 1.19 4.4470.53 0.52 1.22 4.56 71.32 0.77 0.70 4.48 71.99 0.85 0.74 4.88 72.53 1.27 0.73 4.70 72.89 1.48 1.00 4.92 73.81 1.42 1.39 4.74 74.74 1.29 1.51 4.3175.15 0.87 1.11 4.74 75.81 0.86 1.42 4.64 76.86 0.76 1.38 4.39 77.83 0.36 1.68 4.15 78.95 0.17 1.49 4.35 80.27

Step by Step Solution

3.34 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

647-M-S-L-R (6260).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!