Regression analysis. (economic)
Monday, November 30, 2015 at 4:49 PM Page 1
User: Zhijing Zhang
___ ____ ____ ____ ____ (R) /__ / ____/ / ____/ ___/ / /___/ / /___/ 13.1 Copyright 1985-2013 StataCorp LP Statistics/Data Analysis StataCorp 4905 Lakeway Drive MP - Parallel Edition College Station, Texas 77845 USA 800-STATA-PC http://www.stata.com 979-696-4600 [email protected] 979-696-4601 (fax)
40-user 4-core Stata network perpetual license: Serial number: 501306200440 Licensed to: LeBow College of Business Drexel University
Notes: 1. (-set maxvar-) 5000 maximum variables 2. New update available; type -update all-
1 . 2 . import excel "/Users/zhijing422/Desktop/2.xlsx", sheet("Sheet1") firstrow
3 . des UnemploymentRate Female Bachelor PopulationGrowthRate Native Age2534
storage display value variable name type format label variable label
UnemploymentR~e double %14.2f Unemployment Rate Female double %14.2f %Female Bachelor double %14.2f %Bachelor PopulationGro~e double %14.2f %Population Growth Rate Native double %14.2f %Native Age2534 double %10.0g %Age25-34
4 . reg UnemploymentRate Female Bachelor PopulationGrowthRate Native Age2534
Source SS df MS Number of obs = 51 F( 5, 45) = 4.79
Model 103.366118 5 20.6732236 Prob > F = 0.0014 Residual 194.408 45 4.32017777 R-squared = 0.3471
Adj R-squared = 0.2746 Total 297.774118 50 5.95548235 Root MSE = 2.0785
UnemploymentR~e Coef. Std. Err. t P>|t| [95% Conf. Interval]
Female 1.206254 .527296 2.29 0.027 .1442252 2.268283 Bachelor -.2116358 .1102866 -1.92 0.061 -.4337644 .0104929
Monday, November 30, 2015 at 4:49 PM Page 2
User: Zhijing Zhang
PopulationGro~e .1536832 .0481323 3.19 0.003 .0567398 .2506265 Native -.1034367 .1199954 -0.86 0.393 -.3451198 .1382464 Age2534 .0480302 .229291 0.21 0.835 -.4137856 .5098461 _cons -50.48779 26.74174 -1.89 0.065 -104.3484 3.372837
5 .