Question

Status:Closed    Asked:Oct 24, 2016 - 05:03 PM

merging data according to geographic level.

Hi Joe,


Thanks, I got your reply.


Then I think I may adjust my analysis on more aggregate level. I am considering doing analysis based on geographic reagion.Can you provide me some information on how to merge data on geographic reagion? Say, county level, city level, MSA level, or urban area level? My target variable is demographic characteristics of unemployment population and change of income inequalities.




Thanks much!

Best,

Cassie.

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Joe_Grover

Staff

How to aggregate information up to a geographic unit is largely dictated by what statistical program you are using, taking into consideration the type of summaries you would want on a variable to variable basis (e.g. mean vs. median vs sum vs counts). However, I would actually recommend checking out the NHGIS project (also housed here at the Minnesota Population Center). NHGIS offers aggregate data for many geographic levels, using Census Bureau published summary tables. This way you can get complete coverage using mostly consistent geographic units, such as counties (the public use microdata does not allow for the identification of all counties due to confidentiality restrictions), and consistent aggregate measurements for modern samples. The NHGIS project is primarily intended to facilitate mapping data, but the CSV-format tables provided can be used independently of any GIS software.

I hope this helps.

 

Oct 25, 2016 - 01:28 PM

1
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

How best to aggregate data to a state level?
question about household level merging
Why are not all the "not in the labour force" categories filled for the EMPST...
how to aggregate data to household level
Incorporating geographic level data in ACS analysis?
Login   |   Register


Share |