Determine the average growth rates for each crime category and compare them across cities.

Excel memo

Go to the following websites and create a data table in Excel:

http://www.city-data.com/crime/crime-Miami-Florida.html (Links to an external site.)

http://www.city-data.com/crime/crime-Los-Angeles-California.html (Links to an external site.)

Use the tables “Crime rates in … by Year” from the websites and create a table with five columns. The first column should display the years, the other four columns should show the “assault” and “theft” data for both cities and each year. Make sure you use the “Per 100,000 Pop” data (the numbers in parentheses), which standardize the crime data and, therefore, make them comparable.

Create two charts that compare crime trends across cities. Label the charts in a meaningful way. For example, the x-axis should show the years 2006–2019.
Determine the average growth rates for each crime category and compare them across cities.
Determine whether the crime rate differences between cities are statistically significant. Run two t-tests to compare the average crime rates for assaults and thefts across cities