Question

Status:Closed    Asked:Nov 07, 2016 - 01:50 PM

Labor Force by State and Year

I was hoping someone could walk me through this, because thus far I've been unsuccessful. I just need to see the size of the labor force in each state in the US from 1840 to the present. How do I go about obtaining this information and displaying it in Microsoft Excel? Thanks.

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Jeff Bloem

Staff

It sounds like you'll want to be using ACS data found on the IPUMS-USA site. You'll want to grab the LABFORCE variable as well as a state ID variable (STATEFIP is typical). The YEAR variable is "preselected", so you don't have to actively include it in your data extract it is automatically added for you. From here, you can submit the data extract and download into excel. Several online tutorials are available as well as a FAQ page to assist in the process of downloading and opening your data extract. Additionally, the NHGIS database has summary data you may find useful, rather than the microdata that is available on IPUMS-USA.

 

Nov 08, 2016 - 09:43 AM

0
0
Report it

Answers

Thank you, Jeff! I will give this another shot.

 

Nov 08, 2016 - 12:20 PM

0
0
Report it










 

Nov 08, 2016 - 01:56 PM

0
0
Report it

Jeff,


I've been attempting to upload a screenshot of the gibberish Excel is returning, with little luck. Basically, when you open the CSV file with Excel, it looks like:


Column 1=same year over and over...Column 2=State FIP (same number over and over)...Column 3=a seemingly random integer.


I'm none too tech savvy so I want it to look like:


Column 1 = STATE, Column 2 = YEAR, Column 3 = SIZE OF THE LABOR FORCE IN THAT STATE AND YEAR


I mean, they can be in any order, but that is the information I need. Thanks!

 

Nov 08, 2016 - 02:01 PM

0
0
Report it

Nevermind, I got it by going to the main site and using the SDA. Took less time, too!

 

Nov 08, 2016 - 02:11 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Labor Force Participation for Last Year
Labor force for 39 weeks or more.
Labor Force Participation by Age for the year 2014 looks very different
Login   |   Register


Share |