Please show work in excel for example.
The Federal Government recently granted funds for a special program designed to reduce crime in high-crime areas.
A study of the results of the program in eight high-crime areas of Miami, Florida, yielded the following results.
Number of Crimes by Area
A B C D E F G H
Before 14 7 4 5 17 12 8 9
After 2 7 3 6 8 13 3 5
Has there been a decrease in the number of crimes since the inauguration of the program?
Use the .01 significance level. Estimate the p-value.
Need the 5 steps and the p-value
Step by step method for testing the hypothesis under 5 step approach is discussed here. Excel template for each problem is also included. This template can be used to obtain the answers of similar problems.