due tomorrow simply calculate crime very easy criminal justice

Tasks:

To prepare for this consulting assignment, you need to learn more about crime rates and explore crime rates by state using the Federal Bureau of Investigation’s (FBI’s) Uniform Crime Reports.

1. Access Table 5 at Crime in the United States.
2. Select two states to organize and compare to Centervale.
3. Access the Microsoft Excel worksheet that has been prepared for you to populate with information. The worksheet has been populated with crime data pertinent to the state in which Centervale is located.
4. In the worksheet, organize the data for your two states and the violent crime (Type 1 offenses) counts for those states and calculate the rate of each type of crime.

Click here to download the worksheet.