------------------------------------------------------------------------------------------------- name: log: C:\Users\Professor\Downloads\Aula_30_08.log log type: text opened on: 30 Aug 2022, 16:10:46 . summarize wage Variable | Obs Mean Std. Dev. Min Max -------------+--------------------------------------------------------- wage | 526 5.896103 3.693086 .53 24.98 . summarize wage if female==1 Variable | Obs Mean Std. Dev. Min Max -------------+--------------------------------------------------------- wage | 252 4.587659 2.529363 .53 21.63 . sum wage, detail average hourly earnings ------------------------------------------------------------- Percentiles Smallest 1% 1.67 .53 5% 2.75 1.43 10% 2.92 1.5 Obs 526 25% 3.33 1.5 Sum of Wgt. 526 50% 4.65 Mean 5.896103 Largest Std. Dev. 3.693086 75% 6.88 21.86 90% 10 22.2 Variance 13.63888 95% 13 22.86 Skewness 2.007325 99% 20 24.98 Kurtosis 7.970083 . summarize wage if female==0, detail average hourly earnings ------------------------------------------------------------- Percentiles Smallest 1% 1.75 1.5 5% 2.92 1.67 10% 3 1.75 Obs 274 25% 4.11 2 Sum of Wgt. 274 50% 6 Mean 7.099489 Largest Std. Dev. 4.160858 75% 8.77 21.86 90% 12.5 22.2 Variance 17.31274 95% 15.38 22.86 Skewness 1.575794 99% 22.2 24.98 Kurtosis 5.828708 . reg wage educ exper female Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(3, 522) = 77.92 Model | 2214.74206 3 738.247353 Prob > F = 0.0000 Residual | 4945.67223 522 9.47446788 R-squared = 0.3093 -------------+---------------------------------- Adj R-squared = 0.3053 Total | 7160.41429 525 13.6388844 Root MSE = 3.0781 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6025802 .0511174 11.79 0.000 .5021591 .7030012 exper | .0642417 .0104003 6.18 0.000 .0438101 .0846734 female | -2.155517 .2703055 -7.97 0.000 -2.686537 -1.624497 _cons | -1.734481 .7536203 -2.30 0.022 -3.214982 -.2539797 ------------------------------------------------------------------------------ . display (-2.155517-0)/.2703055 -7.9743734 . reg wage educ exper female Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(3, 522) = 77.92 Model | 2214.74206 3 738.247353 Prob > F = 0.0000 Residual | 4945.67223 522 9.47446788 R-squared = 0.3093 -------------+---------------------------------- Adj R-squared = 0.3053 Total | 7160.41429 525 13.6388844 Root MSE = 3.0781 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6025802 .0511174 11.79 0.000 .5021591 .7030012 exper | .0642417 .0104003 6.18 0.000 .0438101 .0846734 female | -2.155517 .2703055 -7.97 0.000 -2.686537 -1.624497 _cons | -1.734481 .7536203 -2.30 0.022 -3.214982 -.2539797 ------------------------------------------------------------------------------ . reg wage female Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(1, 524) = 68.54 Model | 828.220467 1 828.220467 Prob > F = 0.0000 Residual | 6332.19382 524 12.0843394 R-squared = 0.1157 -------------+---------------------------------- Adj R-squared = 0.1140 Total | 7160.41429 525 13.6388844 Root MSE = 3.4763 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- female | -2.51183 .3034092 -8.28 0.000 -3.107878 -1.915782 _cons | 7.099489 .2100082 33.81 0.000 6.686928 7.51205 ------------------------------------------------------------------------------ . test (educ=1) educ not found r(111); . reg wage educ exper female Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(3, 522) = 77.92 Model | 2214.74206 3 738.247353 Prob > F = 0.0000 Residual | 4945.67223 522 9.47446788 R-squared = 0.3093 -------------+---------------------------------- Adj R-squared = 0.3053 Total | 7160.41429 525 13.6388844 Root MSE = 3.0781 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6025802 .0511174 11.79 0.000 .5021591 .7030012 exper | .0642417 .0104003 6.18 0.000 .0438101 .0846734 female | -2.155517 .2703055 -7.97 0.000 -2.686537 -1.624497 _cons | -1.734481 .7536203 -2.30 0.022 -3.214982 -.2539797 ------------------------------------------------------------------------------ . test (educ) ( 1) educ = 0 F( 1, 522) = 138.96 Prob > F = 0.0000 . test (educ) (educ=1) ( 1) educ = 0 ( 2) educ = 1 Constraint 2 dropped F( 1, 522) = 138.96 Prob > F = 0.0000 . test (educ=1) ( 1) educ = 1 F( 1, 522) = 60.45 Prob > F = 0.0000 . test (educ=1) ( 1) educ = 1 F( 1, 522) = 60.45 Prob > F = 0.0000 . test (educ=1) ( 1) educ = 1 F( 1, 522) = 60.45 Prob > F = 0.0000 . test (educ=1) (exper=0) ( 1) educ = 1 ( 2) exper = 0 F( 2, 522) = 70.45 Prob > F = 0.0000 . test (educ=1) ( 1) educ = 1 F( 1, 522) = 60.45 Prob > F = 0.0000 . test(educ=1) ( 1) educ = 1 F( 1, 522) = 60.45 Prob > F = 0.0000 . test (educ=1) ( 1) educ = 1 F( 1, 522) = 60.45 Prob > F = 0.0000 . reg wage educ exper female Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(3, 522) = 77.92 Model | 2214.74206 3 738.247353 Prob > F = 0.0000 Residual | 4945.67223 522 9.47446788 R-squared = 0.3093 -------------+---------------------------------- Adj R-squared = 0.3053 Total | 7160.41429 525 13.6388844 Root MSE = 3.0781 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6025802 .0511174 11.79 0.000 .5021591 .7030012 exper | .0642417 .0104003 6.18 0.000 .0438101 .0846734 female | -2.155517 .2703055 -7.97 0.000 -2.686537 -1.624497 _cons | -1.734481 .7536203 -2.30 0.022 -3.214982 -.2539797 ------------------------------------------------------------------------------ . test (educ=1) ( 1) educ = 1 F( 1, 522) = 60.45 Prob > F = 0.0000 . reg wage educ exper Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(2, 523) = 75.99 Model | 1612.2545 2 806.127251 Prob > F = 0.0000 Residual | 5548.15979 523 10.6083361 R-squared = 0.2252 -------------+---------------------------------- Adj R-squared = 0.2222 Total | 7160.41429 525 13.6388844 Root MSE = 3.257 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6442721 .0538061 11.97 0.000 .5385695 .7499747 exper | .0700954 .0109776 6.39 0.000 .0485297 .0916611 _cons | -3.390539 .7665661 -4.42 0.000 -4.896466 -1.884613 ------------------------------------------------------------------------------ . reg wage educ exper, level(99) Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(2, 523) = 75.99 Model | 1612.2545 2 806.127251 Prob > F = 0.0000 Residual | 5548.15979 523 10.6083361 R-squared = 0.2252 -------------+---------------------------------- Adj R-squared = 0.2222 Total | 7160.41429 525 13.6388844 Root MSE = 3.257 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [99% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6442721 .0538061 11.97 0.000 .5051693 .7833749 exper | .0700954 .0109776 6.39 0.000 .0417153 .0984755 _cons | -3.390539 .7665661 -4.42 0.000 -5.372314 -1.408765 ------------------------------------------------------------------------------ . reg wage educ exper female, level(99) Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(3, 522) = 77.92 Model | 2214.74206 3 738.247353 Prob > F = 0.0000 Residual | 4945.67223 522 9.47446788 R-squared = 0.3093 -------------+---------------------------------- Adj R-squared = 0.3053 Total | 7160.41429 525 13.6388844 Root MSE = 3.0781 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [99% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6025802 .0511174 11.79 0.000 .4704274 .7347329 exper | .0642417 .0104003 6.18 0.000 .037354 .0911295 female | -2.155517 .2703055 -7.97 0.000 -2.854333 -1.456702 _cons | -1.734481 .7536203 -2.30 0.022 -3.682801 .2138388 ------------------------------------------------------------------------------ . reg wage educ exper female, level(95) Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(3, 522) = 77.92 Model | 2214.74206 3 738.247353 Prob > F = 0.0000 Residual | 4945.67223 522 9.47446788 R-squared = 0.3093 -------------+---------------------------------- Adj R-squared = 0.3053 Total | 7160.41429 525 13.6388844 Root MSE = 3.0781 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .6025802 .0511174 11.79 0.000 .5021591 .7030012 exper | .0642417 .0104003 6.18 0.000 .0438101 .0846734 female | -2.155517 .2703055 -7.97 0.000 -2.686537 -1.624497 _cons | -1.734481 .7536203 -2.30 0.022 -3.214982 -.2539797 ------------------------------------------------------------------------------ . test (female=-2) ( 1) female = -2 F( 1, 522) = 0.33 Prob > F = 0.5653 . twoway (line wage educ, sort) . twoway (scatter wage educ, sort) . twoway (scatter wage exper, sort) . gen exper2=exper^2 . reg wage educ exper exper2 female, level(95) Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(4, 521) = 70.17 Model | 2506.95576 4 626.738939 Prob > F = 0.0000 Residual | 4653.45854 521 8.93178222 R-squared = 0.3501 -------------+---------------------------------- Adj R-squared = 0.3451 Total | 7160.41429 525 13.6388844 Root MSE = 2.9886 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .5562848 .0502875 11.06 0.000 .4574937 .6550759 exper | .2551276 .0348671 7.32 0.000 .1866302 .323625 exper2 | -.0044396 .0007762 -5.72 0.000 -.0059645 -.0029148 female | -2.114035 .2625501 -8.05 0.000 -2.629822 -1.598248 _cons | -2.319204 .7388254 -3.14 0.002 -3.770647 -.8677608 ------------------------------------------------------------------------------ . gen z=educ+exper . log close name: log: C:\Users\Professor\Downloads\Aula_30_08.log log type: text closed on: 30 Aug 2022, 17:06:15 -------------------------------------------------------------------------------------------------