Answer To: ISBN XXXXXXXXXX58576-3 Case 1 Use the 1_ CensusData_2010 data file:1_CensusData_2010.xlsx download...
Archit answered on May 16 2021
SOLUTIONS
1) The following results were found after using the VLOOKUP function available in Microsoft Excel. We categorized the population into 5 categories: error (for population less than 1), small (for population 1 to 14,999), medium (for population 15,000 to 49,999), large (for population 50,000 to 500,000) and very large (for population greater than 50,000). The following screenshot shows the starting of the data that was prepared after adding a description.
2) After defining the description column we then created a table which contained the count of each category of population i.e. error, small, medium, large, very large. For this purpose we used COUNTIF function in excel to count the number of occurrence of each category.
3) For creating a histogram of county population the data was divided into 11 intervals (1-49,999, 50,000-99,999, 100,000-149,999, 150,000-199,999, 200,000-249,999, 250,000-299,999, ...