Saturday January 1 00:18:27 Page 1

2000
(R)
/ / / / /
/ / / / / / /
Statistics/Data Analysis

(R)
/ / / / /
/ / / / / / / 16.0 Copyright 1985-2019 StataCorp LLC
Statistics/Data Analysis StataCorp
4905 Lakeway Drive
MP - Parallel Edition College Station, Texas 77845 USA
800-STATA-PC http://www.stata.com
979-696-4600 [email protected]
979-696-4601 (fax)

Single-user 2-core Stata network license expires 20 Aug

2019: Serial number: 501609213901
Licensed to: Olah Data Semarang 085227746673
Olah Data Semarang 085227746673

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 5000; see help set_maxvar .

1 . import excel "D:\SKRIPSI\SKRIPSI EKONOMI\ANGRRAINI OLAH DATA\DATA PANEL.xlsx", sheet("Sheet1") firstr

> ow
(8 vars, 78 obs)

2 . regress IS PBV SIZE GROWTH Leverage RA

Source SS df MS Number of obs = 78

F(5, 72) = 2.53
Model 618450.999 5 123690.2 Prob > F = 0.0365
Residual 3524102.32 72 48945.8655 R-squared = 0.1493
Adj R-squared = 0.0902
Total 4142553.32 77 53799.3937 Root MSE = 221.24

IS Coef. Std. Err. t P>|t| [95% Conf. Interval]

PBV -.1736301 .0666251 -2.61 0.011 -.3064449 -.0408153

SIZE 11.58834 7.597734 1.53 0.132 -3.557466 26.73414
GROWTH 2.500881 3.650595 0.69 0.496 -4.776447 9.778209
Leverage 104.2754 146.9459 0.71 0.480 -188.656 397.2067
RA 3.088813 62.06921 0.05 0.960 -120.6439 126.8215
_cons -246.1256 191.3124 -1.29 0.202 -627.4998 135.2486

3 . summarize IS PBV SIZE GROWTH Leverage RA

Variable Obs Mean Std. Dev. Min Max

IS 78 -8.34368 231.947 -1959.817 293.9898

PBV 78 326.0901 379.0307 12.49386 1727.272
SIZE 78 20.66965 3.979404 12.98733 28.98203
GROWTH 78 1.093356 7.178934 -1 63.02037
Leverage 78 .4844488 .1877212 .1060811 .9225345

RA 78 .525641 .5025741 0 1
4 . winsor2 IS PBV SIZE GROWTH Leverage RA, suffix(_w) cuts(1 78) by( Tahun)
command winsor2 is unrecognized
r(199);

5 . xtset Perusahaan Tahun

panel variable: Perusahaan (strongly balanced)
time variable: Tahun, 2017 to 2019
delta: 1 unit

6 .
7 . xtreg IS PBV SIZE GROWTH Leverage RA, fe

Fixed-effects (within) regression Number of obs = 78

Group variable: Perusahaan Number of groups = 26

R-sq: Obs per

within = 0.0313 group: min = 3
between = 0.0011 avg = 3.0
overall = 0.0017 max = 3

F(5,47) = 0.30
corr(u_i, Xb) = -0.4674 Prob > F = 0.9080

IS Coef. Std. Err. t P>|t| [95% Conf. Interval]

PBV -.1529902 .1549416 -0.99 0.328 -.4646924 .158712

SIZE -13.5285 213.9515 -0.06 0.950 -443.9434 416.8864
GROWTH 1.676912 4.814524 0.35 0.729 -8.00866 11.36249
Leverage -75.85552 771.896 -0.10 0.922 -1628.71 1476.999
RA 6.038784 294.493 0.02 0.984 -586.4047 598.4822
_cons 352.9147 4342.571 0.08 0.936 -8383.211 9089.04

sigma_u 158.03597
sigma_e 238.41002
rho .30526747 (fraction of variance due to u_i)

F test that all u_i=0: F(25, 47) = 0.60 Prob > F = 0.9146

8 . xtreg IS PBV SIZE GROWTH Leverage RA, re sa

Random-effects GLS regression Number of obs = 78

Group variable: Perusahaan Number of groups = 26

R-sq: Obs per

within = 0.0297 group: min = 3
between = 0.3923 avg = 3.0
overall = 0.1493 max = 3

Wald chi2(5) = 12.64

corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0270

IS Coef. Std. Err. z P>|z| [95% Conf. Interval]

PBV -.1736301 .0666251 -2.61 0.009 -.304213 -.0430473

SIZE 11.58834 7.597734 1.53 0.127 -3.302945 26.47962
GROWTH 2.500881 3.650595 0.69 0.493 -4.654153 9.655915
Leverage 104.2754 146.9459 0.71 0.478 -183.7333 392.2841
RA 3.088813 62.06921 0.05 0.960 -118.5646 124.7422
_cons -246.1256 191.3124 -1.29 0.198 -621.0909 128.8397

