Question

Status:Closed    Asked:Jul 13, 2017 - 05:30 PM

Incorporating geographic level data in ACS analysis?

I'm using American Community Survey data from 2006-2015 to explain income levels of different immigrant and refugee groups. Is there anyway to construct or incorporate variables like median income of metro area, county, or PUMA in my analysis?

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Jeff Bloem

Staff

Yes performing analysis at an aggregated geographic level is certainly possible, although these statistics are not readily available via IPUMS USA. Rather, IPUMS USA has a number of geographic variables that can be helpful to you in performing this task. I'm not sure what software you are using to run your analysis, but in any software you can calculate summary statistics by some selected criteria. In your case, for example, you'll want to calculate median income for all records who reside in some metro area, county, or PUMA.

Alternatively, IPUMS NHGIS provides ready made tables of popular statistics aggregated at various levels of geography. If you are just looking for some summary statistics, this may be a helpful resource for you.

I hope this helps. Let us know if you have any further questions.

 

Jul 17, 2017 - 08:18 AM

0
0
Report it

Answers

Thanks Jeff. Responding to your response:


JB: Yes performing analysis at an aggregated geographic level is certainly possible, although these statistics are not readily available via IPUMS USA. Rather, IPUMS USA has a number of geographic variables that can be helpful to you in performing this task. I'm not sure what software you are using to run your analysis, but in any software you can calculate summary statistics by some selected criteria. In your case, for example, you'll want to calculate median income for all records who reside in some metro area, county, or PUMA.

Alternatively, IPUMS NHGIS provides ready made tables of popular statistics aggregated at various levels of geography. If you are just looking for some summary statistics, this may be a helpful resource for you.

I hope this helps. Let us know if you have any further questions.


CWS: Yes, I understand I can calculate median income levels for PUMAs, but how do I get this outcome to being a geographic level variable (e.g. MedianIncomePUMA). I'm using spss.

 

Jul 20, 2017 - 05:31 PM

0
0
Report it

Ah, I understand your question now. In SPSS if you go to the Data tab and click "Aggregate", this will open a dialog box that will perform this prociedure for you. Add PUMA into the Break Variables and HHINCOME into the Summires of Variables. Be sure to change the function to median. Click "Ok" and you should be all set.

 

Jul 21, 2017 - 11:12 AM

0
0
Report it

Thank you!!!

 

Jul 21, 2017 - 03:25 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

For my third "revised" extract, the codebook did not include SAS code for var...
Why is there an increase in the proportion of individuals married in 1989?
Population living in foreign-born households
Why does the CPS December 2015 Food Supplement Survey not merge with the Marc...
state and PUMA shapefile
NHIS 2015 cancer file
Login   |   Register

Recently Active Members

View More »

Share |