Caroline Davis

Data Quiz 2

There were only 42 localities that provided data for 12 total months for 2014. Bryant, which would have been the 43rd, provided only two months of data for the year.CORRECT

Fayetteville’s property crime rate is 42.37 per 1,000, placing it 20th statewide. CORRECT

Fayetteville’s violent crime rate is 4.96 per 1,000, placing it 16th statewide. CORRECT

Fayetteville is ranked third statewide for total property crime due to a large number of larceny and theft crimes (2603). CORRECT

The place with the highest violent crime rate in the state in 2014 is Blytheville, with a total of 17.32 per 1,000.  CORRECT

The place with the highest property crime rate in Arkansas in 2014 is Blytheville, with a total of 83.95 per 1,000.  CORRECT

Lonoke County had the biggest percent increase in violent crime from 2013 to 2014, increasing by 54 percent. Mountain Home had the biggest percent decline in violent crime from 2013 to 2014, decreasing by 46 percent — CORRECT

LocalCrimeOneYearofDataQUIZ21.

You need to download the full version of Excel on your home computer. MS Office is free through the university. I discussed this the first day.

Your spreadsheet didn’t have the columns labeled correctly for the comparison.

https://software.uark.edu/index.php?method=type&type_id=4

***I had to do some calculations on Excel online and the more detailed custom sorting tool wasn’t available on that version, so I had to manually sort them on paper. I can open this on a computer in the lab in the morning and sort on actual Excel in the lab and send an updated copy. I did all of the work, but just couldn’t get the entire spreadsheet to sort due to limited access on the online version.