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:

a) What is your independent variable, X, in this problem?

b) What is your dependent variable, Y, in this problem?

c) What is the Line of regression for this problem?

d) What is the slope? Explain what it means in the context of this problem.

e) What is the y intercept? Explain what it means in the context of this problem.

f) What is R squared? And what does this number mean in the context of the problem?

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

Answer rating: 100% (QA)

Solution a What is your independent variable X in this problem Percent Under 21 b What is your depen... View the full answer