___ ____ ____ ____ ____ © /__ / ____/ / ____/ 17.0 ___/ / /___/ / /___/ MP—Parallel Edition Statistics and Data Science Copyright 1985-2021 StataCorp LLC StataCorp 4905 Lakeway Drive College Station, Texas 77845 USA 800-STATA-PC https://www.stata.com 979-696-4600
[email protected] Stata license: Unlimited-user 64-core network perpetual Serial number: 18461036 Licensed to: TEAM BTCR TEAM BTCR Notes: 1. Unicode is supported; see help unicode_advice. 2. More than 2 billion observations are allowed; see help obs_advice. 3. Maximum number of variables is set to 5,000; see help set_maxvar. . import excel "C:\Users\Laptop Diu\Downloads\TONG HOP.xlsx", sheet("TỔNG HỢP") firstrow (13 vars, 350 obs) . encode STOCK, gen(ID) . xtset ID YEAR Panel variable: ID (strongly balanced) Time variable: YEAR, 2018 to 2024 Delta: 1 unit . sum ROA ROE TobinSq X1DA X2SIZE X3COVID X4PROF X5TANG X6GROW X7CFOta Variable | Obs Mean Std. dev. Min Max -------------+--------------------------------------------------------- ROA | 350 .0762524 .0814312 -.2284941 .4064022 ROE | 350 .138018 .198902 -1.407505 2.341155 TobinSq | 350 1.373625 .8999534 .3173184 6.988708 X1DA | 350 .4337874 .1953917 .0297161 1.235091 X2SIZE | 350 28.06336 1.746566 25.07121 32.62542 -------------+--------------------------------------------------------- X3COVID | 350 .2857143 .4524007 0 1 X4PROF | 350 1.378198 1.065363 .0508146 7.147981 X5TANG | 350 .5296839 .504311 0 3.295183 X6GROW | 350 .0788764 .4570513 -1.132702 6.4831 X7CFOta | 350 .0629871 .1494253 -.6351002 .7187081 . pwcorr ROA ROE TobinSq X1DA X2SIZE X3COVID X4PROF X5TANG X6GROW X7CFOta | ROA ROE TobinSq X1DA X2SIZE X3COVID X4PROF -------------+--------------------------------------------------------------- ROA | 1.0000 ROE | 0.5195 1.0000 TobinSq | 0.5367 0.3070 1.0000 X1DA | -0.3694 0.0251 -0.1662 1.0000 X2SIZE | 0.0186 0.0325 0.1811 0.3258 1.0000 X3COVID | -0.0253 -0.0459 0.0403 -0.0003 -0.0134 1.0000 X4PROF | 0.2267 0.1584 0.1108 0.0704 -0.3849 -0.0134 1.0000 X5TANG | 0.1019 0.0294 0.0485 -0.1894 -0.2530 0.0164 0.1925 X6GROW | 0.0962 0.0576 -0.0563 0.1027 0.0217 -0.0608 0.1420
X7CFOta | 0.4452 0.2178 0.3436 -0.3054 -0.0611 -0.0146 0.0633 | X5TANG X6GROW X7CFOta -------------+--------------------------- X5TANG | 1.0000 X6GROW | -0.0781 1.0000 X7CFOta | 0.1760 -0.0822 1.0000 . reg ROA X1DA X2SIZE X3COVID X4PROF X5TANG X6GROW X7CFOta Source | SS df MS Number of obs = 350 -------------+---------------------------------- F(7, 342) = 30.66 Model | .892374543 7 .127482078 Prob > F = 0.0000 Residual | 1.42186127 342 .004157489 R-squared = 0.3856 -------------+---------------------------------- Adj R-squared = 0.3730 Total | 2.31423581 349 .006631048 Root MSE = .06448 ------------------------------------------------------------------------------ ROA | Coefficient Std. err. t P>|t| [95% conf. interval] -------------+---------------------------------------------------------------- X1DA | -.1670097 .0203547 -8.20 0.000 -.2070459 -.1269735 X2SIZE | .0135997 .0023544 5.78 0.000 .0089688 .0182307 X3COVID | -.0009722 .0076468 -0.13 0.899 -.0160129 .0140685 X4PROF | .0254747 .0037041 6.88 0.000 .018189 .0327604 X5TANG | -.0022507 .0072692 -0.31 0.757 -.0165488 .0120473 X6GROW | .0195041 .0077293 2.52 0.012 .004301 .0347071 X7CFOta | .1803295 .0246959 7.30 0.000 .1317544 .2289046 _cons | -.2794916 .0662226 -4.22 0.000 -.4097464 -.1492368 ------------------------------------------------------------------------------ . vif Variable | VIF 1/VIF -------------+---------------------- X2SIZE | 1.42 0.704485 X1DA | 1.33 0.753118 X4PROF | 1.31 0.764969 X7CFOta | 1.14 0.874794 X5TANG | 1.13 0.886406 X6GROW | 1.05 0.954532 X3COVID | 1.00 0.995399 -------------+---------------------- Mean VIF | 1.20 . est sto OLS . xtreg ROA X1DA X2SIZE X3COVID X4PROF X5TANG X6GROW X7CFOta, fe Fixed-effects (within) regression Number of obs = 350 Group variable: ID Number of groups = 50 R-squared: Obs per group: Within = 0.3040 min = 7 Between = 0.0589 avg = 7.0 Overall = 0.0943 max = 7 F(7,293) = 18.28 corr(u_i, Xb) = -0.5275 Prob > F = 0.0000 ------------------------------------------------------------------------------ ROA | Coefficient Std. err. t P>|t| [95% conf. interval] -------------+---------------------------------------------------------------- X1DA | -.1788229 .0283189 -6.31 0.000 -.2345571 -.1230886
X2SIZE | -.0121985 .0107579 -1.13 0.258 -.0333711 .008974 X3COVID | -.0012839 .0051301 -0.25 0.803 -.0113803 .0088125 X4PROF | .0311951 .0055365 5.63 0.000 .0202986 .0420915 X5TANG | -.0923266 .024608 -3.75 0.000 -.1407573 -.0438958 X6GROW | .0153323 .0058529 2.62 0.009 .0038132 .0268514 X7CFOta | .0663711 .0182581 3.64 0.000 .0304375 .1023048 _cons | .4970433 .3084993 1.61 0.108 -.1101121 1.104199 -------------+---------------------------------------------------------------- sigma_u | .07924546 sigma_e | .04298328 rho | .77267497 (fraction of variance due to u_i) ------------------------------------------------------------------------------ F test that all u_i=0: F(49, 293) = 9.73 Prob > F = 0.0000 . est sto FEM . xtreg ROA X1DA X2SIZE X3COVID X4PROF X5TANG X6GROW X7CFOta, re Random-effects GLS regression Number of obs = 350 Group variable: ID Number of groups = 50 R-squared: Obs per group: Within = 0.2677 min = 7 Between = 0.4129 avg = 7.0 Overall = 0.3603 max = 7 Wald chi2(7) = 151.36 corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0000 ------------------------------------------------------------------------------ ROA | Coefficient Std. err. z P>|z| [95% conf. interval] -------------+---------------------------------------------------------------- X1DA | -.1785355 .023208 -7.69 0.000 -.2240224 -.1330487 X2SIZE | .0132476 .0034399 3.85 0.000 .0065056 .0199896 X3COVID | -.0013189 .0056066 -0.24 0.814 -.0123076 .0096698 X4PROF | .0295237 .0044091 6.70 0.000 .020882 .0381654 X5TANG | -.0107434 .0107166 -1.00 0.316 -.0317475 .0102607 X6GROW | .0162171 .0060825 2.67 0.008 .0042956 .0281385 X7CFOta | .0955457 .0194214 4.92 0.000 .0574805 .1336109 _cons | -.2599926 .0979548 -2.65 0.008 -.4519805 -.0680047 -------------+---------------------------------------------------------------- sigma_u | .03149534 sigma_e | .04298328 rho | .34933967 (fraction of variance due to u_i) ------------------------------------------------------------------------------ . est sto REM . hausman FEM REM, sigmamore Note: the rank of the differenced variance matrix (6) does not equal the number of coefficients being tested (7); be sure this is what you expect, or there may be problems computing the test. Examine the output of your estimators for anything unexpected and possibly consider scaling your variables so that the coefficients are on a similar scale. ---- Coefficients ---- | (b) (B) (b-B) sqrt(diag(V_b-V_B)) | FEM REM Difference Std. err. -------------+---------------------------------------------------------------- X1DA | -.1788229 -.1785355 -.0002873 .0207302
X2SIZE | -.0121985 .0132476 -.0254461 .0113098 X3COVID | -.0012839 -.0013189 .000035 .0005866 X4PROF | .0311951 .0295237 .0016714 .004192 X5TANG | -.0923266 -.0107434 -.0815832 .0248263 X6GROW | .0153323 .0162171 -.0008848 .0020899 X7CFOta | .0663711 .0955457 -.0291746 .0050332 ------------------------------------------------------------------------------ b = Consistent under H0 and Ha; obtained from xtreg. B = Inconsistent under Ha, efficient under H0; obtained from xtreg. Test of H0: Difference in coefficients not systematic chi2(6) = (b-B)'[(V_b-V_B)^(-1)](b-B) = 63.73 Prob > chi2 = 0.0000 (V_b-V_B is not positive definite) . xtreg ROA X1DA X2SIZE X3COVID X4PROF X5TANG X6GROW X7CFOta, fe Fixed-effects (within) regression Number of obs = 350 Group variable: ID Number of groups = 50 R-squared: Obs per group: Within = 0.3040 min = 7 Between = 0.0589 avg = 7.0 Overall = 0.0943 max = 7 F(7,293) = 18.28 corr(u_i, Xb) = -0.5275 Prob > F = 0.0000 ------------------------------------------------------------------------------ ROA | Coefficient Std. err. t P>|t| [95% conf. interval] -------------+---------------------------------------------------------------- X1DA | -.1788229 .0283189 -6.31 0.000 -.2345571 -.1230886 X2SIZE | -.0121985 .0107579 -1.13 0.258 -.0333711 .008974 X3COVID | -.0012839 .0051301 -0.25 0.803 -.0113803 .0088125 X4PROF | .0311951 .0055365 5.63 0.000 .0202986 .0420915 X5TANG | -.0923266 .024608 -3.75 0.000 -.1407573 -.0438958 X6GROW | .0153323 .0058529 2.62 0.009 .0038132 .0268514 X7CFOta | .0663711 .0182581 3.64 0.000 .0304375 .1023048 _cons | .4970433 .3084993 1.61 0.108 -.1101121 1.104199 -------------+---------------------------------------------------------------- sigma_u | .07924546 sigma_e | .04298328 rho | .77267497 (fraction of variance due to u_i) ------------------------------------------------------------------------------ F test that all u_i=0: F(49, 293) = 9.73 Prob > F = 0.0000 . xttest3 Modified Wald test for groupwise heteroskedasticity in fixed effect regression model H0: sigma(i)^2 = sigma^2 for all i chi2 (50) = 8811.68 Prob>chi2 = 0.0000 . xtserial ROA X1DA X2SIZE X3COVID X4PROF X5TANG X6GROW X7CFOta Wooldridge test for autocorrelation in panel data H0: no first-order autocorrelation