Population and Ranking Look Up - Project #2

Project Summary: You will be searching two pieces of data (Rank and Population) from file name Copy of TOP5000Population_Per City_12-2-2015_2008 Census Bureau [login to view URL] and plugging data (Rank and Population) found onto file name: Master DID file 1-15-2016 ranking + [login to view URL] Project Details: a. Please open excel file named Master DID file 1-15-2016 ranking + [login to view URL] b. This file contains two tabs that you will be responsible for finding (Rank and Population) data for. • Tab Names responsible for are named: • 16,058 DID’s to look up on L3 (Column W: Rank and Column X: Population) • 1,925 DID’s with no menu (Column R: Rank and Column S: Population) c. Secondly please open excel file named Copy of TOP5000Population_Per City_12-2-2015_2008 Census Bureau [login to view URL] d. This spreadsheet will be where you search the data (Rank and Population) that you will be using to plug onto both tabs on excel file Master DID file 1-15-2016 ranking + [login to view URL] e. Please make sure when you are searching for the population and ranking you are verifying that both the city and the state match before you plug in the population and rank onto spreadsheet Final Master DID file 1-15-2016 ranking + [login to view URL] f. Please take note that I have filled out a few examples for you to use as a reference. If for any reason you are not able to find the population and ranking for a city please insert a N/A into the fields as I show in my example. 2. Lastly, please complete 10 examples on each tab so I can check for accuracy and award the project promptly.