--------------------------------------------------------------------- name: log: C:\Users\LabProf01\Documents\aula1_stata.log log type: text opened on: 29 Mar 2023, 16:16:37 . 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 . sum Variable | Obs Mean Std. Dev. Min M > ax -------------+------------------------------------------------------- > -- wage | 526 5.896103 3.693086 .53 24. > 98 educ | 526 12.56274 2.769022 0 > 18 exper | 526 17.01711 13.57216 1 > 51 tenure | 526 5.104563 7.224462 0 > 44 nonwhite | 526 .1026616 .3038053 0 > 1 -------------+------------------------------------------------------- > -- female | 526 .4790875 .500038 0 > 1 married | 526 .608365 .4885804 0 > 1 numdep | 526 1.043726 1.261891 0 > 6 smsa | 526 .7224335 .4482246 0 > 1 northcen | 526 .2509506 .4339728 0 > 1 -------------+------------------------------------------------------- > -- south | 526 .3555133 .4791242 0 > 1 west | 526 .1692015 .3752867 0 > 1 construc | 526 .0456274 .2088743 0 > 1 ndurman | 526 .1140684 .318197 0 > 1 trcommpu | 526 .0437262 .20468 0 > 1 -------------+------------------------------------------------------- > -- trade | 526 .2870722 .4528262 0 > 1 services | 526 .1007605 .3012978 0 > 1 profserv | 526 .2585551 .4382574 0 > 1 profocc | 526 .3669202 .4824233 0 > 1 clerocc | 526 .1673004 .3735991 0 > 1 -------------+------------------------------------------------------- > -- servocc | 526 .1406844 .3480267 0 > 1 lwage | 526 1.623268 .5315382 -.6348783 3.2180 > 76 expersq | 526 473.4354 616.0448 1 26 > 01 tenursq | 526 78.15019 199.4347 0 19 > 36 . display 526*0.479 251.954 . twoway (scatter wage educ, sort) . twoway (line wage educ) . twoway (scatter wage educ, sort) . twoway (scatter wage exper, sort) . reg wage educ Source | SS df MS Number of obs = 5 > 26 -------------+---------------------------------- F(1, 524) = 103. > 36 Model | 1179.73204 1 1179.73204 Prob > F = 0.00 > 00 Residual | 5980.68225 524 11.4135158 R-squared = 0.16 > 48 -------------+---------------------------------- Adj R-squared = 0.16 > 32 Total | 7160.41429 525 13.6388844 Root MSE = 3.37 > 84 ---------------------------------------------------------------------------- > -- wage | Coef. Std. Err. t P>|t| [95% Conf. Interva > l] -------------+-------------------------------------------------------------- > -- educ | .5413593 .053248 10.17 0.000 .4367534 .64596 > 51 _cons | -.9048516 .6849678 -1.32 0.187 -2.250472 .44076 > 87 ---------------------------------------------------------------------------- > -- . reg wage educ Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(1, 524) = 103.36 Model | 1179.73204 1 1179.73204 Prob > F = 0.0000 Residual | 5980.68225 524 11.4135158 R-squared = 0.1648 -------------+---------------------------------- Adj R-squared = 0.1632 Total | 7160.41429 525 13.6388844 Root MSE = 3.3784 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .5413593 .053248 10.17 0.000 .4367534 .6459651 _cons | -.9048516 .6849678 -1.32 0.187 -2.250472 .4407687 ------------------------------------------------------------------------------ . sum wage Variable | Obs Mean Std. Dev. Min Max -------------+--------------------------------------------------------- wage | 526 5.896103 3.693086 .53 24.98 . 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 . count if wage==0 0 . count if wage>5 234 . count if wage>5 & wage<10 167 . display 1-( 5980.68225/ 7160.41429 ) .16475751 . display 1179.73204/7160.41429 .16475751 . 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 ------------------------------------------------------------------------------ . sum Variable | Obs Mean Std. Dev. Min Max -------------+--------------------------------------------------------- wage | 526 5.896103 3.693086 .53 24.98 educ | 526 12.56274 2.769022 0 18 exper | 526 17.01711 13.57216 1 51 tenure | 526 5.104563 7.224462 0 44 nonwhite | 526 .1026616 .3038053 0 1 -------------+--------------------------------------------------------- female | 526 .4790875 .500038 0 1 married | 526 .608365 .4885804 0 1 numdep | 526 1.043726 1.261891 0 6 smsa | 526 .7224335 .4482246 0 1 northcen | 526 .2509506 .4339728 0 1 -------------+--------------------------------------------------------- south | 526 .3555133 .4791242 0 1 west | 526 .1692015 .3752867 0 1 construc | 526 .0456274 .2088743 0 1 ndurman | 526 .1140684 .318197 0 1 trcommpu | 526 .0437262 .20468 0 1 -------------+--------------------------------------------------------- trade | 526 .2870722 .4528262 0 1 services | 526 .1007605 .3012978 0 1 profserv | 526 .2585551 .4382574 0 1 profocc | 526 .3669202 .4824233 0 1 clerocc | 526 .1673004 .3735991 0 1 -------------+--------------------------------------------------------- servocc | 526 .1406844 .3480267 0 1 lwage | 526 1.623268 .5315382 -.6348783 3.218076 expersq | 526 473.4354 616.0448 1 2601 tenursq | 526 78.15019 199.4347 0 1936 . display 2.15/5.9 .36440678 . display 0.15/5.9 .02542373 . twoway (scatter wage exper, sort) . . . . twoway (scatter wage educ, sort) (fplot wage educ, sort) fplot is not a twoway plot type r(198); . twoway (scatter wage educ, sort) (lfit wage educ) . reg wage educ Source | SS df MS Number of obs = 526 -------------+---------------------------------- F(1, 524) = 103.36 Model | 1179.73204 1 1179.73204 Prob > F = 0.0000 Residual | 5980.68225 524 11.4135158 R-squared = 0.1648 -------------+---------------------------------- Adj R-squared = 0.1632 Total | 7160.41429 525 13.6388844 Root MSE = 3.3784 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .5413593 .053248 10.17 0.000 .4367534 .6459651 _cons | -.9048516 .6849678 -1.32 0.187 -2.250472 .4407687 ------------------------------------------------------------------------------ . twoway (scatter wage educ, sort) (lfit wage educ) . twoway (scatter wage educ, sort) (lfit wage educ) . log close name: log: C:\Users\LabProf01\Documents\aula1_stata.log log type: text closed on: 29 Mar 2023, 16:53:15 -------------------------------------------------------------------------------