sigma_u 0
sigma_e 238.41002
rho 0 (fraction variance due to u_i)
of
 9 . regress IS PBV SIZE GROWTH Leverage RA i.Perusahaan

Source SS df MS Number of obs = 78

F(30, 47) = 0.86
Model 1471104.37 30 49036.8124 Prob > F = 0.6616
Residual 2671448.95 47 56839.3393 R-squared = 0.3551
Adj R-squared = -0.0565
Total 4142553.32 77 53799.3937 Root MSE = 238.41

IS Coef. Std. Err. t P>|t| [95% Conf. Interval]

PBV -.1529902 .1549416 -0.99 0.328 -.4646924 .158712

SIZE -13.5285 213.9515 -0.06 0.950 -443.9434 416.8864
GROWTH 1.676912 4.814524 0.35 0.729 -8.00866 11.36249
Leverage -75.85552 771.896 -0.10 0.922 -1628.71 1476.999
RA 6.038784 294.493 0.02 0.984 -586.4047 598.4822

Perusahaan
2 86.66856 1805.307 0.05 0.962 -3545.141 3718.478
3 81.67251 1102.44 0.07 0.941 -2136.151 2299.496
4 67.51522 842.2326 0.08 0.936 -1626.838 1761.869
5 241.6423 1351.837 0.18 0.859 -2477.903 2961.188
6 225.6057 1129.875 0.20 0.843 -2047.411 2498.622
7 301.3853 2769.772 0.11 0.914 -5270.678 5873.449
8 78.21886 1074.4 0.07 0.942 -2083.194 2239.632
9 155.5934 1344.763 0.12 0.908 -2549.721 2860.908
10 -22.14676 200.8924 -0.11 0.913 -426.2902 381.9967
11 54.76767 999.7444 0.05 0.957 -1956.459 2065.994
12 149.5333 994.2764 0.15 0.881 -1850.693 2149.759
13 -54.01409 1001.365 -0.05 0.957 -2068.501 1960.473
14 87.39822 1296.369 0.07 0.947 -2520.561 2695.357
15 -546.16 383.1213 -1.43 0.161 -1316.901 224.5806
16 3.341807 724.6264 0.00 0.996 -1454.418 1461.102
17 11.00053 765.4386 0.01 0.989 -1528.863 1550.864
18 161.448 1008.241 0.16 0.873 -1866.871 2189.767
19 39.69318 747.4996 0.05 0.958 -1464.082 1543.468
20 53.49096 1051.198 0.05 0.960 -2061.247 2168.229
21 2.674176 352.9023 0.01 0.994 -707.2737 712.622
22 -18.26105 653.6651 -0.03 0.978 -1333.266 1296.744
23 147.5347 2509.326 0.06 0.953 -4900.578 5195.647
24 161.227 2512.423 0.06 0.949 -4893.116 5215.57
25 92.61901 905.003 0.10 0.919 -1728.012 1913.25
26 292.4257 2605.073 0.11 0.911 -4948.305 5533.156

_cons 281.5733 3321.37 0.08 0.933 -6400.16 6963.307

10 . testparm

i.Perusahaan ( 1)

2.Perusahaan = 0
( 2) 3.Perusahaan = 0
( 3) 4.Perusahaan = 0
( 4) 5.Perusahaan = 0
( 5) 6.Perusahaan = 0
( 6) 7.Perusahaan = 0
( 7) 8.Perusahaan = 0
( 8) 9.Perusahaan = 0
( 9) 10.Perusahaan = 0
(10) 11.Perusahaan = 0
(11) 12.Perusahaan = 0
(12) 13.Perusahaan = 0
(13) 14.Perusahaan = 0
(14) 15.Perusahaan = 0
(15) 16.Perusahaan = 0
(16) 17.Perusahaan = 0
(17) 18.Perusahaan = 0
 (18) 19.Perusahaan = 0
(19) 20.Perusahaan = 0
(20) 21.Perusahaan = 0
(21) 22.Perusahaan = 0
(22) 23.Perusahaan = 0
(23) 24.Perusahaan = 0
(24) 25.Perusahaan = 0
(25) 26.Perusahaan = 0

F( 25, 47) = 0.60

Prob > F = 0.9146

11 . xtreg IS PBV SIZE GROWTH Leverage RA, fe

Fixed-effects (within) regression Number of obs = 78

Group variable: Perusahaan Number of groups = 26

R-sq: Obs per group:

within = 0.0313 min = 3
between = 0.0011 avg = 3.0
overall = 0.0017 max = 3

