------------------------------------------------------------------------------- log: D:\bill\fall2008\econ30331\class_size_4.log log type: text opened on: 21 Sep 2008, 07:16:52 . . * open class_size_1, 420 observations from . * california k-6 and k-8 schools . * 6th grad test scores . use ca_school_data_2 . . desc average_score student_teacher avg_income esl_pct meal_pct storage display value variable name type format label variable label ------------------------------------------------------------------------------- average_score float %9.0g average score (math+read) std test student_teacher float %9.0g student/teacher ratio avg_income float %9.0g average family income esl_pct float %9.0g pct student with english second language meal_pct float %9.0g % kids on free/reduced prices meals . sum average_score student_teacher avg_income esl_pct meal_pct Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- average_sc~e | 420 654.1565 19.05335 605.55 706.75 student_te~r | 420 19.64043 1.891812 14 25.8 avg_income | 420 15.31659 7.22589 5.335 55.328 esl_pct | 420 15.76816 18.28593 0 85.53972 meal_pct | 420 44.70524 27.12338 0 100 . . * run mv regression wth 4 x's . reg average_score student_teacher avg_income esl_pct meal_pct Source | SS df MS Number of obs = 420 -------------+------------------------------ F( 4, 415) = 429.12 Model | 122493.527 4 30623.3818 Prob > F = 0.0000 Residual | 29616.0666 415 71.3640159 R-squared = 0.8053 -------------+------------------------------ Adj R-squared = 0.8034 Total | 152109.594 419 363.030056 Root MSE = 8.4477 ------------------------------------------------------------------------------ average_sc~e | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- student_te~r | -.5603892 .2286116 -2.45 0.015 -1.00977 -.1110081 avg_income | .674984 .083331 8.10 0.000 .5111805 .8387875 esl_pct | -.1943282 .0313796 -6.19 0.000 -.256011 -.1326454 meal_pct | -.3963661 .0274084 -14.46 0.000 -.4502427 -.3424895 _cons | 675.6082 5.308856 127.26 0.000 665.1726 686.0438 ------------------------------------------------------------------------------ . . * run the same regression but ask for a 99% confidence level . reg average_score student_teacher avg_income esl_pct meal_pct, level(99) Source | SS df MS Number of obs = 420 -------------+------------------------------ F( 4, 415) = 429.12 Model | 122493.527 4 30623.3818 Prob > F = 0.0000 Residual | 29616.0666 415 71.3640159 R-squared = 0.8053 -------------+------------------------------ Adj R-squared = 0.8034 Total | 152109.594 419 363.030056 Root MSE = 8.4477 ------------------------------------------------------------------------------ average_sc~e | Coef. Std. Err. t P>|t| [99% Conf. Interval] -------------+---------------------------------------------------------------- student_te~r | -.5603892 .2286116 -2.45 0.015 -1.151974 .0311954 avg_income | .674984 .083331 8.10 0.000 .4593461 .8906219 esl_pct | -.1943282 .0313796 -6.19 0.000 -.2755301 -.1131263 meal_pct | -.3963661 .0274084 -14.46 0.000 -.4672916 -.3254406 _cons | 675.6082 5.308856 127.26 0.000 661.8703 689.3461 ------------------------------------------------------------------------------ . . log close log: D:\bill\fall2008\econ30331\class_size_4.log log type: text closed on: 21 Sep 2008, 07:16:52 -------------------------------------------------------------------------------