write my assignment 7754

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 •