---------------------------------------------------------------------------------------------------------
       log:  D:\My Documents\My Downloads\Econ 170\chapter 10, question 2.log
  log type:  text
 opened on:   9 Nov 2005, 20:58:29

. use "E:\Schmidt\(02) Stata Format\schoolspend2.dta", clear

. scatter stateaid population, title(Stateaid vs Population) xtitle(Population) ytitle(Stateaid)

. graph save "D:\My Documents\My Downloads\Econ 170\chapter 10, question 2a1.gph", replace
(note: file D:\My Documents\My Downloads\Econ 170\chapter 10, question 2a1.gph not found)
(file D:\My Documents\My Downloads\Econ 170\chapter 10, question 2a1.gph saved)

. scatter stateaid incomepp, title(Stateaid vs Incomepp) xtitle(Incomepp) ytitle(Stateaid)

. graph save "D:\My Documents\My Downloads\Econ 170\chapter 10, question 2a2.gph", replace
(note: file D:\My Documents\My Downloads\Econ 170\chapter 10, question 2a2.gph not found)
(file D:\My Documents\My Downloads\Econ 170\chapter 10, question 2a2.gph saved)

. correlate stateaid incomepp population
(obs=50)

             | stateaid incomepp popula~n
-------------+---------------------------
    stateaid |   1.0000
    incomepp |   0.2717   1.0000
  population |   0.1264   0.2275   1.0000


. regress spending stateaid incomepp population

      Source |       SS       df       MS              Number of obs =      50
-------------+------------------------------           F(  3,    46) =   26.82
       Model |  54270233.3     3  18090077.8           Prob > F      =  0.0000
    Residual |  31028986.7    46  674543.189           R-squared     =  0.6362
-------------+------------------------------           Adj R-squared =  0.6125
       Total |    85299220    49  1740800.41           Root MSE      =  821.31

------------------------------------------------------------------------------
    spending |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
    stateaid |   .3794841    .152622     2.49   0.017      .072272    .6866963
    incomepp |   .0233888   .0031315     7.47   0.000     .0170853    .0296922
  population |  -.0010417   .0217624    -0.05   0.962    -.0448471    .0427637
       _cons |   151.4982   568.0701     0.27   0.791    -991.9676    1294.964
------------------------------------------------------------------------------

. regress spending stateaid incomepp

      Source |       SS       df       MS              Number of obs =      50
-------------+------------------------------           F(  2,    47) =   41.10
       Model |  54268687.7     2  27134343.9           Prob > F      =  0.0000
    Residual |  31030532.3    47  660224.091           R-squared     =  0.6362
-------------+------------------------------           Adj R-squared =  0.6207
       Total |    85299220    49  1740800.41           Root MSE      =  812.54

------------------------------------------------------------------------------
    spending |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
    stateaid |   .3789806   .1506344     2.52   0.015     .0759433     .682018
    incomepp |   .0233584    .003034     7.70   0.000     .0172547    .0294621
       _cons |   152.7257   561.4354     0.27   0.787    -976.7367    1282.188
------------------------------------------------------------------------------

. correlate stateaid incomepp
(obs=50)

             | stateaid incomepp
-------------+------------------
    stateaid |   1.0000
    incomepp |   0.2717   1.0000


. log close
       log:  D:\My Documents\My Downloads\Econ 170\chapter 10, question 2.log
  log type:  text
 closed on:   9 Nov 2005, 21:07:17
---------------------------------------------------------------------------------------------------------