Details of this Paper





Econ 375;Moehling;Fall 2014;Codebook for NJ 2012 ACS Dataset;This dataset was constructed from the American Community Survey (ACS) of 2012. The ACS is conducted;annually by the Census Bureau and represents a 1-in-100 national random sample of American households. The;ACS data serve as the basis for studies done by the Census Bureau, other government agencies, policymakers and;scholars on the current U.S. population.;The NJ 2012 dataset consists of men and women ages 25-64 living in New Jersey in 2012. In other words, this;is a sample of the working-age population of New Jersey in 2012. There are 3000 observations in the sample and;29 variables.;Data formats;I have made the data available in three different formats on the Resources page on the course website;Comma-separated text file;Eviews;Stata;nj2012csv.csv;nj2012eviews.wk1;nj2012stata.dta;All of these files contain the same data, just in different formats.;Variables and variable names;age;sex;marst;race;hispanic;fborn;yrimmig;citizen;educ00;empstat;wkswork2;uhrswork;incwage;inctot;ftotinc;age_sp;educ00_sp;empstat_sp;wkswork2_sp;uhrswork_sp;incwage_sp;inctot_sp;incwelfr;Age;Sex;Marital status;Race;Hispanic;Foreign-born;Year of immigration (if foreign-born);Citizenship status (if foreign-born);Educational attainment;Employment status;Weeks worked last year;Usual hours worked per week;Wage and salary income;Total personal income;Total family income;Age of spouse (if married, spouse present);Educational attainment of spouse (if married, spouse present);Employment status of spouse (if married, spouse present);Weeks worked last year by spouse (if married, spouse present);Usual hours worked per week by spouse (if married, spouse present);Wage and salary income of spouse (if married, spouse present);Total personal income of spouse (if married, spouse present);Public assistance income;poverty;famsize;nchild;nchlt5;eldch;yngch;stateicp;Poverty status;Number of own family members in household;Number of own children in the household;Number of own children under age 5 in household;Age of eldest own child in household;Age of youngest own child in household;State of residence;1. age;25 to 64;2. sex;1 = Male;2 = Female;3. marst;1 = Married, spouse present;2 = Married, spouse absent;3 = Separated;4 = Divorced;5 = Widowed;6 = Never married/single;4. race;1 = White;2 = Black;3 = American Indian or Alaska Native;4 = Chinese;5 = Japanese;6 = Other Asian or Pacific Islander;7 = Other race, not elsewhere classified;8 = Two or three races reported;5. hispanic;1 = Hispanic;0 = Not Hispanic;6. fborn;1 = Born outside U.S.;0 = Born in U.S. (includes U.S. territories);7. yrimmig;0 = N/A;1940 to 2000;8. citizen;0 = N/A;1 = Born abroad of American parents;2 = Naturalized citizen;3 = Not a citizen;9. educ00;1 = No school completed;2 = Nursery school-4th grade;3 = 5th-6th grade;4 = 7th-8th grade;5 = 9th grade;6 = 10th grade;7 = 11th grade;8 = 12th grade, no diploma;9 = High school graduate, or GED;10 = Some college, less than 1 year;11 = One or more years of college but no degree;12 = Associate degree;13 = Bachelors degree;14 = Masters degree;15 = Professional degree;16 = Doctorate degree;10. empstat;1 = Employed;2 = Unemployed;3 = Not in labor force;11. wkswork2;0 = Not applicable (not working);1 = 1 13 weeks;2 = 14-26 weeks;3 = 27-39 weeks;4 = 40-47 weeks;5 = 48-49 weeks;6 = 50-52 weeks;12. uhrswork;Usual hours worked per week;0-99;13. incwage;Wage and salary income ($);(Top-coded at $480,000);14. inctot;Total personal income ($);15. ftotinc;Total family income ($);(This variable is missing for some observations.);*** Spouse data only available for individuals with marst=1 married, spouse present, for others, these variables;are blank or missing ****;16. age_sp;17. educ00_sp;See codes for educ00;18. empstat_sp;See codes for empstat;19. wkswork2_sp;20. uhrswork_sp;21. incwage_sp;22. inctot_sp;23. incwelfr;Public assistance (welfare) income ($);24. poverty;income as % of poverty threshold;(e.g., 75 = income 75% of poverty threshold);poverty 24 and age<35);Stata;Stata is available in all computer labs on campus.;Opening the dataset;Click on File then Open and then browse to find nj2012stata.dta;Determining median for different population groups;By dropdown menu;Click on Statistics then Summaries, tables, and tests then Summary and descriptive statistics then;Centiles with CIs;In new window, enter variable of interest (e.g., incwage), then go to tab for by/if/in and click on the box;Repeat command by groups and scroll down to variable defining groups of interest (e.g. sex);Using command line;Enter: by sex, sort: centile incwage, centile(50);Free Econometrics software: GRETL;I have not used this software but have been told that it is easy to use and that the documentation is well-written;and easy to follow. The advantage of using this software is that you can download it to your own computer and;are not restricted to doing your data analysis in a computer lab on campus.;Here is the website


Paper#15655 | Written in 18-Jul-2015

Price : $57