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.

-1.png)
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
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
647-M-S-L-R (6260).xlsx
300 KBs Excel File
