--------------------------------------------------------------------------------------------------------- log: D:\My Documents\My Downloads\Econ 170\chapter 10, question 1.log log type: text opened on: 9 Nov 2005, 20:52:53 . use "E:\Schmidt\(02) Stata Format\schoolspend.dta", clear . regress totalspend totalstateaid Source | SS df MS Number of obs = 50 -------------+------------------------------ F( 1, 48) = 293.54 Model | 1.3592e+09 1 1.3592e+09 Prob > F = 0.0000 Residual | 222262513 48 4630469.02 R-squared = 0.8595 -------------+------------------------------ Adj R-squared = 0.8565 Total | 1.5815e+09 49 32275627.4 Root MSE = 2151.9 ------------------------------------------------------------------------------ totalspend | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- totalstate~d | 1.803248 .1052493 17.13 0.000 1.59163 2.014866 _cons | 939.0264 380.9753 2.46 0.017 173.0242 1705.029 ------------------------------------------------------------------------------ . regress totalspend totalstateaid income population Source | SS df MS Number of obs = 50 -------------+------------------------------ F( 3, 46) = 219.42 Model | 1.4782e+09 3 492734984 Prob > F = 0.0000 Residual | 103300792 46 2245669.38 R-squared = 0.9347 -------------+------------------------------ Adj R-squared = 0.9304 Total | 1.5815e+09 49 32275627.4 Root MSE = 1498.6 ------------------------------------------------------------------------------ totalspend | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- totalstate~d | -.3285301 .3020649 -1.09 0.282 -.9365553 .2794951 income | .0229457 .0093498 2.45 0.018 .0041256 .0417658 population | .3469648 .3112457 1.11 0.271 -.2795403 .9734699 _cons | -11.87355 309.6011 -0.04 0.970 -635.0683 611.3212 ------------------------------------------------------------------------------ . regress totalspend totalstateaid income Source | SS df MS Number of obs = 50 -------------+------------------------------ F( 2, 47) = 326.81 Model | 1.4754e+09 2 737707137 Prob > F = 0.0000 Residual | 106091471 47 2257265.34 R-squared = 0.9329 -------------+------------------------------ Adj R-squared = 0.9301 Total | 1.5815e+09 49 32275627.4 Root MSE = 1502.4 ------------------------------------------------------------------------------ totalspend | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- totalstate~d | -.2886033 .3007074 -0.96 0.342 -.8935486 .3163419 income | .032104 .0044751 7.17 0.000 .0231013 .0411068 _cons | 111.357 289.9391 0.38 0.703 -471.9252 694.6392 ------------------------------------------------------------------------------ . regress totalspend totalstateaid population Source | SS df MS Number of obs = 50 -------------+------------------------------ F( 2, 47) = 294.63 Model | 1.4647e+09 2 732339812 Prob > F = 0.0000 Residual | 116826121 47 2485662.15 R-squared = 0.9261 -------------+------------------------------ Adj R-squared = 0.9230 Total | 1.5815e+09 49 32275627.4 Root MSE = 1576.6 ------------------------------------------------------------------------------ totalspend | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- totalstate~d | -.0650133 .2970396 -0.22 0.828 -.66258 .5325534 population | 1.018143 .1563272 6.51 0.000 .7036533 1.332633 _cons | -115.4309 322.6852 -0.36 0.722 -764.5897 533.7279 ------------------------------------------------------------------------------ . correlate population income (obs=50) | popula~n income -------------+------------------ population | 1.0000 income | 0.9922 1.0000 . regress totalspend totalstateaid Source | SS df MS Number of obs = 50 -------------+------------------------------ F( 1, 48) = 293.54 Model | 1.3592e+09 1 1.3592e+09 Prob > F = 0.0000 Residual | 222262513 48 4630469.02 R-squared = 0.8595 -------------+------------------------------ Adj R-squared = 0.8565 Total | 1.5815e+09 49 32275627.4 Root MSE = 2151.9 ------------------------------------------------------------------------------ totalspend | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- totalstate~d | 1.803248 .1052493 17.13 0.000 1.59163 2.014866 _cons | 939.0264 380.9753 2.46 0.017 173.0242 1705.029 ------------------------------------------------------------------------------ . correlate totalstateaid population income (obs=50) | total~id popula~n income -------------+--------------------------- totalstate~d | 1.0000 population | 0.9657 1.0000 income | 0.9697 0.9922 1.0000 . log close log: D:\My Documents\My Downloads\Econ 170\chapter 10, question 1.log log type: text closed on: 9 Nov 2005, 20:58:16 ---------------------------------------------------------------------------------------------------------