1) Consider the data on quarterly housing starts given in a Table 1 (page 2). a. Compute the missing values for the uncentred and centred 4-point moving average columns of the table. b. Plot the time series, Yt and the centred 4-point moving average on the same graph. Comment on the smoothing achieved by the moving average. (Please produce this graph in excel.) Table 1: Year Quarter Housing 4-Quarter Starts Moving (thousands of|Average dwellings) I 218.7 Centred 4-Quarter Moving Average M 1980 II 269.7 297.78 III 341.4 300.36 302.93 IV 361.3 1981 I 239.3 283.63 II 300.4 261.42 239.20 III 233.5 229.97 220.73 IV 183.6 214.13 1982 I 165.4 220.48 226.83 II 274.0 239.66 252.48 III 284.3 IV 286.2 327.43 1983 I 295.5 347.82 368.20 II 443.7 379.07 389.93 III 447.4 402.90 IV 373.1 1984 I 347.4 407.83 II 492.4 401.90 III 418.4 399.24 396.58 IV 349.4 398.68 400.78 1985 I 326.1 412.75 II 509.2 III 466.3 1) Consider the data on quarterly housing starts given in a Table 1 (page 2). a. Compute the missing values for the uncentred and centred 4-point moving average columns of the table. b. Plot the time series, Yt and the centred 4-point moving average on the same graph. Comment on the smoothing achieved by the moving average. (Please produce this graph in excel.) Table 1: Year Quarter Housing 4-Quarter Starts Moving (thousands of|Average dwellings) I 218.7 Centred 4-Quarter Moving Average M 1980 II 269.7 297.78 III 341.4 300.36 302.93 IV 361.3 1981 I 239.3 283.63 II 300.4 261.42 239.20 III 233.5 229.97 220.73 IV 183.6 214.13 1982 I 165.4 220.48 226.83 II 274.0 239.66 252.48 III 284.3 IV 286.2 327.43 1983 I 295.5 347.82 368.20 II 443.7 379.07 389.93 III 447.4 402.90 IV 373.1 1984 I 347.4 407.83 II 492.4 401.90 III 418.4 399.24 396.58 IV 349.4 398.68 400.78 1985 I 326.1 412.75 II 509.2 III 466.3