Page: 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
Business Forecasting;Using the United Kingdom statistics locates Banks consumer credit: Gross lending figures from 1993-2003
84 84 84 83 82
LAGS(DATA,13) Pearson Correlation .940** .972** .934** .951** .964** .948** 1 .947**
Sig. (2-tailed) .000 .000 .000 .000 .000 .000 . .000
N 83 83 83 83 83 83 83 82
LAGS(DATA,14) Pearson Correlation .954** .938** .958** .933** .939** .945** .947** 1
Sig. (2-tailed) .000 .000 .000 .000 .000 .000 .000 .
N 82 82 82 82 82 82 82 82
** Correlation is significant at the 0.01 level (2-tailed).
From the correlation between the data and lagged data, these are all high and then we need to use regression on the chosen columns to find the relationship.
Variables Entered/Removed
Model Variables Entered Variables Removed Method
1 LAGS(DATA,14), LAGS(DATA,4), LAGS(DATA,10), LAGS(DATA,12), LAGS(DATA,3), LAGS(DATA,1), LAGS(DATA,13) . Enter
a All requested variables entered.
b Dependent Variable: DATA
Model Summary
Model R R Square Adjusted R Square Std. Error of the Estimate
1 0.980 0.961 0.957 448.91311
a