Problem

A North Carolina agency has tasked you with using US Census data that will aid in determining the possible location for a new human resources branch. The county should be in the lowest population bracket (less than 47759), be in close proximity to counties with higher population.

 

Analysis Procedures

After getting the necessary population data from the 2010 US Census, as well as the corresponding shapefile from TIGER/Line, Open Office was used to extract only the information necessary for processing. The resulting excel file had to then be connected to the shapefile with a county identifier number. The resulting map file was then properly symbolized.

 

Workflow Diagram

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Results

Map showing county population and the ideal location for a human resources branch.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Results

 

Map showing county population and the ideal location for a human resources branch.