Regression, statistics homework help
Regression, statistics homework help
Use Excel’s regression tool to conduct regression analysis to investigate the relationship between the number of fatal accidents and the percentage of drivers under the age of 21. Use the computer output to answer the following questions:
g) Conduct an hypothesis test on the slope and discuss your findings. Make sure to state your null and alternative hypothesis and show your test statistic, you should use the numbers from the Excel output. Use a .05 level of significance. Give a statistical conclusion in the context of this problem.
h) If a city has 5 percent of its licensed drivers under the age of 21, what would be the predicted number of fatal accidents per 1000 licenses? Show how you calculated this.
3. What conclusion and recommendations about the two variables can you derive from the above analysis? Use complete sentences to answer this.
“Percent
Under 21″ “Fatal Accidents
per 1000″
13 2.962
12 0.708
8 0.885
12 1.652
11 2.091
17 2.627
18 3.83
8 0.368
13 1.142
8 0.645
9 1.028
16 2.801
12 1.405
9 1.433
10 0.039
9 0.338
11 1.849
12 2.246
14 2.855
14 2.352
11 1.294
17 4.1
8 2.19
16 3.623
15 2.623
9 0.835
8 0.82
14 2.89
8 1.267
15 3.224
10 1.014
10 0.493
14 1.443
18 3.614
10 1.926
14 1.643
16 2.943
12 1.913
15 2.814
13 2.634
9 0.926
17 3.256