F(5,47) = 0.30
corr(u_i, Xb) = -0.4674 Prob > F = 0.9080

IS Coef. Std. Err. t P>|t| [95% Conf. Interval]

PBV -.1529902 .1549416 -0.99 0.328 -.4646924 .158712

SIZE -13.5285 213.9515 -0.06 0.950 -443.9434 416.8864
GROWTH 1.676912 4.814524 0.35 0.729 -8.00866 11.36249
Leverage -75.85552 771.896 -0.10 0.922 -1628.71 1476.999
RA 6.038784 294.493 0.02 0.984 -586.4047 598.4822
_cons 352.9147 4342.571 0.08 0.936 -8383.211 9089.04

sigma_u 158.03597
sigma_e 238.41002
rho .30526747 (fraction of variance due to u_i)

F test that all u_i=0: F(25, 47) = 0.60 Prob > F = 0.9146

12 . estimates store FEM

13 . xtreg IS PBV SIZE GROWTH Leverage RA, re sa

Random-effects GLS regression Number of obs = 78

Group variable: Perusahaan Number of groups = 26

R-sq: Obs per group:

within = 0.0297 min = 3
between = 0.3923 avg = 3.0
overall = 0.1493 max = 3

Wald chi2(5) = 12.64

corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0270
 IS Coef. Std. Err. z P>|z| [95% Conf. Interval]

PBV -.1736301 .0666251 -2.61 0.009 -.304213 -.0430473

SIZE 11.58834 7.597734 1.53 0.127 -3.302945 26.47962
GROWTH 2.500881 3.650595 0.69 0.493 -4.654153 9.655915
Leverage 104.2754 146.9459 0.71 0.478 -183.7333 392.2841
RA 3.088813 62.06921 0.05 0.960 -118.5646 124.7422
_cons -246.1256 191.3124 -1.29 0.198 -621.0909 128.8397

sigma_u 0
sigma_e 238.41002
rho 0 (fraction variance due to u_i)
of

14 . estimates store REM

15 . hausman FEM REM

Coefficients
(b) (B) (b-B) sqrt(diag(V_b-V_B))
FEM REM Difference S.E.

PBV -.1529902 -.1736301 .0206399 .1398856

SIZE -13.5285 11.58834 -25.11684 213.8166
GROWTH 1.676912 2.500881 -.8239687 3.138917
Leverage -75.85552 104.2754 -180.1309 757.7799
RA 6.038784 3.088813 2.949971 287.8776

b = consistent under Ho and Ha; obtained from

xtreg B = inconsistent under Ha, efficient under Ho; obtained
from xtreg

Test: Ho: difference in coefficients not

systematic chi2(5) = (b-B)'[(V_b-

V_B)^(-1)](b-B)
= 0.28
Prob>chi2 = 0.9980

16 . xtreg IS PBV SIZE GROWTH Leverage RA, re sa

Random-effects GLS regression Number of obs = 78

Group variable: Perusahaan Number of groups = 26

R-sq: Obs per group:

within = 0.0297 min = 3
between = 0.3923 avg = 3.0
overall = 0.1493 max = 3

Wald chi2(5) = 12.64

corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0270

IS Coef. Std. Err. z P>|z| [95% Conf. Interval]

PBV -.1736301 .0666251 -2.61 0.009 -.304213 -.0430473

SIZE 11.58834 7.597734 1.53 0.127 -3.302945 26.47962
GROWTH 2.500881 3.650595 0.69 0.493 -4.654153 9.655915
Leverage 104.2754 146.9459 0.71 0.478 -183.7333 392.2841
RA 3.088813 62.06921 0.05 0.960 -118.5646 124.7422
_cons -246.1256 191.3124 -1.29 0.198 -621.0909 128.8397

sigma_u 0
sigma_e 238.41002
rho 0 (fraction variance due to u_i)
of
17 .
18 . estimates store REM

19 .
20 . *uji breusch and Pagan Lagrangian multiplier (CEM vs REM)

21 .
22 . xttest0

Breusch and Pagan Lagrangian multiplier test for random

effects IS[Perusahaan,t] = Xb + u[Perusahaan] +

e[Perusahaan,t] Estimated results:

Var sd = sqrt(Var)

IS 53799.39 231.947
eu 56839.34 238.41
0 0

Test: Var(u) = 0
chibar2(01) = 0.00
Prob > chibar2 = 1.0000

23 . save "D:\SKRIPSI\SKRIPSI EKONOMI\ANGRRAINI OLAH DATA\HASIL REGRESI DATA.dta"

file D:\SKRIPSI\SKRIPSI EKONOMI\ANGRRAINI OLAH DATA\HASIL REGRESI DATA.dta
saved

24 .