I want to investigate whether, my dependent variable, i.e. Stress score follows any linear or quadratic time trend, by including c.year and then c.year##c.year, respectively. With linear time trend, the coefficient of timevar turned out to be insignificant. However, with quadratic time trend, the variable c.year##c.year was omitted citing multicollinearity as reason.
Code:
. xtreg STRESS_SCORE LN_ASSETS RISK_LEV GNPA PCR NIM NONINT_INC CONT_LIAB OP_EFF GDP_GR GSEC_YLD WTAVG_CMR STABILITY C
> P_INFL USDINR_EXC c.Year##c.Year , re
note: c.Year#c.Year omitted because of collinearity.
Random-effects GLS regression Number of obs = 681
Group variable: BankID Number of groups = 39
R-squared: Obs per group:
Within = 0.5699 min = 15
Between = 0.6987 avg = 17.5
Overall = 0.6530 max = 18
Wald chi2(15) = 920.17
corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0000
-------------------------------------------------------------------------------
STRESS_SCORE | Coefficient Std. err. z P>|z| [95% conf. interval]
--------------+----------------------------------------------------------------
LN_ASSETS | 852.2561 170.0258 5.01 0.000 519.0116 1185.501
RISK_LEV | 27.7547 19.36566 1.43 0.152 -10.20129 65.71068
GNPA | 12.03832 18.77313 0.64 0.521 -24.75635 48.83298
PCR | -4.035505 4.591998 -0.88 0.380 -13.03566 4.964646
NIM | -906.5539 215.4158 -4.21 0.000 -1328.761 -484.3466
NONINT_INC | -748.1694 245.9966 -3.04 0.002 -1230.314 -266.0249
CONT_LIAB | .0054839 .0003396 16.15 0.000 .0048183 .0061496
OP_EFF | 479.4029 237.4127 2.02 0.043 14.08257 944.7232
GDP_GR | -64.94529 24.15464 -2.69 0.007 -112.2875 -17.60307
GSEC_YLD | 115.9559 260.1435 0.45 0.656 -393.9159 625.8278
WTAVG_CMR | 6.902367 116.1757 0.06 0.953 -220.7978 234.6026
STABILITY | .5993533 3.522829 0.17 0.865 -6.305264 7.503971
CP_INFL | -2.546553 49.51693 -0.05 0.959 -99.59795 94.50484
USDINR_EXC | 57.17443 26.12808 2.19 0.029 5.964339 108.3845
Year | -113.7963 62.55224 -1.82 0.069 -236.3965 8.803796
|
c.Year#c.Year | 0 (omitted)
|
_cons | 219487.2 123282.9 1.78 0.075 -22142.84 461117.2
--------------+----------------------------------------------------------------
sigma_u | 1586.1843
sigma_e | 1520.6156
rho | .5210955 (fraction of variance due to u_i)
-------------------------------------------------------------------------------Afterwards, I came across posts which mentioned, "if you don't expect a time trend so much as just haphazard shocks to outcome from year to year, then add i.time to the list of dependent variables". Further, in field like Finance, most of the time the shock is haphazard rather than following a time trend. Both these statements are attributed to Clyde Schechter. Assuming, my dependent variable, banking stress to be the outcome haphazard shocks to bank-specific and macroeconomic parameters, I re-ran my model by including i.year as one of the independent variable, as follows.
Code:
. xtreg STRESS_SCORE LN_ASSETS RISK_LEV GNPA PCR NIM NONINT_INC CONT_LIAB OP_EFF GDP_GR GSEC_YLD WTAVG_CMR STABILITY C
> P_INFL USDINR_EXC i.Year, re
note: 2017.Year omitted because of collinearity.
note: 2018.Year omitted because of collinearity.
note: 2019.Year omitted because of collinearity.
note: 2020.Year omitted because of collinearity.
note: 2021.Year omitted because of collinearity.
note: 2022.Year omitted because of collinearity.
Random-effects GLS regression Number of obs = 681
Group variable: BankID Number of groups = 39
R-squared: Obs per group:
Within = 0.5756 min = 15
Between = 0.6998 avg = 17.5
Overall = 0.6552 max = 18
Wald chi2(25) = 925.79
corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0000
------------------------------------------------------------------------------
STRESS_SCORE | Coefficient Std. err. z P>|z| [95% conf. interval]
-------------+----------------------------------------------------------------
LN_ASSETS | 824.5139 171.8609 4.80 0.000 487.6728 1161.355
RISK_LEV | 34.37259 19.7128 1.74 0.081 -4.263789 73.00897
GNPA | 2.299177 20.09347 0.11 0.909 -37.08329 41.68165
PCR | -1.816186 4.874106 -0.37 0.709 -11.36926 7.736886
NIM | -915.265 228.8066 -4.00 0.000 -1363.718 -466.8124
NONINT_INC | -696.9691 251.4479 -2.77 0.006 -1189.798 -204.1403
CONT_LIAB | .0055769 .0003431 16.25 0.000 .0049043 .0062494
OP_EFF | 426.0327 246.092 1.73 0.083 -56.29879 908.3643
GDP_GR | -82.44671 31.5042 -2.62 0.009 -144.1938 -20.69962
GSEC_YLD | 335.9414 884.0082 0.38 0.704 -1396.683 2068.566
WTAVG_CMR | 204.2107 270.3801 0.76 0.450 -325.7246 734.146
STABILITY | 15.96176 34.55709 0.46 0.644 -51.76889 83.69242
CP_INFL | 265.7651 459.0772 0.58 0.563 -634.0097 1165.54
USDINR_EXC | -42.01288 48.95287 -0.86 0.391 -137.9587 53.93299
|
Year |
2006 | -584.4236 930.4732 -0.63 0.530 -2408.118 1239.27
2007 | -2037.475 2191.599 -0.93 0.353 -6332.929 2257.98
2008 | -2400.557 2484.468 -0.97 0.334 -7270.025 2468.911
2009 | -4409.829 4150.43 -1.06 0.288 -12544.52 3724.864
2010 | -3285.549 4798.677 -0.68 0.494 -12690.78 6119.686
2011 | -3744.712 4577.124 -0.82 0.413 -12715.71 5226.287
2012 | -5108.068 5756.694 -0.89 0.375 -16390.98 6174.845
2013 | -4399.575 4948.135 -0.89 0.374 -14097.74 5298.591
2014 | -3247.508 3938.395 -0.82 0.410 -10966.62 4471.604
2015 | -1828.772 2342.686 -0.78 0.435 -6420.353 2762.809
2016 | -706.4356 979.0437 -0.72 0.471 -2625.326 1212.455
2017 | 0 (omitted)
2018 | 0 (omitted)
2019 | 0 (omitted)
2020 | 0 (omitted)
2021 | 0 (omitted)
2022 | 0 (omitted)
|
_cons | -7901.26 5665.685 -1.39 0.163 -19005.8 3203.279
-------------+----------------------------------------------------------------
sigma_u | 1586.0957
sigma_e | 1522.2238
rho | .52054002 (fraction of variance due to u_i)
------------------------------------------------------------------------------iii) Even though my time period begins from 2005, why it is not included in the result ?
Any help/ insight would be sincerely appreciated.
Warm regards
pankaj
0 Response to Time trend in Random Effects panel data model
Post a Comment