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

Reason for missing MIGSTA1 values in ASEC files for 1985 (and 1995)
India Area-level data (geo2) inconsistent for total population, urban share, ...
Does anyone have a method for handling missing data in CPS "EDUC" variable? 2...
How do I find the data file:Ipumsi_00001.dat for the 1974
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Wrong HH weight Tanzania 2012 census?
Login   |   Register

Recently Active Members

View More »

Share |