1 County Population Area (sq mi) County Code Lake County 4,537,195 1,002 Lee County 4,229,379 754 Clay County 2,823,135 662 Knox County 1,919,369 844...

The Justice Department in the state of Texkansahomatucky (it's one of those flyover states) has asked you to create a map that highlights the high crime counties in the state. The two files you will need to complete your task are Texkansahomatucky.xlsm and Map of Texkansahomatucky.pptx. The excel file contains crime data for each of the counties. Each row contains the county name, county population, county area, the county code, and the number of occurrences of seven different categories of crime: (a) murder, (b) rape, (c) robbery, (d) aggravated assault, (e) burglary, (f) larceny, and (g) motor vehicle theft. You will use this data to split the counties into high crime and "low crime" counties and create a crime map of the great state of Texkansahomatucky. Finally, you will need to incorporate both of these items into a short paper describing your methods and justifying your metrics. Instructions •