Order 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51...

Use Excel to fit a linear trend model to the consumer loans time series in the data file Table13-01. Use 1, 2, 3, . . . as the values for the explanatory variable with t = 1 corresponding to July 1985, etc. (a) Make a time plot of the residuals. Describe any pattern you see in this plot.(b) Does the time plot of residuals suggest positive or negative autocorrelation? Explain your response.(c) Make a lagged residual plot and calculate the correlation between successive residuals. Do we have evidence of autocorrelation?