use this excel data to do this homework y2 matches question 2 , y3 matches question 3 Problem For each of the following time series, fit a time series model, write down the model order (p,d,q) and...

use this excel data to do this homework y2 matches question 2 , y3 matches question 3
Problem
For each of the following time series, fit a time series model, write down the model order (p,d,q) and coefficients and comment on the model significance and validity.
1) Y2
2) Y3




Sheet1 Y2Y3 -29.69-3.7222112 -20.376.1134554 -9.30-1.7025334 -5.51-10.8046149 1.2233.8869621 7.38-18.9485185 4.03-59.5676487 -4.29-16.4806238 -3.05-4.2366174 -9.06-15.0814752 -15.771.0781354 -15.790.4361819 -9.001.1438088 -3.7716.9065249 0.1236.2606697 4.6236.1956989 0.07-2.9754397 -1.58-2.0697132 -2.0310.4033696 -5.187.4523843 -10.445.3878963 -10.2322.3223676 -4.8135.6902469 1.8761.2547735 0.0450.9282272 -8.1639.5597768 -9.8324.2375072 -17.53-13.5173219 -16.937.1307454 -10.0129.4816916 -11.7218.6509763 -18.0720.2282815 -20.8317.7472249 -17.9720.7475286 -14.8218.423464 -8.84-17.6266822 -7.070.6029445 -1.1033.5465183 2.1114.6601468 0.3222.1131313 1.6866.4421781 -1.3667.3991572 -4.1743.4601264 -1.3029.4250703 0.3014.4705285 -6.2211.6940157 -3.2939.4512751 4.7568.7622756 11.9168.60158 15.9267.4915261 16.8358.84033 12.5971.553916 10.9172.4081232 12.7658.4442888 14.4946.0409536 26.4642.2455265 31.5360.4503589 28.5468.2152094 31.5073.1462718 28.3354.6944506 19.2954.6883721 11.9793.9212036 6.1194.0325839 10.70106.6636994 17.86144.8753233 21.02127.3065183 20.4398.5928418 14.4492.9542963 14.7198.0712599 25.7595.3040357 35.5768.1498532 38.6752.0497892 38.50104.8484835 45.38141.9286438 49.2490.7296726 39.0273.5911646 32.71112.5013765 31.81118.8533911 35.74109.5353085 29.19143.39905 16.86152.5611886 13.08143.2615461 14.55147.2548309 15.50137.3576295 8.79151.1047799 5.66151.4026332 4.74146.7181987 0.94178.0225067 -2.14186.8232583 -0.73165.6709726 2.13195.5535382 -0.92204.4396059 -4.40202.1356321 -4.88205.5765227 -3.25186.3645285 3.58179.1612953 3.21192.8656014 -1.77193.4736492 -10.51184.3638382 -20.78 -17.24 -15.23 -22.67 -19.72 -18.67 -20.67 -5.52 4.37 14.64 29.78 41.50 50.39 49.06 44.93 42.94 35.69 30.58 29.00 28.57 33.37 45.20 47.84 46.62 48.86 54.96 51.72 41.64 38.00 36.36 32.79 31.15 25.66 14.67 12.02 18.78 24.08 15.22 26.26 33.41 19.72 18.55 19.79 29.95 35.95 37.67 31.23 25.17 25.76 26.78 21.49 19.74 24.11 21.25 17.76 20.57 30.65 35.48 35.56 43.90 51.82 48.44 41.25 27.67 19.12 25.63 31.89 32.00 37.76 40.89 35.71 35.50 27.19 19.81 22.92 24.71 20.55 16.31 20.49 24.26 22.69 17.89 14.05 18.45 14.27 10.20 12.36 8.17 7.19 11.59 14.19 24.06 35.82 42.21 38.65 34.74 38.54 41.02 44.48 44.83 48.44 53.43 48.88 51.32 50.27 44.90 40.04 24.07 18.19 23.45 20.92 13.53 17.21 26.90 29.63 34.24 49.18 64.69 62.09 53.06 51.95 54.09 57.21 56.03 44.98 35.72 34.82 40.55 40.61 41.95 41.70 31.74 21.91 9.31 4.26 10.44 3.89 3.87 11.62 8.34 6.95 4.92 2.41 0.66 2.68 12.20 15.42 11.75 7.23 1.20 -5.69 -10.28 -7.74 -7.01 -2.94 -3.30 -0.72 0.16 -8.28 -8.15 -6.91 -12.48 -16.02 -5.85 -6.20 -10.98 -6.52 -3.63 -3.40 4.82 9.42 3.14 -0.48 3.48 3.08 -5.48 -20.12 -24.25 -14.68 -7.14 0.33 5.35 9.47 6.84 1.47 -0.62 1.80 11.76 16.96 17.46 9.40 6.43 9.84 11.70 12.24 15.37 22.29 24.19 22.17 15.33 23.72 30.25 28.05 38.45 46.69 52.45 47.78 46.83 59.77 61.71 64.21 64.66 54.28 45.90 44.48 48.50 46.17 48.64 53.32 60.48 60.18 53.42 52.24 44.43 48.81 46.53 39.45 39.76 40.24 47.38 46.73 34.08 27.19 25.60 18.30 11.00 6.96 5.04 5.81 7.02 13.35 12.57 0.65 0.66 -0.85 -6.65 -4.45 0.35 4.13 5.06 6.32 8.74 10.52 12.56 18.53 22.49 22.82 24.37 26.01 21.56 20.34 18.74 22.89 28.73 27.07 19.18 9.11 13.35 12.92 17.43 20.77 27.28 38.13 43.09 35.02 32.12 36.28 30.18 31.11 34.87 27.39 11.10 13.68 21.98 23.58 30.29 28.57 27.46 37.17 38.79 40.12 42.81 36.51 36.94 48.42 50.33 47.29 45.26 43.36 45.68 42.00 37.07 32.78 28.81 31.92 29.56 28.71 32.82 25.43 24.81 34.22 32.59 19.90 17.81 18.51 18.05 26.25 34.89 49.92 59.36 64.62 66.76 62.28 56.00 51.08 53.62 48.71 46.91 53.52 50.53 45.26 42.76 47.27 46.54 44.64 48.13 49.89 49.83 40.27 30.83 20.22 2.75 -3.21 3.92 15.77 11.63 7.89 0.59 0.61 -0.32 -12.50 -12.82 -7.84 -7.96 -6.72 -3.35 1.05 2.42 -2.42 -14.36 -21.73 -19.06 -27.91 -35.76 -24.30 -11.86 -13.75 -16.56 -11.01 -10.62 -5.60 2.25 2.24 -2.78 -11.12 -17.45 -22.70 -18.60 -21.38 -18.04 -15.49 -12.79 2.52 7.01 15.04 24.64 21.43 17.95 18.44 16.02 25.78 27.58 13.48 14.08 13.53 9.13 12.41 10.75 12.13 12.60 10.30 6.81 1.53 4.21 -1.10 -9.54 -3.58 -0.37 -9.95 -4.15 -0.29 -0.85 -8.59 -25.64 -24.42 -19.03 -17.95 -7.45 2.30 7.79 1.30 -6.70 -4.75 -11.25 -8.61 -0.11 4.02 0.29 -13.91 -9.23 2.07 -0.92 -1.90 -2.46 -5.54 -5.87 -2.98 2.05 -2.33 -18.23 -24.75 -29.25 -35.89 -25.13 -23.30 -20.37 -10.08 -5.12 -9.44 -15.16 -22.71 -28.29 -31.54 -40.68 -34.36 -28.43 -27.75 -31.60 -35.24 -37.69 -35.85 -31.24 -29.66 -32.30 -30.01 -25.34 -25.58 -26.68 -28.23 -25.67 -11.09 -4.84 -13.33 -12.85 -17.84 -27.46 -19.81 -7.99 0.51 5.47 8.66 12.43 11.71 4.25 5.67 9.58 -3.26 -9.07 -11.83 -15.71 -13.18 -10.02 -10.01 -6.35 1.12 1.63 -0.90 -2.78 -5.52 -2.29 2.92 4.61 6.12 2.65 -2.57 -5.02 -1.12 -6.25 -6.87 -0.32 -1.48 -2.86 -1.15 -4.03 2.09 16.26 17.47 17.44 22.54 33.12 39.51 26.94 18.56 14.52 5.31 3.40 3.17 -1.70 -0.04 3.76 -0.63 -2.29 1.87 -7.32 -19.04 -21.37 -26.19 -33.45 -34.75 -36.66 -44.11 -51.57 -48.02 -44.08 -47.65 -48.14 -38.69 -25.46 -16.86 -9.05 -8.00 -17.44 -16.77 -10.30 -14.10 -17.49 -7.91 1.07 -3.47 -14.93 -25.28 -23.26 -11.72 5.25 13.01 16.04 24.01 16.91 5.07 6.50 24.20 25.67 23.11 22.85 15.64 7.37 -3.34 -14.81 -24.10 -27.12 -30.50 -35.40 -36.54 -34.28 -37.18 -32.77 -32.70 -36.19 -35.07 -31.31 -32.59 -40.69 -45.32 -52.54 -62.57 -68.62 -71.23 -70.25 -64.31 -65.06 -65.46 -56.29 -57.41 -65.20 -64.98 -60.59 -63.34 -59.75 -44.76 -42.80 -44.85 -46.38 -52.71 -54.75 -58.53 -56.82 -54.85 -55.00 -54.55 -54.01 -50.08 -50.39 -42.70 -36.45 -38.41 -40.34 -31.38 -22.60 -27.06 -20.00 -11.76 -13.46 -19.66 -16.43 -14.91 -10.95 -13.43 -26.19 -30.19 -29.36 -33.64 -40.01 -42.56 -37.92 -31.91 -38.60 -45.72 -38.58 -32.32 -31.31 -33.30 -40.87 -45.01 -36.72 -28.35 -24.56 -14.11 -12.83 -12.06 -9.10 -8.47 -1.95 -4.26 -9.88 -21.50 -24.44 -20.59 -18.45 -8.04 -2.36 6.42 14.44 13.23 11.00 9.58 16.20 19.56 19.83 18.04 3.09 -6.97 -12.11 -12.93 -11.66 -11.23 -8.59 -3.94 -1.59 -4.93 -14.61 -24.52 -26.61 -21.20 -15.87 -11.25 -15.30 -29.61 -34.79 -33.19 -32.30 -32.44 -28.48 -28.58 -24.29 -20.01 -21.49 -24.02 -34.43 -35.53 -39.11 -34.61 -19.25 -19.67 -24.70 -22.98 -20.35 -21.57 -22.09 -18.90 -17.45 -19.61 -21.68 -23.83 -17.64 -4.22 7.03 4.56 -2.43 5.51 18.22 24.16 25.54 25.12 31.04 31.56 32.65 32.43 27.16 24.51 13.08 12.20 14.54 11.97 13.12 9.29 3.22 1.64 -0.21 -7.98 -11.73 -8.88 -8.60 -7.45 -4.65 -1.91 -3.05 -1.14 -1.30 -12.00 -16.71 -18.42 -23.46 -20.89 -13.38 -13.52 -21.26 -29.93 -30.09 -25.14 -36.93 -49.00 -52.11 -61.13 -53.73 -37.76 -32.35 -26.71 -19.77 -12.66 -2.49 4.69 3.20 -0.10 4.91 15.96 22.12 19.37 14.69 16.72 12.91 9.44 13.22 16.27 15.53 8.79 -2.94 -3.62 4.11 4.02 -8.14 -20.11 -19.78 -12.66 -6.92 -8.58 -19.09 -16.89 -13.72 -16.42 -21.56 -20.96 -16.05 -27.91 -31.38 -22.38 -18.44 -21.13 -24.41 -23.19 -26.62 -22.87 -22.48 -23.11 -24.95 -23.21 -20.79 -25.60 -28.45 -22.71 -16.37 -17.01 -15.47 -14.93 -12.34 -13.13 -8.65 -5.75 -13.73 -16.08 -14.65 -16.94 -17.29 -11.85 -15.16 -19.68 -19.18 -7.42 -0.60 3.42 11.75 16