A number of minor automobile accidents occur at various high-risk intersections in Teton County despite traffic lights. The Traffic Department claims that a modification in the type of light will reduce these accidents. The county commissioners have agreed to a proposed experiment. Eight intersections were chosen at random, and the lights at those intersections were modified. The numbers of minor accidents during a six-month period before and after the modifications were:
Number of Accidents
A B C D E F G H
Before modification 5 7 6 4 8 9 8 10
After modification 3 7 7 0 4 6 8 2
At the .01 significance level is it reasonable to conclude that the modification reduced the number of traffic accidents? You must use Excel test functions.
The solution goes into considerable detail to explain the concepts of Hypothesis Testing using the question below. Overall, the solution is very well explained. The attachment is provided both in doc and xls format.