-------------------------------------------------------------------------------- log: C:\Documents and Settings\Patricia_Anderson\My Documents\ECON 20\In > Class\oct16.log log type: text opened on: 16 Oct 2002, 11:13:25 . use mlb1 . reg lsalary years gamesyr bavg rbisyr hrunsyr Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 5, 347) = 117.06 Model | 308.9892 5 61.79784 Prob > F = 0.0000 Residual | 183.186335 347 .52791451 R-squared = 0.6278 -------------+------------------------------ Adj R-squared = 0.6224 Total | 492.175535 352 1.39822595 Root MSE = .72658 ------------------------------------------------------------------------------ lsalary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | .0688626 .0121145 5.68 0.000 .0450355 .0926898 gamesyr | .0125521 .0026468 4.74 0.000 .0073464 .0177578 bavg | .0009786 .0011035 0.89 0.376 -.0011918 .003149 rbisyr | .0107657 .007175 1.50 0.134 -.0033462 .0248776 hrunsyr | .0144295 .016057 0.90 0.369 -.0171518 .0460107 _cons | 11.19242 .2888229 38.75 0.000 10.62435 11.76048 ------------------------------------------------------------------------------ . test bavg rbisyr hrunsyr ( 1) bavg = 0.0 ( 2) rbisyr = 0.0 ( 3) hrunsyr = 0.0 F( 3, 347) = 9.55 Prob > F = 0.0000 . **resticted model . reg lsalary years gamesyr Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 2, 350) = 259.32 Model | 293.864044 2 146.932022 Prob > F = 0.0000 Residual | 198.311491 350 .566604259 R-squared = 0.5971 -------------+------------------------------ Adj R-squared = 0.5948 Total | 492.175535 352 1.39822595 Root MSE = .75273 ------------------------------------------------------------------------------ lsalary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | .071318 .012505 5.70 0.000 .0467236 .0959124 gamesyr | .0201745 .0013429 15.02 0.000 .0175334 .0228156 _cons | 11.2238 .108312 103.62 0.000 11.01078 11.43683 ------------------------------------------------------------------------------ . predict uhat, r . reg uhat years gamesyr rbisyr hrunsyr bavg Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 5, 347) = 5.73 Model | 15.1251558 5 3.02503116 Prob > F = 0.0000 Residual | 183.186334 347 .527914508 R-squared = 0.0763 -------------+------------------------------ Adj R-squared = 0.0630 Total | 198.31149 352 .563384915 Root MSE = .72658 ------------------------------------------------------------------------------ uhat | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | -.0024553 .0121145 -0.20 0.840 -.0262825 .0213718 gamesyr | -.0076224 .0026468 -2.88 0.004 -.0128281 -.0024166 rbisyr | .0107657 .007175 1.50 0.134 -.0033462 .0248776 hrunsyr | .0144295 .016057 0.90 0.369 -.0171518 .0460107 bavg | .0009786 .0011035 0.89 0.376 -.0011918 .003149 _cons | -.0313858 .2888229 -0.11 0.914 -.5994495 .5366779 ------------------------------------------------------------------------------ . *calculate the LM statistic . display 353*.0763 26.9339 . **get p-value . display chi2tail(3, 26.9) 6.179e-06 . reg lsalary years gamesyr bavg rbisyr hrunsyr Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 5, 347) = 117.06 Model | 308.9892 5 61.79784 Prob > F = 0.0000 Residual | 183.186335 347 .52791451 R-squared = 0.6278 -------------+------------------------------ Adj R-squared = 0.6224 Total | 492.175535 352 1.39822595 Root MSE = .72658 ------------------------------------------------------------------------------ lsalary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | .0688626 .0121145 5.68 0.000 .0450355 .0926898 gamesyr | .0125521 .0026468 4.74 0.000 .0073464 .0177578 bavg | .0009786 .0011035 0.89 0.376 -.0011918 .003149 rbisyr | .0107657 .007175 1.50 0.134 -.0033462 .0248776 hrunsyr | .0144295 .016057 0.90 0.369 -.0171518 .0460107 _cons | 11.19242 .2888229 38.75 0.000 10.62435 11.76048 ------------------------------------------------------------------------------ . predict uhatbad, r . reg uhatbad years gamesyr bavg rbisyr hrunsyr Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 5, 347) = 0.00 Model | 8.5265e-14 5 1.7053e-14 Prob > F = 1.0000 Residual | 183.186334 347 .527914508 R-squared = 0.0000 -------------+------------------------------ Adj R-squared = -0.0144 Total | 183.186334 352 .520415723 Root MSE = .72658 ------------------------------------------------------------------------------ uhatbad | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | -1.54e-10 .0121145 -0.00 1.000 -.0238272 .0238272 gamesyr | 8.57e-11 .0026468 0.00 1.000 -.0052057 .0052057 bavg | -1.82e-11 .0011035 -0.00 1.000 -.0021704 .0021704 rbisyr | -1.82e-10 .007175 -0.00 1.000 -.0141119 .0141119 hrunsyr | 3.50e-10 .016057 0.00 1.000 -.0315813 .0315813 _cons | 1.49e-09 .2888229 0.00 1.000 -.5680637 .5680637 ------------------------------------------------------------------------------ . use wage1, clear . use reg salary educ exper expersq invalid 'salary' r(198); . use reg wage educ exper expersq invalid 'wage' r(198); . reg wage educ exper expersq Source | SS df MS Number of obs = 526 -------------+------------------------------ F( 3, 522) = 64.11 Model | 1927.87673 3 642.625576 Prob > F = 0.0000 Residual | 5232.53756 522 10.0240183 R-squared = 0.2692 -------------+------------------------------ Adj R-squared = 0.2650 Total | 7160.41429 525 13.6388844 Root MSE = 3.1661 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .5953429 .0530251 11.23 0.000 .4911741 .6995118 exper | .268287 .0368969 7.27 0.000 .1958023 .3407717 expersq | -.0046123 .000822 -5.61 0.000 -.006227 -.0029975 _cons | -3.96489 .7521526 -5.27 0.000 -5.442508 -2.487272 ------------------------------------------------------------------------------ . gen edten=educ*tenure . reg wage educ tenure edten Source | SS df MS Number of obs = 526 -------------+------------------------------ F( 3, 522) = 82.15 Model | 2296.41715 3 765.472384 Prob > F = 0.0000 Residual | 4863.99714 522 9.31800218 R-squared = 0.3207 -------------+------------------------------ Adj R-squared = 0.3168 Total | 7160.41429 525 13.6388844 Root MSE = 3.0525 ------------------------------------------------------------------------------ wage | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- educ | .4265947 .0610327 6.99 0.000 .3066948 .5464946 tenure | -.0822392 .0737709 -1.11 0.265 -.2271635 .0626851 edten | .0225057 .0059134 3.81 0.000 .0108887 .0341228 _cons | -.4612881 .7832198 -0.59 0.556 -1.999938 1.077362 ------------------------------------------------------------------------------ . test tenure edten ( 1) tenure = 0.0 ( 2) edten = 0.0 F( 2, 522) = 59.92 Prob > F = 0.0000 . use mlb1, clear . reg lsalary years gamesyr rbisyr bavg Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 4, 348) = 146.20 Model | 308.562878 4 77.1407195 Prob > F = 0.0000 Residual | 183.612657 348 .527622578 R-squared = 0.6269 -------------+------------------------------ Adj R-squared = 0.6226 Total | 492.175535 352 1.39822595 Root MSE = .72638 ------------------------------------------------------------------------------ lsalary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | .0697299 .0120727 5.78 0.000 .0459852 .0934745 gamesyr | .0111597 .0021453 5.20 0.000 .0069405 .015379 rbisyr | .0165233 .0032288 5.12 0.000 .0101728 .0228737 bavg | .0007398 .0010707 0.69 0.490 -.0013662 .0028457 _cons | 11.27513 .2736889 41.20 0.000 10.73684 11.81342 ------------------------------------------------------------------------------ . reg lsalary years gamesyr rbisyr bavg hrunsyr Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 5, 347) = 117.06 Model | 308.9892 5 61.79784 Prob > F = 0.0000 Residual | 183.186335 347 .52791451 R-squared = 0.6278 -------------+------------------------------ Adj R-squared = 0.6224 Total | 492.175535 352 1.39822595 Root MSE = .72658 ------------------------------------------------------------------------------ lsalary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | .0688626 .0121145 5.68 0.000 .0450355 .0926898 gamesyr | .0125521 .0026468 4.74 0.000 .0073464 .0177578 rbisyr | .0107657 .007175 1.50 0.134 -.0033462 .0248776 bavg | .0009786 .0011035 0.89 0.376 -.0011918 .003149 hrunsyr | .0144295 .016057 0.90 0.369 -.0171518 .0460107 _cons | 11.19242 .2888229 38.75 0.000 10.62435 11.76048 ------------------------------------------------------------------------------ . reg lsalary years gamesyr slugavg Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 3, 349) = 175.60 Model | 296.045468 3 98.6818228 Prob > F = 0.0000 Residual | 196.130067 349 .561977268 R-squared = 0.6015 -------------+------------------------------ Adj R-squared = 0.5981 Total | 492.175535 352 1.39822595 Root MSE = .74965 ------------------------------------------------------------------------------ lsalary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- years | .0711103 .0124543 5.71 0.000 .0466154 .0956053 gamesyr | .0199147 .0013439 14.82 0.000 .0172717 .0225578 slugavg | .0040363 .0020487 1.97 0.050 7.00e-06 .0080655 _cons | 11.08896 .1277496 86.80 0.000 10.8377 11.34022 ------------------------------------------------------------------------------ . predict lsalaryhat (option xb assumed; fitted values) . gen elsalaryhat=exp(lsalaryhat) . sum *sal* Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 353 1345672 1407352 109000 6329213 teamsal | 353 3.08e+07 8722411 8854000 4.29e+07 yrsallst | 353 .8923513 2.06562 0 13 lsalary | 353 13.49218 1.182466 11.5991 15.66069 lsalaryhat | 353 13.49218 .9170814 11.38596 15.47476 elsalaryhat | 353 1052414 912806.3 88076.8 5255355 . reg salary elsalaryhat, nocons Source | SS df MS Number of obs = 353 -------------+------------------------------ F( 1, 352) = 750.48 Model | 9.0972e+14 1 9.0972e+14 Prob > F = 0.0000 Residual | 4.2669e+14 352 1.2122e+12 R-squared = 0.6807 -------------+------------------------------ Adj R-squared = 0.6798 Total | 1.3364e+15 353 3.7859e+12 Root MSE = 1.1e+06 ------------------------------------------------------------------------------ salary | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- elsalaryhat | 1.153033 .0420893 27.39 0.000 1.070255 1.235811 ------------------------------------------------------------------------------ . gen predsalary=elsalaryhat*1.153 . sum *sal* Variable | Obs Mean Std. Dev. Min Max -------------+----------------------------------------------------- salary | 353 1345672 1407352 109000 6329213 teamsal | 353 3.08e+07 8722411 8854000 4.29e+07 yrsallst | 353 .8923513 2.06562 0 13 lsalary | 353 13.49218 1.182466 11.5991 15.66069 lsalaryhat | 353 13.49218 .9170814 11.38596 15.47476 elsalaryhat | 353 1052414 912806.3 88076.8 5255355 predsalary | 353 1213433 1052466 101552.5 6059425 . log close log: C:\Documents and Settings\Patricia_Anderson\My Documents\ECON 20\I > nClass\oct16.log log type: text closed on: 16 Oct 2002, 12:23:29 -------------------------------------------------------------------------------