{\rtf1\ansi\ansicpg1252\cocoartf949\cocoasubrtf540 {\fonttbl\f0\fmodern\fcharset0 Courier;} {\colortbl;\red255\green255\blue255;} \margl1440\margr1440\vieww25020\viewh15120\viewkind0 \pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\ql\qnatural\pardirnatural \f0\fs24 \cf0 --------------------------------------------------------------------------------------------------------------------------------------------\ log: /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/employ_spec_ndx.log\ log type: text\ \ . *SETTING MEMORY HIGHER THAN DEFAULT SETTING B/C OF DATASET SIZE\ \ . set memory 1000m\ \ Current memory allocation\ \ current memory usage\ settable value description (1M = 1024k)\ --------------------------------------------------------------------\ set maxvar 5000 max. variables allowed 2.067M\ set memory 1000M max. data space 1,000.000M\ set matsize 400 max. RHS vars in models 1.254M\ -----------\ 1,003.321M\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *READING IN DATA\ \ . use "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_98.dta"\ \ . save "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/employ_spec_ndx.dta"\ file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/employ_spec_ndx.dta saved\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_99.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_00.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_01.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_02.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_03.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_04.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_05.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_06.dta"\ \ . append using "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/cew2dig_request_counties_07.dta"\ \ . edit\ - preserve\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *DESCRIBE AND SUMMARIZE DATA\ \ . describe\ \ Contains data from /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/employ_spec_ndx.dta\ obs: 591,851 \ vars: 11 \ size: 89,961,352 (91.4% of memory free)\ --------------------------------------------------------------------------------------------------------------------------------------------\ storage display value\ variable name type format label variable label\ --------------------------------------------------------------------------------------------------------------------------------------------\ year int %8.0g \ statefips byte %8.0g \ countyfips int %8.0g \ areaname str48 %48s \ industry_title str72 %72s \ naics_code str5 %9s \ disc byte %8.0g \ establishments long %12.0g \ employment long %12.0g \ annual_wages double %10.0g \ agglev byte %8.0g \ --------------------------------------------------------------------------------------------------------------------------------------------\ Sorted by: \ Note: dataset has changed since last saved\ \ . summarize\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ year | 591851 2002.917 2.744328 1998 2007\ statefips | 591851 30.29423 15.16759 1 56\ countyfips | 591851 113.7949 145.2176 1 999\ areaname | 0\ industry_t~e | 0\ -------------+--------------------------------------------------------\ naics_code | 0\ disc | 591851 .4384093 .6594081 0 3\ establishm~s | 591851 270.4611 2361.569 0 397584\ employment | 591851 4166.109 35719.75 0 4200998\ annual_wages | 591851 1.59e+08 1.70e+09 0 2.38e+11\ -------------+--------------------------------------------------------\ agglev | 591851 73.7855 .9011054 70 74\ \ . edit\ - preserve\ \ . save, replace\ file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/employ_spec_ndx.dta saved\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *DROPPING UNWANTED VARIABLES AND NON-COUNTY OBSERVATIONS\ \ . drop disc\ \ . drop establishments\ \ . drop annual_wages\ \ . drop agglev\ \ . drop if countyfips==999\ (7199 observations deleted)\ \ . *countyfips==999 were dropped because they do not correspond to a single county and thus will not match other team data\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . **CONVERTING naics_code TO A NUMERIC VAR\ \ . destring naics_code, ignore("-") replace\ naics_code: characters - removed; replaced as int\ \ . foreach var of varlist naics_code\{\ 2. replace `var'=31 if `var'==3133\ 3. replace `var'=44 if `var'==4445\ 4. replace `var'=48 if `var'==4849\ 5. \}\ (29499 real changes made)\ (31110 real changes made)\ (31389 real changes made)\ \ . edit\ - preserve\ \ . ***DROPPING COUNTY TOTALS IN ORIGINAL DATA BECAUSE THEY ARE INCORRECT\ \ . drop if naics_code==0\ (31399 observations deleted)\ \ . save, replace\ file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/employ_spec_ndx.dta saved\ \ . edit\ - preserve\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *ADDING VAR LABELS\ \ . label variable year `"YEAR"'\ \ . label variable statefips `"STATE FIPS CODE"'\ \ . label variable countyfips `"COUNTY FIPS CODE"'\ \ . label variable areaname `"COUNTY NAME"'\ \ . label variable industry_title `"NAICS INDUSTRY NAME"'\ \ . label variable naics_code `"NAICS INDUSTRY CODE"'\ \ . label variable employment `"NUMBER OF EMPLOYEES IN INDUSTRY IN COUNTY"'\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *RESHAPING THE DATA FROM LONG TO WIDE\ \ . reshape wide employment, i( statefips countyfips year) j( naics_code)\ (note: j = 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 92 99)\ industry_title not constant within statefips countyfips year\ Type "reshape error" for a listing of the problem observations.\ r(9);\ \ . *CORRECTING RESHAPE ERROR BY DROPPING industry_title VAR\ \ . drop industry_title\ \ . reshape wide employment, i( statefips countyfips year) j( naics_code)\ (note: j = 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 92 99)\ \ Data long -> wide\ -----------------------------------------------------------------------------\ Number of obs. 553253 -> 31399\ Number of variables 6 -> 25\ j variable (21 values) naics_code -> (dropped)\ xij variables:\ employment -> employment11 employment21 ... employment99\ -----------------------------------------------------------------------------\ \ . *ADDING VAR LABELS\ \ . foreach var of varlist employment11-employment99\{\ 2. label variable `var' `"total # of employees in county in given naics industry in given year"'\ 3. \}\ \ . edit\ - preserve\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *INSPECTING DATA\ \ . describe\ \ Contains data\ obs: 31,399 \ vars: 25 \ size: 4,427,259 (99.6% of memory free)\ --------------------------------------------------------------------------------------------------------------------------------------------\ storage display value\ variable name type format label variable label\ --------------------------------------------------------------------------------------------------------------------------------------------\ year int %8.0g YEAR\ statefips byte %8.0g STATE FIPS CODE\ countyfips int %8.0g COUNTY FIPS CODE\ employment11 long %12.0g total # of employees in county in given naics industry in given year\ employment21 long %12.0g total # of employees in county in given naics industry in given year\ employment22 long %12.0g total # of employees in county in given naics industry in given year\ employment23 long %12.0g total # of employees in county in given naics industry in given year\ employment31 long %12.0g total # of employees in county in given naics industry in given year\ employment42 long %12.0g total # of employees in county in given naics industry in given year\ employment44 long %12.0g total # of employees in county in given naics industry in given year\ employment48 long %12.0g total # of employees in county in given naics industry in given year\ employment51 long %12.0g total # of employees in county in given naics industry in given year\ employment52 long %12.0g total # of employees in county in given naics industry in given year\ employment53 long %12.0g total # of employees in county in given naics industry in given year\ employment54 long %12.0g total # of employees in county in given naics industry in given year\ employment55 long %12.0g total # of employees in county in given naics industry in given year\ employment56 long %12.0g total # of employees in county in given naics industry in given year\ employment61 long %12.0g total # of employees in county in given naics industry in given year\ employment62 long %12.0g total # of employees in county in given naics industry in given year\ employment71 long %12.0g total # of employees in county in given naics industry in given year\ employment72 long %12.0g total # of employees in county in given naics industry in given year\ employment81 long %12.0g total # of employees in county in given naics industry in given year\ employment92 long %12.0g total # of employees in county in given naics industry in given year\ employment99 long %12.0g total # of employees in county in given naics industry in given year\ areaname str48 %48s COUNTY NAME\ --------------------------------------------------------------------------------------------------------------------------------------------\ Sorted by: statefips countyfips year\ Note: dataset has changed since last saved\ \ . summarize\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ year | 31399 2002.501 2.872382 1998 2007\ statefips | 31399 30.31125 15.13248 1 56\ countyfips | 31399 103.7781 108.0168 1 840\ employment11 | 24910 315.6644 1943.316 0 59543\ employment21 | 19550 227.5072 1573.577 0 76676\ -------------+--------------------------------------------------------\ employment22 | 23507 220.0231 945.5911 0 29138\ employment23 | 29632 2236.28 7503.009 0 176196\ employment31 | 29499 5211.763 16805.03 0 649583\ employment42 | 28290 1800.876 7816.081 0 230550\ employment44 | 31110 4813.217 15008.64 0 426942\ -------------+--------------------------------------------------------\ employment48 | 31389 1401.317 6600.029 0 190012\ employment51 | 27856 1157.85 6324.204 0 220228\ employment52 | 28786 1948.307 9550.847 0 328486\ employment53 | 27559 728.7833 3242.694 0 79876\ employment54 | 28109 2319.103 11693.73 0 293082\ -------------+--------------------------------------------------------\ employment55 | 17669 921.7069 3783.588 0 97370\ employment56 | 26455 2738.842 11318.36 0 275458\ employment61 | 26010 2176.361 11204.41 0 380700\ employment62 | 27187 4909.562 16557.17 0 430768\ employment71 | 26566 722.3168 2855.543 0 82692\ -------------+--------------------------------------------------------\ employment72 | 27499 3679.041 12363.08 0 325514\ employment81 | 29418 1420.932 6118.959 0 262236\ employment92 | 31273 2071.526 7789.482 0 179110\ employment99 | 10979 71.8212 396.6344 0 10034\ areaname | 0\ \ . **APPARENTLY THERE ARE COUNTIES WHICH WERE NOT IN EXISTENCE FOR THE ENTIRE TEN YEAR PERIOD EXAMINED; SOME WERE BORN; SOME DIED**\ \ . */NUMBER OF OBS NOT CONSTANT BECAUSE OF MISSINGNESS. PRIOR TO 2001 IF THERE WERE 0 EMPLOYEES IN A GIVEN COUNTY FOR A GIVEN INDUSTRY THE INDUSTRY WAS SIMPLY NOT INCLUDED. HOWEVER, BEGINNING IN 2001 ZERO VALUES WERE LISTED AS ZERO VALUES AS OPPOSED TO BEING DISINCLUDED. ALSO, NOT ALL COUNTIES HAVE ENTRIES FOR ALL INDUSTRIES, EVEN IN YEARS 2001-2007./*\ \ . *TREATING MISSINGNESS\ \ . foreach var of varlist employment11- employment99\{\ 2. replace `var'=0 if `var'==.\ 3. \}\ (6489 real changes made)\ (11849 real changes made)\ (7892 real changes made)\ (1767 real changes made)\ (1900 real changes made)\ (3109 real changes made)\ (289 real changes made)\ (10 real changes made)\ (3543 real changes made)\ (2613 real changes made)\ (3840 real changes made)\ (3290 real changes made)\ (13730 real changes made)\ (4944 real changes made)\ (5389 real changes made)\ (4212 real changes made)\ (4833 real changes made)\ (3900 real changes made)\ (1981 real changes made)\ (126 real changes made)\ (20420 real changes made)\ \ . summarize\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ year | 31399 2002.501 2.872382 1998 2007\ statefips | 31399 30.31125 15.13248 1 56\ countyfips | 31399 103.7781 108.0168 1 840\ employment11 | 31399 250.4284 1735.608 0 59543\ employment21 | 31399 141.6531 1246.538 0 76676\ -------------+--------------------------------------------------------\ employment22 | 31399 164.7213 823.7149 0 29138\ employment23 | 31399 2110.432 7307.024 0 176196\ employment31 | 31399 4896.392 16335.97 0 649583\ employment42 | 31399 1622.561 7438.5 0 230550\ employment44 | 31399 4768.915 14946.48 0 426942\ -------------+--------------------------------------------------------\ employment48 | 31399 1400.87 6599.026 0 190012\ employment51 | 31399 1027.201 5967.964 0 220228\ employment52 | 31399 1786.17 9160.617 0 328486\ employment53 | 31399 639.6554 3047.307 0 79876\ employment54 | 31399 2076.106 11086.9 0 293082\ -------------+--------------------------------------------------------\ employment55 | 31399 518.6675 2874.815 0 97370\ employment56 | 31399 2307.591 10436.89 0 275458\ employment61 | 31399 1802.833 10230.61 0 380700\ employment62 | 31399 4250.972 15497.23 0 430768\ employment71 | 31399 611.1362 2639.495 0 82692\ -------------+--------------------------------------------------------\ employment72 | 31399 3222.075 11633.27 0 325514\ employment81 | 31399 1331.284 5932.849 0 262236\ employment92 | 31399 2063.213 7774.94 0 179110\ employment99 | 31399 25.11306 237.019 0 10034\ areaname | 0\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *CREATING TOTAL OF EMPLOYEES IN EACH COUNTY\ \ . gen cntyemploymenttot=( employment11 + employment21 + employment22 + employment23 + employment31+ employment42 + employment44 + employment48 + employment51 + employment52 + employment53 + employment54 + employment55 + employment56 + employment61 + employment62 + employment71 + employment72 + employment81 + employment92 + employment99)\ \ . *ADDING DESCRIPTIVE LABEL\ \ . label variable cntyemploymenttot `"total # of employees in each county across all industries"'\ \ . edit\ - preserve\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *CREATING EMPLOYMENT SHARES\ \ . foreach var of varlist employment11- employment99\{\ 2. gen shr`var'=`var'/ cntyemploymenttot\ 3. \}\ \ . *ADDING DESCRIPTIVE LABELS\ \ . foreach var of varlist shremployment11- shremployment99\{\ 2. label variable `var' `"share of county's employees in given naics industry"'\ 3. \}\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ . gen countyid=((statefips*1000)+countyfips)\ \ . edit\ - preserve\ \ . label variable countyid `"last three digits are the county fips; preceeding digits are the state fips"'\ \ . summarize\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ year | 31399 2002.501 2.872382 1998 2007\ statefips | 31399 30.31125 15.13248 1 56\ countyfips | 31399 103.7781 108.0168 1 840\ employment11 | 31399 250.4284 1735.608 0 59543\ employment21 | 31399 141.6531 1246.538 0 76676\ -------------+--------------------------------------------------------\ employment22 | 31399 164.7213 823.7149 0 29138\ employment23 | 31399 2110.432 7307.024 0 176196\ employment31 | 31399 4896.392 16335.97 0 649583\ employment42 | 31399 1622.561 7438.5 0 230550\ employment44 | 31399 4768.915 14946.48 0 426942\ -------------+--------------------------------------------------------\ employment48 | 31399 1400.87 6599.026 0 190012\ employment51 | 31399 1027.201 5967.964 0 220228\ employment52 | 31399 1786.17 9160.617 0 328486\ employment53 | 31399 639.6554 3047.307 0 79876\ employment54 | 31399 2076.106 11086.9 0 293082\ -------------+--------------------------------------------------------\ employment55 | 31399 518.6675 2874.815 0 97370\ employment56 | 31399 2307.591 10436.89 0 275458\ employment61 | 31399 1802.833 10230.61 0 380700\ employment62 | 31399 4250.972 15497.23 0 430768\ employment71 | 31399 611.1362 2639.495 0 82692\ -------------+--------------------------------------------------------\ employment72 | 31399 3222.075 11633.27 0 325514\ employment81 | 31399 1331.284 5932.849 0 262236\ employment92 | 31399 2063.213 7774.94 0 179110\ employment99 | 31399 25.11306 237.019 0 10034\ areaname | 0\ -------------+--------------------------------------------------------\ cntyemploy~t | 31399 37017.99 140425.8 1 4198774\ shremploy~11 | 31399 .022088 .0654921 0 .9967846\ shremploy~21 | 31399 .0126034 .05069 0 .9876633\ shremploy~22 | 31399 .0045944 .0139572 0 .4716981\ shremploy~23 | 31399 .0633279 .0530949 0 .8\ -------------+--------------------------------------------------------\ shremploy~31 | 31399 .1888539 .1561188 0 .8826451\ shremploy~42 | 31399 .0410168 .0481326 0 .765625\ shremploy~44 | 31399 .1721866 .0750409 0 .9433962\ shremploy~48 | 31399 .0412009 .0606496 0 1\ shremploy~51 | 31399 .0149657 .0170367 0 .4262295\ -------------+--------------------------------------------------------\ shremploy~52 | 31399 .0324015 .0254413 0 .5652174\ shremploy~53 | 31399 .0103398 .0102693 0 .4285714\ shremploy~54 | 31399 .0238343 .0299839 0 .9338753\ shremploy~55 | 31399 .0034422 .009524 0 .5526537\ shremploy~56 | 31399 .0279764 .0324395 0 .3749347\ -------------+--------------------------------------------------------\ shremploy~61 | 31399 .040979 .0704823 0 .9310345\ shremploy~62 | 31399 .0864075 .0889907 0 .9473684\ shremploy~71 | 31399 .0136647 .0308098 0 .9574468\ shremploy~72 | 31399 .0776307 .0672655 0 .8\ shremploy~81 | 31399 .033783 .0278775 0 .8\ -------------+--------------------------------------------------------\ shremploy~92 | 31399 .0882742 .0894337 0 .9593496\ shremploy~99 | 31399 .0004291 .0031454 0 .3333333\ totemploy~11 | 31399 7863201 0 7863201 7863201\ totemploy~21 | 31399 4447765 0 4447765 4447765\ totemploy~22 | 31399 5172084 0 5172084 5172084\ -------------+--------------------------------------------------------\ totemploy~23 | 31399 6.63e+07 0 6.63e+07 6.63e+07\ totemploy~31 | 31399 1.54e+08 0 1.54e+08 1.54e+08\ totemploy~42 | 31399 5.09e+07 0 5.09e+07 5.09e+07\ totemploy~44 | 31399 1.50e+08 0 1.50e+08 1.50e+08\ totemploy~48 | 31399 4.40e+07 0 4.40e+07 4.40e+07\ -------------+--------------------------------------------------------\ totemploy~51 | 31399 3.23e+07 0 3.23e+07 3.23e+07\ totemploy~52 | 31399 5.61e+07 0 5.61e+07 5.61e+07\ totemploy~53 | 31399 2.01e+07 0 2.01e+07 2.01e+07\ totemploy~54 | 31399 6.52e+07 0 6.52e+07 6.52e+07\ totemploy~55 | 31399 1.63e+07 0 1.63e+07 1.63e+07\ -------------+--------------------------------------------------------\ totemploy~56 | 31399 7.25e+07 0 7.25e+07 7.25e+07\ totemploy~61 | 31399 5.66e+07 0 5.66e+07 5.66e+07\ totemploy~62 | 31399 1.33e+08 0 1.33e+08 1.33e+08\ totemploy~71 | 31399 1.92e+07 0 1.92e+07 1.92e+07\ totemploy~72 | 31399 1.01e+08 0 1.01e+08 1.01e+08\ -------------+--------------------------------------------------------\ totemploy~81 | 31399 4.18e+07 0 4.18e+07 4.18e+07\ totemploy~92 | 31399 6.48e+07 0 6.48e+07 6.48e+07\ totemploy~99 | 31399 788525 0 788525 788525\ allemp | 31399 1.16e+09 0 1.16e+09 1.16e+09\ othrshrem~11 | 31399 .006765 1.53e-06 .0067156 .006783\ -------------+--------------------------------------------------------\ othrshrem~21 | 31399 .0038266 1.03e-06 .003767 .0038372\ othrshrem~22 | 31399 .0044498 3.81e-07 .00444 .0044584\ othrshrem~23 | 31399 .057011 2.85e-06 .0569469 .0571004\ othrshrem~31 | 31399 .1322706 6.60e-06 .1321604 .1324939\ othrshrem~42 | 31399 .0438317 1.85e-06 .0437873 .043858\ -------------+--------------------------------------------------------\ othrshrem~44 | 31399 .128827 3.95e-06 .1288095 .128957\ othrshrem~48 | 31399 .037843 2.59e-06 .0377854 .0379074\ othrshrem~51 | 31399 .0277487 2.44e-06 .0276551 .0277667\ othrshrem~52 | 31399 .0482514 3.86e-06 .0480541 .0482957\ othrshrem~53 | 31399 .0172796 8.33e-07 .0172445 .0172864\ -------------+--------------------------------------------------------\ othrshrem~54 | 31399 .0560837 3.99e-06 .0559395 .0560991\ othrshrem~55 | 31399 .0140112 1.26e-06 .0139757 .0140265\ othrshrem~56 | 31399 .062337 2.32e-06 .0622652 .0623485\ othrshrem~61 | 31399 .0487015 4.19e-06 .0485428 .0487345\ othrshrem~62 | 31399 .1148353 3.59e-06 .1147492 .1149188\ -------------+--------------------------------------------------------\ othrshrem~71 | 31399 .0165092 9.39e-07 .0164668 .0165218\ othrshrem~72 | 31399 .0870408 3.35e-06 .0868874 .0871038\ othrshrem~81 | 31399 .0359632 1.48e-06 .0358671 .0359774\ othrshrem~92 | 31399 .0557354 3.89e-06 .0556123 .0558043\ othrshrem~99 | 31399 .0006784 1.83e-07 .000671 .0006808\ -------------+--------------------------------------------------------\ sqshrempl~11 | 31399 .004777 .0358539 0 .9935794\ sqshrempl~21 | 31399 .0027282 .0239546 0 .9754787\ sqshrempl~22 | 31399 .0002159 .0036903 0 .2224991\ sqshrempl~23 | 31399 .0068294 .0192905 0 .64\ sqshrempl~31 | 31399 .0600381 .0860801 0 .7790623\ -------------+--------------------------------------------------------\ sqshrempl~42 | 31399 .0039991 .0138153 0 .5861816\ sqshrempl~44 | 31399 .0352792 .0407692 0 .8899964\ sqshrempl~48 | 31399 .0053758 .0442024 0 1\ sqshrempl~51 | 31399 .0005142 .0026888 0 .1816716\ sqshrempl~52 | 31399 .0016971 .0037692 0 .3194707\ -------------+--------------------------------------------------------\ sqshrempl~53 | 31399 .0002124 .0012316 0 .1836735\ sqshrempl~54 | 31399 .0014671 .0112584 0 .8721231\ sqshrempl~55 | 31399 .0001026 .0019136 0 .3054261\ sqshrempl~56 | 31399 .001835 .0049134 0 .140576\ sqshrempl~61 | 31399 .0066469 .0286063 0 .8668252\ -------------+--------------------------------------------------------\ sqshrempl~62 | 31399 .0153854 .0312864 0 .897507\ sqshrempl~71 | 31399 .0011359 .0169168 0 .9167044\ sqshrempl~72 | 31399 .010551 .0212318 0 .64\ sqshrempl~81 | 31399 .0019184 .0106859 0 .64\ sqshrempl~92 | 31399 .0157905 .0486971 0 .9203516\ -------------+--------------------------------------------------------\ sqshrempl~99 | 31399 .0000101 .000751 0 .1111111\ hi | 31399 .176509 .1019763 .0685419 1\ adiffshre~11 | 31399 .0235602 .0629997 2.34e-06 .99002\ adiffshre~21 | 31399 .0145962 .0493303 8.83e-07 .9838402\ adiffshre~22 | 31399 .0057572 .0127153 2.76e-07 .4672484\ -------------+--------------------------------------------------------\ adiffshre~23 | 31399 .0336231 .0415748 4.28e-07 .7429891\ adiffshre~31 | 31399 .1257399 .1084637 9.33e-06 .7503769\ adiffshre~42 | 31399 .0318072 .0362348 4.02e-06 .7217934\ adiffshre~44 | 31399 .0574131 .0649227 4.32e-07 .8145694\ adiffshre~48 | 31399 .0283317 .0537307 1.71e-06 .9621571\ -------------+--------------------------------------------------------\ adiffshre~51 | 31399 .0172631 .012476 1.95e-06 .3984809\ adiffshre~52 | 31399 .024228 .0176499 1.51e-06 .516966\ adiffshre~53 | 31399 .0098705 .0074962 5.33e-07 .4112919\ adiffshre~54 | 31399 .037933 .0223654 3.26e-06 .8777972\ adiffshre~55 | 31399 .0126128 .0065831 9.87e-08 .5386469\ -------------+--------------------------------------------------------\ adiffshre~56 | 31399 .0410893 .0233382 2.55e-06 .3125998\ adiffshre~61 | 31399 .0539855 .0459669 .0000194 .882333\ adiffshre~62 | 31399 .0750404 .0556455 6.03e-06 .8325332\ adiffshre~71 | 31399 .013783 .0277014 6.56e-07 .9409377\ adiffshre~72 | 31399 .0489201 .0471172 9.09e-07 .7129592\ -------------+--------------------------------------------------------\ adiffshre~81 | 31399 .0159755 .0229497 1.90e-07 .7640368\ adiffshre~92 | 31399 .0527722 .0791979 2.24e-08 .9036142\ adiffshre~99 | 31399 .0008444 .0030401 4.85e-07 .332655\ ki | 31399 .7251464 .3146647 .1206218 1.98004\ countyid | 31399 30415.03 15150.8 1001 56045\ \ . ****ABOVE SUMMARIZE DISPLAYS DATA PRE-CORRECTION****\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *Creating other employment shares\ \ . **Creating total employees for each industry\ \ . foreach var of varlist employment11- employment99\{\ 2. by year: egen tot`var'= max(sum(`var'))\ 3. label variable tot`var' `"total employees for naics industry for given year"'\ 4. \}\ \ . **Creating total employees in all counties in all industries\ \ . by year: egen allemp= max (sum(cntyemploymenttot))\ \ . label variable allemp `"total number of employees in all counties in all industries for given year"'\ \ . **Creating other share\ \ . foreach var of varlist employment11-employment99\{\ 2. by year: gen othrshr`var'=(tot`var' - `var')/(allemp - cntyemploymenttot)\ 3. \}\ \ . foreach var of varlist othrshremployment11-othrshremployment99\{\ 2. label variable `var' `"employment shares (by industry) for all other counties"'\ 3. \}\ \ . describe\ \ Contains data from /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full \ > dataset trial/corrected/employ_spec_ndx.dta\ obs: 31,399 \ vars: 135 \ size: 18,242,819 (98.3% of memory free)\ --------------------------------------------------------------------------------------------------------------------------------------------\ storage display value\ variable name type format label variable label\ --------------------------------------------------------------------------------------------------------------------------------------------\ year int %ty YEAR\ statefips byte %8.0g STATE FIPS CODE\ countyfips int %8.0g COUNTY FIPS CODE\ employment11 long %12.0g total # of employees in county in given naics industry in given year\ employment21 long %12.0g total # of employees in county in given naics industry in given year\ employment22 long %12.0g total # of employees in county in given naics industry in given year\ employment23 long %12.0g total # of employees in county in given naics industry in given year\ employment31 long %12.0g total # of employees in county in given naics industry in given year\ employment42 long %12.0g total # of employees in county in given naics industry in given year\ employment44 long %12.0g total # of employees in county in given naics industry in given year\ employment48 long %12.0g total # of employees in county in given naics industry in given year\ employment51 long %12.0g total # of employees in county in given naics industry in given year\ employment52 long %12.0g total # of employees in county in given naics industry in given year\ employment53 long %12.0g total # of employees in county in given naics industry in given year\ employment54 long %12.0g total # of employees in county in given naics industry in given year\ employment55 long %12.0g total # of employees in county in given naics industry in given year\ employment56 long %12.0g total # of employees in county in given naics industry in given year\ employment61 long %12.0g total # of employees in county in given naics industry in given year\ employment62 long %12.0g total # of employees in county in given naics industry in given year\ employment71 long %12.0g total # of employees in county in given naics industry in given year\ employment72 long %12.0g total # of employees in county in given naics industry in given year\ employment81 long %12.0g total # of employees in county in given naics industry in given year\ employment92 long %12.0g total # of employees in county in given naics industry in given year\ employment99 long %12.0g total # of employees in county in given naics industry in given year\ areaname str48 %48s COUNTY NAME\ cntyemploymen~t float %9.0g total # of employees in each county across all industries\ shremployment11 float %9.0g share of county's employees in given naics industry\ shremployment21 float %9.0g share of county's employees in given naics industry\ shremployment22 float %9.0g share of county's employees in given naics industry\ shremployment23 float %9.0g share of county's employees in given naics industry\ shremployment31 float %9.0g share of county's employees in given naics industry\ shremployment42 float %9.0g share of county's employees in given naics industry\ shremployment44 float %9.0g share of county's employees in given naics industry\ shremployment48 float %9.0g share of county's employees in given naics industry\ shremployment51 float %9.0g share of county's employees in given naics industry\ shremployment52 float %9.0g share of county's employees in given naics industry\ shremployment53 float %9.0g share of county's employees in given naics industry\ shremployment54 float %9.0g share of county's employees in given naics industry\ shremployment55 float %9.0g share of county's employees in given naics industry\ shremployment56 float %9.0g share of county's employees in given naics industry\ shremployment61 float %9.0g share of county's employees in given naics industry\ shremployment62 float %9.0g share of county's employees in given naics industry\ shremployment71 float %9.0g share of county's employees in given naics industry\ shremployment72 float %9.0g share of county's employees in given naics industry\ shremployment81 float %9.0g share of county's employees in given naics industry\ shremployment92 float %9.0g share of county's employees in given naics industry\ shremployment99 float %9.0g share of county's employees in given naics industry\ sqshremploym~11 float %9.0g square of own share of employees in industry\ sqshremploym~21 float %9.0g square of own share of employees in industry\ sqshremploym~22 float %9.0g square of own share of employees in industry\ sqshremploym~23 float %9.0g square of own share of employees in industry\ sqshremploym~31 float %9.0g square of own share of employees in industry\ sqshremploym~42 float %9.0g square of own share of employees in industry\ sqshremploym~44 float %9.0g square of own share of employees in industry\ sqshremploym~48 float %9.0g square of own share of employees in industry\ sqshremploym~51 float %9.0g square of own share of employees in industry\ sqshremploym~52 float %9.0g square of own share of employees in industry\ sqshremploym~53 float %9.0g square of own share of employees in industry\ sqshremploym~54 float %9.0g square of own share of employees in industry\ sqshremploym~55 float %9.0g square of own share of employees in industry\ sqshremploym~56 float %9.0g square of own share of employees in industry\ sqshremploym~61 float %9.0g square of own share of employees in industry\ sqshremploym~62 float %9.0g square of own share of employees in industry\ sqshremploym~71 float %9.0g square of own share of employees in industry\ sqshremploym~72 float %9.0g square of own share of employees in industry\ sqshremploym~81 float %9.0g square of own share of employees in industry\ sqshremploym~92 float %9.0g square of own share of employees in industry\ sqshremploym~99 float %9.0g square of own share of employees in industry\ hi float %9.0g Herfindahl Index\ adiffshrempl~11 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~21 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~22 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~23 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~31 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~42 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~44 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~48 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~51 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~52 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~53 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~54 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~55 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~56 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~61 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~62 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~71 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~72 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~81 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~92 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~99 float %9.0g abs val of diff between own and other industry shares\ ki float %9.0g Krugman Index\ countyid float %9.0g last three digits are the county fips; preceeding digits are the state fips\ totemployment11 float %9.0g total employees for naics industry for given year\ totemployment21 float %9.0g total employees for naics industry for given year\ totemployment22 float %9.0g total employees for naics industry for given year\ totemployment23 float %9.0g total employees for naics industry for given year\ totemployment31 float %9.0g total employees for naics industry for given year\ totemployment42 float %9.0g total employees for naics industry for given year\ totemployment44 float %9.0g total employees for naics industry for given year\ totemployment48 float %9.0g total employees for naics industry for given year\ totemployment51 float %9.0g total employees for naics industry for given year\ totemployment52 float %9.0g total employees for naics industry for given year\ totemployment53 float %9.0g total employees for naics industry for given year\ totemployment54 float %9.0g total employees for naics industry for given year\ totemployment55 float %9.0g total employees for naics industry for given year\ totemployment56 float %9.0g total employees for naics industry for given year\ totemployment61 float %9.0g total employees for naics industry for given year\ totemployment62 float %9.0g total employees for naics industry for given year\ totemployment71 float %9.0g total employees for naics industry for given year\ totemployment72 float %9.0g total employees for naics industry for given year\ totemployment81 float %9.0g total employees for naics industry for given year\ totemployment92 float %9.0g total employees for naics industry for given year\ totemployment99 float %9.0g total employees for naics industry for given year\ allemp float %9.0g total number of employees in all counties in all industries for given year\ othrshremplo~11 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~21 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~22 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~23 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~31 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~42 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~44 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~48 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~51 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~52 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~53 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~54 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~55 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~56 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~61 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~62 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~71 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~72 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~81 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~92 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~99 float %9.0g employment shares (by industry) for all other counties for given year\ --------------------------------------------------------------------------------------------------------------------------------------------\ Sorted by: year statefips countyfips\ Note: dataset has changed since last saved\ \ . summarize\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ year | 31399 2002.501 2.872382 1998 2007\ statefips | 31399 30.31125 15.13248 1 56\ countyfips | 31399 103.7781 108.0168 1 840\ employment11 | 31399 250.4284 1735.608 0 59543\ employment21 | 31399 141.6531 1246.538 0 76676\ -------------+--------------------------------------------------------\ employment22 | 31399 164.7213 823.7149 0 29138\ employment23 | 31399 2110.432 7307.024 0 176196\ employment31 | 31399 4896.392 16335.97 0 649583\ employment42 | 31399 1622.561 7438.5 0 230550\ employment44 | 31399 4768.915 14946.48 0 426942\ -------------+--------------------------------------------------------\ employment48 | 31399 1400.87 6599.026 0 190012\ employment51 | 31399 1027.201 5967.964 0 220228\ employment52 | 31399 1786.17 9160.617 0 328486\ employment53 | 31399 639.6554 3047.307 0 79876\ employment54 | 31399 2076.106 11086.9 0 293082\ -------------+--------------------------------------------------------\ employment55 | 31399 518.6675 2874.815 0 97370\ employment56 | 31399 2307.591 10436.89 0 275458\ employment61 | 31399 1802.833 10230.61 0 380700\ employment62 | 31399 4250.972 15497.23 0 430768\ employment71 | 31399 611.1362 2639.495 0 82692\ -------------+--------------------------------------------------------\ employment72 | 31399 3222.075 11633.27 0 325514\ employment81 | 31399 1331.284 5932.849 0 262236\ employment92 | 31399 2063.213 7774.94 0 179110\ employment99 | 31399 25.11306 237.019 0 10034\ areaname | 0\ -------------+--------------------------------------------------------\ cntyemploy~t | 31399 37017.99 140425.8 1 4198774\ shremploy~11 | 31399 .022088 .0654921 0 .9967846\ shremploy~21 | 31399 .0126034 .05069 0 .9876633\ shremploy~22 | 31399 .0045944 .0139572 0 .4716981\ shremploy~23 | 31399 .0633279 .0530949 0 .8\ -------------+--------------------------------------------------------\ shremploy~31 | 31399 .1888539 .1561188 0 .8826451\ shremploy~42 | 31399 .0410168 .0481326 0 .765625\ shremploy~44 | 31399 .1721866 .0750409 0 .9433962\ shremploy~48 | 31399 .0412009 .0606496 0 1\ shremploy~51 | 31399 .0149657 .0170367 0 .4262295\ -------------+--------------------------------------------------------\ shremploy~52 | 31399 .0324015 .0254413 0 .5652174\ shremploy~53 | 31399 .0103398 .0102693 0 .4285714\ shremploy~54 | 31399 .0238343 .0299839 0 .9338753\ shremploy~55 | 31399 .0034422 .009524 0 .5526537\ shremploy~56 | 31399 .0279764 .0324395 0 .3749347\ -------------+--------------------------------------------------------\ shremploy~61 | 31399 .040979 .0704823 0 .9310345\ shremploy~62 | 31399 .0864075 .0889907 0 .9473684\ shremploy~71 | 31399 .0136647 .0308098 0 .9574468\ shremploy~72 | 31399 .0776307 .0672655 0 .8\ shremploy~81 | 31399 .033783 .0278775 0 .8\ -------------+--------------------------------------------------------\ shremploy~92 | 31399 .0882742 .0894337 0 .9593496\ shremploy~99 | 31399 .0004291 .0031454 0 .3333333\ sqshrempl~11 | 31399 .004777 .0358539 0 .9935794\ sqshrempl~21 | 31399 .0027282 .0239546 0 .9754787\ sqshrempl~22 | 31399 .0002159 .0036903 0 .2224991\ -------------+--------------------------------------------------------\ sqshrempl~23 | 31399 .0068294 .0192905 0 .64\ sqshrempl~31 | 31399 .0600381 .0860801 0 .7790623\ sqshrempl~42 | 31399 .0039991 .0138153 0 .5861816\ sqshrempl~44 | 31399 .0352792 .0407692 0 .8899964\ sqshrempl~48 | 31399 .0053758 .0442024 0 1\ -------------+--------------------------------------------------------\ sqshrempl~51 | 31399 .0005142 .0026888 0 .1816716\ sqshrempl~52 | 31399 .0016971 .0037692 0 .3194707\ sqshrempl~53 | 31399 .0002124 .0012316 0 .1836735\ sqshrempl~54 | 31399 .0014671 .0112584 0 .8721231\ sqshrempl~55 | 31399 .0001026 .0019136 0 .3054261\ -------------+--------------------------------------------------------\ sqshrempl~56 | 31399 .001835 .0049134 0 .140576\ sqshrempl~61 | 31399 .0066469 .0286063 0 .8668252\ sqshrempl~62 | 31399 .0153854 .0312864 0 .897507\ sqshrempl~71 | 31399 .0011359 .0169168 0 .9167044\ sqshrempl~72 | 31399 .010551 .0212318 0 .64\ -------------+--------------------------------------------------------\ sqshrempl~81 | 31399 .0019184 .0106859 0 .64\ sqshrempl~92 | 31399 .0157905 .0486971 0 .9203516\ sqshrempl~99 | 31399 .0000101 .000751 0 .1111111\ hi | 31399 .176509 .1019763 .0685419 1\ adiffshre~11 | 31399 .0235602 .0629997 2.34e-06 .99002\ -------------+--------------------------------------------------------\ adiffshre~21 | 31399 .0145962 .0493303 8.83e-07 .9838402\ adiffshre~22 | 31399 .0057572 .0127153 2.76e-07 .4672484\ adiffshre~23 | 31399 .0336231 .0415748 4.28e-07 .7429891\ adiffshre~31 | 31399 .1257399 .1084637 9.33e-06 .7503769\ adiffshre~42 | 31399 .0318072 .0362348 4.02e-06 .7217934\ -------------+--------------------------------------------------------\ adiffshre~44 | 31399 .0574131 .0649227 4.32e-07 .8145694\ adiffshre~48 | 31399 .0283317 .0537307 1.71e-06 .9621571\ adiffshre~51 | 31399 .0172631 .012476 1.95e-06 .3984809\ adiffshre~52 | 31399 .024228 .0176499 1.51e-06 .516966\ adiffshre~53 | 31399 .0098705 .0074962 5.33e-07 .4112919\ -------------+--------------------------------------------------------\ adiffshre~54 | 31399 .037933 .0223654 3.26e-06 .8777972\ adiffshre~55 | 31399 .0126128 .0065831 9.87e-08 .5386469\ adiffshre~56 | 31399 .0410893 .0233382 2.55e-06 .3125998\ adiffshre~61 | 31399 .0539855 .0459669 .0000194 .882333\ adiffshre~62 | 31399 .0750404 .0556455 6.03e-06 .8325332\ -------------+--------------------------------------------------------\ adiffshre~71 | 31399 .013783 .0277014 6.56e-07 .9409377\ adiffshre~72 | 31399 .0489201 .0471172 9.09e-07 .7129592\ adiffshre~81 | 31399 .0159755 .0229497 1.90e-07 .7640368\ adiffshre~92 | 31399 .0527722 .0791979 2.24e-08 .9036142\ adiffshre~99 | 31399 .0008444 .0030401 4.85e-07 .332655\ -------------+--------------------------------------------------------\ ki | 31399 .7251464 .3146647 .1206218 1.98004\ countyid | 31399 30415.03 15150.8 1001 56045\ totemploy~11 | 31399 4159632 2327239 670401 7863201\ totemploy~21 | 31399 2300966 1277816 413335 4447765\ totemploy~22 | 31399 2736127 1537685 430385 5172084\ -------------+--------------------------------------------------------\ totemploy~23 | 31399 3.50e+07 1.93e+07 5744479 6.63e+07\ totemploy~31 | 31399 8.85e+07 4.32e+07 1.74e+07 1.54e+08\ totemploy~42 | 31399 2.78e+07 1.46e+07 4954984 5.09e+07\ totemploy~44 | 31399 8.18e+07 4.31e+07 1.45e+07 1.50e+08\ totemploy~48 | 31399 2.39e+07 1.27e+07 4163527 4.40e+07\ -------------+--------------------------------------------------------\ totemploy~51 | 31399 1.81e+07 9298364 3175672 3.23e+07\ totemploy~52 | 31399 3.03e+07 1.62e+07 5245120 5.61e+07\ totemploy~53 | 31399 1.08e+07 5806822 1876903 2.01e+07\ totemploy~54 | 31399 3.48e+07 1.89e+07 5788306 6.52e+07\ totemploy~55 | 31399 8869507 4656678 1580819 1.63e+07\ -------------+--------------------------------------------------------\ totemploy~56 | 31399 3.91e+07 2.08e+07 6718719 7.25e+07\ totemploy~61 | 31399 2.92e+07 1.68e+07 4457056 5.66e+07\ totemploy~62 | 31399 7.01e+07 3.90e+07 1.17e+07 1.33e+08\ totemploy~71 | 31399 1.02e+07 5575215 1728173 1.92e+07\ totemploy~72 | 31399 5.38e+07 2.93e+07 9154813 1.01e+08\ -------------+--------------------------------------------------------\ totemploy~81 | 31399 2.26e+07 1.21e+07 3939215 4.18e+07\ totemploy~92 | 31399 3.51e+07 1.88e+07 6074630 6.48e+07\ totemploy~99 | 31399 305102.5 279886.7 0 788525\ allemp | 31399 6.29e+08 3.35e+08 1.10e+08 1.16e+09\ othrshrem~11 | 31399 .0064666 .0002819 .0055855 .006783\ -------------+--------------------------------------------------------\ othrshrem~21 | 31399 .0036242 .0001155 .0032802 .0038772\ othrshrem~22 | 31399 .0042365 .00022 .0037981 .0044598\ othrshrem~23 | 31399 .0549514 .0013816 .0520408 .0570911\ othrshrem~31 | 31399 .1452652 .0089224 .1322269 .1612278\ othrshrem~42 | 31399 .0444698 .0004421 .0437915 .045379\ -------------+--------------------------------------------------------\ othrshrem~44 | 31399 .1304365 .0010475 .1288156 .1332048\ othrshrem~48 | 31399 .0379361 .0000987 .037387 .0385234\ othrshrem~51 | 31399 .0290252 .0006784 .0276634 .0298927\ othrshrem~52 | 31399 .0479531 .0002621 .0457083 .0483145\ othrshrem~53 | 31399 .0171613 .0000757 .0167487 .0172835\ -------------+--------------------------------------------------------\ othrshrem~54 | 31399 .0548201 .0009026 .0514268 .0560991\ othrshrem~55 | 31399 .0141846 .0001928 .0139641 .0145836\ othrshrem~56 | 31399 .0621082 .0004359 .060734 .0629916\ othrshrem~61 | 31399 .0448198 .0028749 .0391236 .0487336\ othrshrem~62 | 31399 .1096962 .0032966 .1054107 .1148797\ -------------+--------------------------------------------------------\ othrshrem~71 | 31399 .0161458 .0002586 .0153671 .0165202\ othrshrem~72 | 31399 .0848231 .0013 .082213 .0870753\ othrshrem~81 | 31399 .0359312 .0000954 .0355091 .0360724\ othrshrem~92 | 31399 .0555969 .0002749 .0542465 .0561073\ othrshrem~99 | 31399 .0003483 .0002627 0 .0006791\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . *CREATING INDICIES\ \ . **HI\ \ . **Creating squares of own shares\ \ . foreach var of varlist shremployment11-shremployment99\{\ 2. gen sq`var'=(`var')^2\ 3. label variable sq`var' `"square of own share of employees in industry"'\ 4. \}\ \ . gen hi = (sqshremployment11 + sqshremployment21 + sqshremployment22 + sqshremployment23 + sqshremployment31+ sqshremployment42 + sqshremployment44 + sqshremployment48 + sqshremployment51 + sqshremployment52 + sqshremployment53 + sqshremployment54 + sqshremployment55 + sqshremployment56 + sqshremployment61 + sqshremployment62 + sqshremployment71 + sqshremployment72 + sqshremployment81 + sqshremployment92 + sqshremployment99)\ \ . label variable hi `"Herfindahl Index"'\ \ . *******************************************************************\ \ . **KI\ \ . **Creating abs val of diff between own and other industry shares\ \ . foreach var of varlist shremployment11-shremployment99\{\ 2. gen adiff`var'=abs(`var' - othr`var')\ 3. \}\ \ . **Adding labels\ \ . foreach var of varlist adiffshremployment11-adiffshremployment99\{\ 2. label variable `var' `"abs val of diff between own and other industry shares"'\ 3. \}\ \ . gen ki = (adiffshremployment11 + adiffshremployment21 + adiffshremployment22 + adiffshremployment23 + adiffshremployment31+ adiffshremployment42 + adiffshremployment44 + adiffshremployment48 + adiffshremployment51 + adiffshremployment52 + adiffshremployment53 + adiffshremployment54 + adiffshremployment55 + adiffshremployment56 + adiffshremployment61 + adiffshremployment62 + adiffshremployment71 + adiffshremployment72 + adiffshremployment81 + adiffshremployment92 + adiffshremployment99)\ \ . label variable ki `"Krugman Index "'\ \ . *******************************************************************\ . describe\ \ Contains data from /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full \ > dataset trial/corrected/employ_spec_ndx.dta\ obs: 31,399 \ vars: 135 \ size: 18,242,819 (98.3% of memory free)\ --------------------------------------------------------------------------------------------------------------------------------------------\ storage display value\ variable name type format label variable label\ --------------------------------------------------------------------------------------------------------------------------------------------\ year int %ty YEAR\ statefips byte %8.0g STATE FIPS CODE\ countyfips int %8.0g COUNTY FIPS CODE\ employment11 long %12.0g total # of employees in county in given naics industry in given year\ employment21 long %12.0g total # of employees in county in given naics industry in given year\ employment22 long %12.0g total # of employees in county in given naics industry in given year\ employment23 long %12.0g total # of employees in county in given naics industry in given year\ employment31 long %12.0g total # of employees in county in given naics industry in given year\ employment42 long %12.0g total # of employees in county in given naics industry in given year\ employment44 long %12.0g total # of employees in county in given naics industry in given year\ employment48 long %12.0g total # of employees in county in given naics industry in given year\ employment51 long %12.0g total # of employees in county in given naics industry in given year\ employment52 long %12.0g total # of employees in county in given naics industry in given year\ employment53 long %12.0g total # of employees in county in given naics industry in given year\ employment54 long %12.0g total # of employees in county in given naics industry in given year\ employment55 long %12.0g total # of employees in county in given naics industry in given year\ employment56 long %12.0g total # of employees in county in given naics industry in given year\ employment61 long %12.0g total # of employees in county in given naics industry in given year\ employment62 long %12.0g total # of employees in county in given naics industry in given year\ employment71 long %12.0g total # of employees in county in given naics industry in given year\ employment72 long %12.0g total # of employees in county in given naics industry in given year\ employment81 long %12.0g total # of employees in county in given naics industry in given year\ employment92 long %12.0g total # of employees in county in given naics industry in given year\ employment99 long %12.0g total # of employees in county in given naics industry in given year\ areaname str48 %48s COUNTY NAME\ cntyemploymen~t float %9.0g total # of employees in each county across all industries\ shremployment11 float %9.0g share of county's employees in given naics industry\ shremployment21 float %9.0g share of county's employees in given naics industry\ shremployment22 float %9.0g share of county's employees in given naics industry\ shremployment23 float %9.0g share of county's employees in given naics industry\ shremployment31 float %9.0g share of county's employees in given naics industry\ shremployment42 float %9.0g share of county's employees in given naics industry\ shremployment44 float %9.0g share of county's employees in given naics industry\ shremployment48 float %9.0g share of county's employees in given naics industry\ shremployment51 float %9.0g share of county's employees in given naics industry\ shremployment52 float %9.0g share of county's employees in given naics industry\ shremployment53 float %9.0g share of county's employees in given naics industry\ shremployment54 float %9.0g share of county's employees in given naics industry\ shremployment55 float %9.0g share of county's employees in given naics industry\ shremployment56 float %9.0g share of county's employees in given naics industry\ shremployment61 float %9.0g share of county's employees in given naics industry\ shremployment62 float %9.0g share of county's employees in given naics industry\ shremployment71 float %9.0g share of county's employees in given naics industry\ shremployment72 float %9.0g share of county's employees in given naics industry\ shremployment81 float %9.0g share of county's employees in given naics industry\ shremployment92 float %9.0g share of county's employees in given naics industry\ shremployment99 float %9.0g share of county's employees in given naics industry\ sqshremploym~11 float %9.0g square of own share of employees in industry\ sqshremploym~21 float %9.0g square of own share of employees in industry\ sqshremploym~22 float %9.0g square of own share of employees in industry\ sqshremploym~23 float %9.0g square of own share of employees in industry\ sqshremploym~31 float %9.0g square of own share of employees in industry\ sqshremploym~42 float %9.0g square of own share of employees in industry\ sqshremploym~44 float %9.0g square of own share of employees in industry\ sqshremploym~48 float %9.0g square of own share of employees in industry\ sqshremploym~51 float %9.0g square of own share of employees in industry\ sqshremploym~52 float %9.0g square of own share of employees in industry\ sqshremploym~53 float %9.0g square of own share of employees in industry\ sqshremploym~54 float %9.0g square of own share of employees in industry\ sqshremploym~55 float %9.0g square of own share of employees in industry\ sqshremploym~56 float %9.0g square of own share of employees in industry\ sqshremploym~61 float %9.0g square of own share of employees in industry\ sqshremploym~62 float %9.0g square of own share of employees in industry\ sqshremploym~71 float %9.0g square of own share of employees in industry\ sqshremploym~72 float %9.0g square of own share of employees in industry\ sqshremploym~81 float %9.0g square of own share of employees in industry\ sqshremploym~92 float %9.0g square of own share of employees in industry\ sqshremploym~99 float %9.0g square of own share of employees in industry\ hi float %9.0g Herfindahl Index\ countyid float %9.0g last three digits are the county fips; preceeding digits are the state fips\ totemployment11 float %9.0g total employees for naics industry for given year\ totemployment21 float %9.0g total employees for naics industry for given year\ totemployment22 float %9.0g total employees for naics industry for given year\ totemployment23 float %9.0g total employees for naics industry for given year\ totemployment31 float %9.0g total employees for naics industry for given year\ totemployment42 float %9.0g total employees for naics industry for given year\ totemployment44 float %9.0g total employees for naics industry for given year\ totemployment48 float %9.0g total employees for naics industry for given year\ totemployment51 float %9.0g total employees for naics industry for given year\ totemployment52 float %9.0g total employees for naics industry for given year\ totemployment53 float %9.0g total employees for naics industry for given year\ totemployment54 float %9.0g total employees for naics industry for given year\ totemployment55 float %9.0g total employees for naics industry for given year\ totemployment56 float %9.0g total employees for naics industry for given year\ totemployment61 float %9.0g total employees for naics industry for given year\ totemployment62 float %9.0g total employees for naics industry for given year\ totemployment71 float %9.0g total employees for naics industry for given year\ totemployment72 float %9.0g total employees for naics industry for given year\ totemployment81 float %9.0g total employees for naics industry for given year\ totemployment92 float %9.0g total employees for naics industry for given year\ totemployment99 float %9.0g total employees for naics industry for given year\ allemp float %9.0g total number of employees in all counties in all industries for given year\ othrshremplo~11 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~21 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~22 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~23 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~31 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~42 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~44 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~48 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~51 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~52 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~53 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~54 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~55 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~56 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~61 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~62 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~71 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~72 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~81 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~92 float %9.0g employment shares (by industry) for all other counties for given year\ othrshremplo~99 float %9.0g employment shares (by industry) for all other counties for given year\ adiffshrempl~11 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~21 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~22 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~23 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~31 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~42 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~44 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~48 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~51 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~52 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~53 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~54 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~55 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~56 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~61 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~62 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~71 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~72 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~81 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~92 float %9.0g abs val of diff between own and other industry shares\ adiffshrempl~99 float %9.0g abs val of diff between own and other industry shares\ ki float %9.0g Krugman Index\ --------------------------------------------------------------------------------------------------------------------------------------------\ Sorted by: year statefips countyfips\ \ . summarize\ \ Variable | Obs Mean Std. Dev. Min Max\ -------------+--------------------------------------------------------\ year | 31399 2002.501 2.872382 1998 2007\ statefips | 31399 30.31125 15.13248 1 56\ countyfips | 31399 103.7781 108.0168 1 840\ employment11 | 31399 250.4284 1735.608 0 59543\ employment21 | 31399 141.6531 1246.538 0 76676\ -------------+--------------------------------------------------------\ employment22 | 31399 164.7213 823.7149 0 29138\ employment23 | 31399 2110.432 7307.024 0 176196\ employment31 | 31399 4896.392 16335.97 0 649583\ employment42 | 31399 1622.561 7438.5 0 230550\ employment44 | 31399 4768.915 14946.48 0 426942\ -------------+--------------------------------------------------------\ employment48 | 31399 1400.87 6599.026 0 190012\ employment51 | 31399 1027.201 5967.964 0 220228\ employment52 | 31399 1786.17 9160.617 0 328486\ employment53 | 31399 639.6554 3047.307 0 79876\ employment54 | 31399 2076.106 11086.9 0 293082\ -------------+--------------------------------------------------------\ employment55 | 31399 518.6675 2874.815 0 97370\ employment56 | 31399 2307.591 10436.89 0 275458\ employment61 | 31399 1802.833 10230.61 0 380700\ employment62 | 31399 4250.972 15497.23 0 430768\ employment71 | 31399 611.1362 2639.495 0 82692\ -------------+--------------------------------------------------------\ employment72 | 31399 3222.075 11633.27 0 325514\ employment81 | 31399 1331.284 5932.849 0 262236\ employment92 | 31399 2063.213 7774.94 0 179110\ employment99 | 31399 25.11306 237.019 0 10034\ areaname | 0\ -------------+--------------------------------------------------------\ cntyemploy~t | 31399 37017.99 140425.8 1 4198774\ shremploy~11 | 31399 .022088 .0654921 0 .9967846\ shremploy~21 | 31399 .0126034 .05069 0 .9876633\ shremploy~22 | 31399 .0045944 .0139572 0 .4716981\ shremploy~23 | 31399 .0633279 .0530949 0 .8\ -------------+--------------------------------------------------------\ shremploy~31 | 31399 .1888539 .1561188 0 .8826451\ shremploy~42 | 31399 .0410168 .0481326 0 .765625\ shremploy~44 | 31399 .1721866 .0750409 0 .9433962\ shremploy~48 | 31399 .0412009 .0606496 0 1\ shremploy~51 | 31399 .0149657 .0170367 0 .4262295\ -------------+--------------------------------------------------------\ shremploy~52 | 31399 .0324015 .0254413 0 .5652174\ shremploy~53 | 31399 .0103398 .0102693 0 .4285714\ shremploy~54 | 31399 .0238343 .0299839 0 .9338753\ shremploy~55 | 31399 .0034422 .009524 0 .5526537\ shremploy~56 | 31399 .0279764 .0324395 0 .3749347\ -------------+--------------------------------------------------------\ shremploy~61 | 31399 .040979 .0704823 0 .9310345\ shremploy~62 | 31399 .0864075 .0889907 0 .9473684\ shremploy~71 | 31399 .0136647 .0308098 0 .9574468\ shremploy~72 | 31399 .0776307 .0672655 0 .8\ shremploy~81 | 31399 .033783 .0278775 0 .8\ -------------+--------------------------------------------------------\ shremploy~92 | 31399 .0882742 .0894337 0 .9593496\ shremploy~99 | 31399 .0004291 .0031454 0 .3333333\ sqshrempl~11 | 31399 .004777 .0358539 0 .9935794\ sqshrempl~21 | 31399 .0027282 .0239546 0 .9754787\ sqshrempl~22 | 31399 .0002159 .0036903 0 .2224991\ -------------+--------------------------------------------------------\ sqshrempl~23 | 31399 .0068294 .0192905 0 .64\ sqshrempl~31 | 31399 .0600381 .0860801 0 .7790623\ sqshrempl~42 | 31399 .0039991 .0138153 0 .5861816\ sqshrempl~44 | 31399 .0352792 .0407692 0 .8899964\ sqshrempl~48 | 31399 .0053758 .0442024 0 1\ -------------+--------------------------------------------------------\ sqshrempl~51 | 31399 .0005142 .0026888 0 .1816716\ sqshrempl~52 | 31399 .0016971 .0037692 0 .3194707\ sqshrempl~53 | 31399 .0002124 .0012316 0 .1836735\ sqshrempl~54 | 31399 .0014671 .0112584 0 .8721231\ sqshrempl~55 | 31399 .0001026 .0019136 0 .3054261\ -------------+--------------------------------------------------------\ sqshrempl~56 | 31399 .001835 .0049134 0 .140576\ sqshrempl~61 | 31399 .0066469 .0286063 0 .8668252\ sqshrempl~62 | 31399 .0153854 .0312864 0 .897507\ sqshrempl~71 | 31399 .0011359 .0169168 0 .9167044\ sqshrempl~72 | 31399 .010551 .0212318 0 .64\ -------------+--------------------------------------------------------\ sqshrempl~81 | 31399 .0019184 .0106859 0 .64\ sqshrempl~92 | 31399 .0157905 .0486971 0 .9203516\ sqshrempl~99 | 31399 .0000101 .000751 0 .1111111\ hi | 31399 .176509 .1019763 .0685419 1\ countyid | 31399 30415.03 15150.8 1001 56045\ -------------+--------------------------------------------------------\ totemploy~11 | 31399 4159632 2327239 670401 7863201\ totemploy~21 | 31399 2300966 1277816 413335 4447765\ totemploy~22 | 31399 2736127 1537685 430385 5172084\ totemploy~23 | 31399 3.50e+07 1.93e+07 5744479 6.63e+07\ totemploy~31 | 31399 8.85e+07 4.32e+07 1.74e+07 1.54e+08\ -------------+--------------------------------------------------------\ totemploy~42 | 31399 2.78e+07 1.46e+07 4954984 5.09e+07\ totemploy~44 | 31399 8.18e+07 4.31e+07 1.45e+07 1.50e+08\ totemploy~48 | 31399 2.39e+07 1.27e+07 4163527 4.40e+07\ totemploy~51 | 31399 1.81e+07 9298364 3175672 3.23e+07\ totemploy~52 | 31399 3.03e+07 1.62e+07 5245120 5.61e+07\ -------------+--------------------------------------------------------\ totemploy~53 | 31399 1.08e+07 5806822 1876903 2.01e+07\ totemploy~54 | 31399 3.48e+07 1.89e+07 5788306 6.52e+07\ totemploy~55 | 31399 8869507 4656678 1580819 1.63e+07\ totemploy~56 | 31399 3.91e+07 2.08e+07 6718719 7.25e+07\ totemploy~61 | 31399 2.92e+07 1.68e+07 4457056 5.66e+07\ -------------+--------------------------------------------------------\ totemploy~62 | 31399 7.01e+07 3.90e+07 1.17e+07 1.33e+08\ totemploy~71 | 31399 1.02e+07 5575215 1728173 1.92e+07\ totemploy~72 | 31399 5.38e+07 2.93e+07 9154813 1.01e+08\ totemploy~81 | 31399 2.26e+07 1.21e+07 3939215 4.18e+07\ totemploy~92 | 31399 3.51e+07 1.88e+07 6074630 6.48e+07\ -------------+--------------------------------------------------------\ totemploy~99 | 31399 305102.5 279886.7 0 788525\ allemp | 31399 6.29e+08 3.35e+08 1.10e+08 1.16e+09\ othrshrem~11 | 31399 .0064666 .0002819 .0055855 .006783\ othrshrem~21 | 31399 .0036242 .0001155 .0032802 .0038772\ othrshrem~22 | 31399 .0042365 .00022 .0037981 .0044598\ -------------+--------------------------------------------------------\ othrshrem~23 | 31399 .0549514 .0013816 .0520408 .0570911\ othrshrem~31 | 31399 .1452652 .0089224 .1322269 .1612278\ othrshrem~42 | 31399 .0444698 .0004421 .0437915 .045379\ othrshrem~44 | 31399 .1304365 .0010475 .1288156 .1332048\ othrshrem~48 | 31399 .0379361 .0000987 .037387 .0385234\ -------------+--------------------------------------------------------\ othrshrem~51 | 31399 .0290252 .0006784 .0276634 .0298927\ othrshrem~52 | 31399 .0479531 .0002621 .0457083 .0483145\ othrshrem~53 | 31399 .0171613 .0000757 .0167487 .0172835\ othrshrem~54 | 31399 .0548201 .0009026 .0514268 .0560991\ othrshrem~55 | 31399 .0141846 .0001928 .0139641 .0145836\ -------------+--------------------------------------------------------\ othrshrem~56 | 31399 .0621082 .0004359 .060734 .0629916\ othrshrem~61 | 31399 .0448198 .0028749 .0391236 .0487336\ othrshrem~62 | 31399 .1096962 .0032966 .1054107 .1148797\ othrshrem~71 | 31399 .0161458 .0002586 .0153671 .0165202\ othrshrem~72 | 31399 .0848231 .0013 .082213 .0870753\ -------------+--------------------------------------------------------\ othrshrem~81 | 31399 .0359312 .0000954 .0355091 .0360724\ othrshrem~92 | 31399 .0555969 .0002749 .0542465 .0561073\ othrshrem~99 | 31399 .0003483 .0002627 0 .0006791\ adiffshre~11 | 31399 .0234372 .0631159 5.09e-07 .99074\ adiffshre~21 | 31399 .0144686 .0494023 9.66e-07 .9841577\ -------------+--------------------------------------------------------\ adiffshre~22 | 31399 .0056449 .012757 6.35e-07 .4677747\ adiffshre~23 | 31399 .0335261 .0419619 2.42e-07 .7433547\ adiffshre~31 | 31399 .1238639 .1031826 .0000124 .7396737\ adiffshre~42 | 31399 .03201 .0361107 1.55e-06 .720446\ adiffshre~44 | 31399 .0564983 .064502 2.53e-06 .8115585\ -------------+--------------------------------------------------------\ adiffshre~48 | 31399 .0283596 .0537096 1.45e-07 .9621845\ adiffshre~51 | 31399 .0182351 .0124615 1.61e-06 .3964263\ adiffshre~52 | 31399 .0240387 .0176194 4.34e-06 .5176312\ adiffshre~53 | 31399 .0097901 .007489 3.65e-07 .4113795\ adiffshre~54 | 31399 .0368731 .0223034 6.41e-06 .8777972\ -------------+--------------------------------------------------------\ adiffshre~55 | 31399 .0127621 .0065885 6.98e-07 .538174\ adiffshre~56 | 31399 .0409203 .0232982 1.65e-06 .3127822\ adiffshre~61 | 31399 .0522935 .0471311 .0000285 .8877799\ adiffshre~62 | 31399 .0735987 .0549265 1.77e-06 .8414751\ adiffshre~71 | 31399 .0135789 .0277644 6.80e-07 .9414555\ -------------+--------------------------------------------------------\ adiffshre~72 | 31399 .0485505 .0469387 8.57e-07 .7164966\ adiffshre~81 | 31399 .0159699 .022951 3.54e-07 .7639517\ adiffshre~92 | 31399 .0527889 .07925 1.58e-06 .9041063\ adiffshre~99 | 31399 .0005671 .0030833 0 .3327362\ ki | 31399 .7177758 .3131239 .1182985 1.98148\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . sum hi, detail\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0777823 .0685419\ 5% .0889359 .0686369\ 10% .0970627 .0687126 Obs 31399\ 25% .1156338 .0690354 Sum of Wgt. 31399\ \ 50% .1463809 Mean .176509\ Largest Std. Dev. .1019763\ 75% .2030622 1\ 90% .2857737 1 Variance .0103992\ 95% .3572226 1 Skewness 3.155379\ 99% .5961834 1 Kurtosis 18.45719\ \ . sum ki, detail\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2219146 .1182985\ 5% .2922025 .1188617\ 10% .3518239 .1193224 Obs 31399\ 25% .4827211 .1205316 Sum of Wgt. 31399\ \ 50% .6783277 Mean .7177758\ Largest Std. Dev. .3131239\ 75% .8894528 1.968315\ 90% 1.135365 1.978991 Variance .0980466\ 95% 1.313061 1.980611 Skewness .8996701\ 99% 1.717804 1.98148 Kurtosis 3.985956\ \ . correlate hi ki\ (obs=31399)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7784 1.0000\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . by year: sum ki, detail\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 1998\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2179419 .1188617\ 5% .2959009 .1193224\ 10% .3667395 .1556832 Obs 3139\ 25% .5299814 .1682829 Sum of Wgt. 3139\ \ 50% .7575404 Mean .7936597\ Largest Std. Dev. .3498931\ 75% .9927706 1.924073\ 90% 1.265377 1.924075 Variance .1224252\ 95% 1.458029 1.967863 Skewness .6766171\ 99% 1.813294 1.978991 Kurtosis 3.297048\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 1999\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2164561 .1208227\ 5% .2943302 .1231359\ 10% .3648785 .1488332 Obs 3139\ 25% .5293986 .1657949 Sum of Wgt. 3139\ \ 50% .7550576 Mean .7920039\ Largest Std. Dev. .3487854\ 75% .9867615 1.923837\ 90% 1.265072 1.923838 Variance .1216512\ 95% 1.459938 1.967925 Skewness .690619\ 99% 1.81352 1.980611 Kurtosis 3.3389\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2000\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2209841 .1182985\ 5% .2964873 .1205316\ 10% .3690431 .1651904 Obs 3139\ 25% .5310178 .1728487 Sum of Wgt. 3139\ \ 50% .752721 Mean .7908003\ Largest Std. Dev. .3463692\ 75% .9908674 1.923857\ 90% 1.265939 1.923857 Variance .1199716\ 95% 1.456001 1.968315 Skewness .6752428\ 99% 1.81337 1.98148 Kurtosis 3.301185\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2001\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2202073 .139475\ 5% .2956962 .1517151\ 10% .3565536 .1540032 Obs 3140\ 25% .4791853 .166928 Sum of Wgt. 3140\ \ 50% .6629194 Mean .694592\ Largest Std. Dev. .2898598\ 75% .8495948 1.910933\ 90% 1.082412 1.923959 Variance .0840187\ 95% 1.231384 1.923959 Skewness .9345958\ 99% 1.596892 1.929833 Kurtosis 4.318646\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2002\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2198585 .1402371\ 5% .2927427 .161606\ 10% .3536284 .1618984 Obs 3140\ 25% .478653 .1706775 Sum of Wgt. 3140\ \ 50% .6541728 Mean .6909969\ Largest Std. Dev. .2895667\ 75% .8459643 1.924016\ 90% 1.07422 1.924016 Variance .0838489\ 95% 1.22046 1.924016 Skewness .9486557\ 99% 1.623311 1.924016 Kurtosis 4.372446\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2003\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .221155 .1284422\ 5% .2896448 .1430404\ 10% .3507472 .1517543 Obs 3140\ 25% .4704004 .1611596 Sum of Wgt. 3140\ \ 50% .6540128 Mean .6862623\ Largest Std. Dev. .2870168\ 75% .8388861 1.878092\ 90% 1.064671 1.882625 Variance .0823787\ 95% 1.22636 1.924184 Skewness .9029603\ 99% 1.555155 1.924184 Kurtosis 4.176325\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2004\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2220427 .1508057\ 5% .2891947 .1551712\ 10% .3438425 .1684397 Obs 3140\ 25% .4688178 .1734774 Sum of Wgt. 3140\ \ 50% .6490492 Mean .6834318\ Largest Std. Dev. .2895514\ 75% .835177 1.851138\ 90% 1.054282 1.916036 Variance .08384\ 95% 1.212673 1.924312 Skewness .9331395\ 99% 1.581882 1.931372 Kurtosis 4.243299\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2005\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2253193 .158565\ 5% .2870708 .1722567\ 10% .3404763 .1733166 Obs 3140\ 25% .4647659 .174468 Sum of Wgt. 3140\ \ 50% .6441182 Mean .679823\ Largest Std. Dev. .2909804\ 75% .8334409 1.852261\ 90% 1.052241 1.910867 Variance .0846696\ 95% 1.245717 1.923163 Skewness .9668594\ 99% 1.569999 1.945388 Kurtosis 4.294219\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2006\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2266661 .1605699\ 5% .2885276 .1626711\ 10% .3419089 .1698384 Obs 3140\ 25% .4631651 .1777318 Sum of Wgt. 3140\ \ 50% .6489421 Mean .6824866\ Largest Std. Dev. .2927211\ 75% .8415284 1.923054\ 90% 1.063303 1.924369 Variance .0856857\ 95% 1.230875 1.924369 Skewness .9639326\ 99% 1.576091 1.939341 Kurtosis 4.321328\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2007\ \ Krugman Index \ -------------------------------------------------------------\ Percentiles Smallest\ 1% .2290567 .1337708\ 5% .2927078 .1436328\ 10% .3410263 .1566394 Obs 3142\ 25% .4605621 .1664672 Sum of Wgt. 3142\ \ 50% .6450532 Mean .6837939\ Largest Std. Dev. .2973453\ 75% .8376032 1.924314\ 90% 1.060978 1.924314 Variance .0884142\ 95% 1.251201 1.924314 Skewness 1.015891\ 99% 1.620938 1.93327 Kurtosis 4.428842\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . by year: sum hi, detail\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 1998\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .079513 .0702145\ 5% .0913953 .0706174\ 10% .1021718 .0707414 Obs 3139\ 25% .1297439 .0707443 Sum of Wgt. 3139\ \ 50% .1770318 Mean .2119046\ Largest Std. Dev. .1274495\ 75% .2511363 1\ 90% .3612036 1 Variance .0162434\ 95% .4459601 1 Skewness 2.503828\ 99% .7112007 1 Kurtosis 12.40791\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 1999\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0793761 .0696073\ 5% .0907537 .0696087\ 10% .1014405 .0702831 Obs 3139\ 25% .128112 .070605 Sum of Wgt. 3139\ \ 50% .1751329 Mean .2086862\ Largest Std. Dev. .1257189\ 75% .2455439 1\ 90% .3497097 1 Variance .0158052\ 95% .4421714 1 Skewness 2.591645\ 99% .7222222 1 Kurtosis 13.04971\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2000\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0790448 .0696703\ 5% .0902698 .0700224\ 10% .1007172 .0700435 Obs 3139\ 25% .1265204 .0703955 Sum of Wgt. 3139\ \ 50% .1726531 Mean .2054014\ Largest Std. Dev. .1221996\ 75% .2424605 1\ 90% .344978 1 Variance .0149327\ 95% .4346273 1 Skewness 2.574149\ 99% .7040216 1 Kurtosis 12.96712\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2001\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0780389 .0690354\ 5% .0890929 .0695851\ 10% .0973241 .0696755 Obs 3140\ 25% .1156696 .0699405 Sum of Wgt. 3140\ \ 50% .1439312 Mean .1698359\ Largest Std. Dev. .0904789\ 75% .1947866 .9185152\ 90% .269573 .9317806 Variance .0081864\ 95% .3279245 1 Skewness 3.177985\ 99% .5116689 1 Kurtosis 19.69134\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2002\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .077346 .0685419\ 5% .0887388 .0691874\ 10% .0966639 .0695599 Obs 3140\ 25% .113737 .0697425 Sum of Wgt. 3140\ \ 50% .1411652 Mean .166148\ Largest Std. Dev. .0890246\ 75% .1888518 1\ 90% .2614015 1 Variance .0079254\ 95% .3184702 1 Skewness 3.445527\ 99% .5044771 1 Kurtosis 22.68192\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2003\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0774282 .0687126\ 5% .0879573 .0694366\ 10% .0961161 .0700258 Obs 3140\ 25% .1131581 .0700289 Sum of Wgt. 3140\ \ 50% .1396675 Mean .1624619\ Largest Std. Dev. .0835261\ 75% .1858463 .8956445\ 90% .2519757 .905 Variance .0069766\ 95% .3044857 1 Skewness 3.417603\ 99% .4809687 1 Kurtosis 22.94215\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2004\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .077361 .0686369\ 5% .08776 .0694581\ 10% .0954558 .0701104 Obs 3140\ 25% .1119632 .0704807 Sum of Wgt. 3140\ \ 50% .1372809 Mean .1616286\ Largest Std. Dev. .0840876\ 75% .1839272 .8300592\ 90% .2518903 .8347108 Variance .0070707\ 95% .3089913 .946107 Skewness 3.291396\ 99% .5022222 1 Kurtosis 20.67923\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2005\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .077319 .0691048\ 5% .0879711 .0708038\ 10% .0955119 .0710112 Obs 3140\ 25% .111243 .0710802 Sum of Wgt. 3140\ \ 50% .1360122 Mean .1601779\ Largest Std. Dev. .0834975\ 75% .1811499 .8347108\ 90% .2470788 .8528 Variance .0069718\ 95% .3066614 .8568668 Skewness 3.328515\ 99% .5086038 .9572004 Kurtosis 20.59862\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2006\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0770399 .069069\ 5% .0874363 .0704802\ 10% .0950623 .0706123 Obs 3140\ 25% .1106733 .0711354 Sum of Wgt. 3140\ \ 50% .1351784 Mean .1595143\ Largest Std. Dev. .0857552\ 75% .1801741 .9538059\ 90% .2416169 .9756135 Variance .0073539\ 95% .2986719 1 Skewness 3.772206\ 99% .5131463 1 Kurtosis 25.87315\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2007\ \ Herfindahl Index\ -------------------------------------------------------------\ Percentiles Smallest\ 1% .0769427 .0690811\ 5% .0876816 .0699562\ 10% .094912 .0710418 Obs 3142\ 25% .1109222 .0711604 Sum of Wgt. 3142\ \ 50% .1334818 Mean .1593733\ Largest Std. Dev. .0895454\ 75% .1791756 1\ 90% .2434477 1 Variance .0080184\ 95% .2991657 1 Skewness 4.07079\ 99% .5061729 1 Kurtosis 28.49562\ \ . ******************************************************************************************************************************************\ \ . ******************************************************************************************************************************************\ \ . by year: correlate hi ki\ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 1998\ (obs=3139)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7852 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 1999\ (obs=3139)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7869 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2000\ (obs=3139)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7883 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2001\ (obs=3140)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7559 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2002\ (obs=3140)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7642 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2003\ (obs=3140)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7583 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2004\ (obs=3140)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7728 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2005\ (obs=3140)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7774 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2006\ (obs=3140)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7698 1.0000\ \ \ --------------------------------------------------------------------------------------------------------------------------------------------\ -> year = 2007\ (obs=3142)\ \ | hi ki\ -------------+------------------\ hi | 1.0000\ ki | 0.7761 1.0000\ \ . edit\ - preserve\ \ . graph twoway scatter hi ki, title( "1998-2007")\ \ . graph save Graph "/Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/corrected/98_07_hivski.gph"\ (file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/corrected/98_07_hivski.gph saved)\ \ . save, replace\ file /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/corrected/employ_spec_ndx.dta saved\ \ . log close\ log: /Users/aprilharris/Documents/Academic/Harris School/Classes/2nd yr/Fall 09/Practicum/Data/EDA Request/stata version/full dataset trial/corrected/employ_spec_ndx.log\ log type: text\ --------------------------------------------------------------------------------------------------------------------------------------------}