National law enforcement noticed an overall decline in crimes among US Citizens. This data set records the number of crimes in each state and the percent change from 2016 to 2017. Let's suppose that leadership would like to conduct a hypothesis test at the 99% significance level that crime has decreased over time (by using percent change). For this part, you should look at the total percent change column to run your test.

Performing the Test

Step 1: Write the null hypothesis/alternative hypotheses below. Determine the tail type.

:

Step 2: Perform the Hypothesis Test in Excel. Fill out the cells indicated on the spreadsheet and determine whether to accept/reject the null hypothesis.

Step 3: Find a 99% confidence interval for the percent change from 2016 to 2017 by filling out the cells in the Excel sheet.

Analysis of Results

What is the conclusion of the hypothesis test?

Was your null hypothesis mean contained within your confidence interval? Does this agree with the results of your hypothesis test?