Question
Use Excels regression tool to conduct regression analysis to investigate the relationship between the number of fatal accidents and the percentage of drivers under the
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 |
Step by Step Solution
3.49 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
Solution a What is your independent variable X in this problem Percent Under 21 b What is your depen...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started