1 7 0.406 2 14 2.731 3 13 3.807 4 10 1.999 5 14 1.884 6...

1	7	0.406
2	14	2.731
3	13	3.807
4	10	1.999
5	14	1.884
6	15	2.275
7	17	4
8	13	2.597
9	4	0
10	11	2.651
11	6	0
12	11	1.558
13	13	3.147
14	12	3.378
15	15	3.127
16	10	1.989
17	11	2.183
18	13	2.178
19	11	3.132
20	10	1.445
21	9	0.841
22	18	2.825
23	10	2.036
24	12	1.601
25	13	2.835
26	11	1.162
27	7	1.677
28	7	0.423
29	16	4.018
30	11	1.742
31	19	3.876
32	16	3.578

10. What is the estimated increase in number of fatal accidents per 1000 licenses due to a 1% increase in the percentage of drivers under 21 (ie. the slope)?
11. What is the standard deviation of the estimated slope?
12. What is the estimated number of fatal accidents per 1000 licenses if there were no drivers under the age of 21 (ie. the intercept)?

Expert Solution

The important thing here is to decide the dependent and independent variables. Since we are interested in finding whether the number of fatal accidents is dependent on the percentage of drivers that are under 21.

So, the percentage of driver that is under 21 is the dependent variable. Now, all we have to do is plotting the data in Excel and doing the regression.

So, in excel, I have chosen x as % of driver under 21 and y as number of fatal accidents per 100 licenses and select linear regression.

I get the following output

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.835631
R Square	0.69828
Adjusted R Square	0.688223
Standard Error	0.636578
Observations	32

ANOVA
	df	SS	MS	F	Significance F
Regression	1	28.13522582	28.13522582	69.4299	2.66759E-09
Residual	30	12.1569629	0.405232097
Total	31	40.29218872

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-1.00839	0.403678923	-2.498010322	0.0182	-1.832816463	-0.18397	-1.83282	-0.183971771
X Variable 1	0.272743	0.032732592	8.332460897	2.67E-09	0.205894169	0.339592	0.205894	0.339591909

10)

The equation is Fatal accidents/1000 licensed = -1.00839 + 0.272743 % drivers under 21

So, slope is 0.272743

11) Standard deviation of the slope is 0.032732592

12) Intercept = -1.00839

I have highlighted the answers from the table

orchestra answered 1 year ago

Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14...

Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Player A 8 42 56 68 91 123 12 46 57 137 5 80 14 10 19 Player B 38 44 46 59 57 61 48 42 51 39 58 41 55 45 68 1. For the given data set representing the runs scored by two players in last 15 matches, conduct the following analysis: i. Which average you will use to summarize...

Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number of Aides Absent 5 8 11 15 4 2 7 1 4 6 14 19 3 5 8 In which of the following ranges you can find the Upper Control Limit of the control chart? 0.1427 0.1536 0.1677 Not computable with information available In which of the following ranges you can find the Lower Control Limit of the control chart? Does not exit...

student 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

student 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Test score 67 67 87 89 87 77 73 74 68 72 58 98 98 70 77 Above we have the final averages of the last stats and I want to know if the class average falls within the boundaries of all my statistics classes for the past 20 years. Find the sample size, mean, and standard deviation of the data above (Table 1)....

Company ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14...

Company ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 5330 6352 6340 3399 6566 7376 6882 1842 7362 8205 6222 7695 1681 2283 2 7972 5941 2861 3290 1019 7399 6442 8003 5092 4634 7569 2538 2619 7932 3 8545 6667 2121 2339 4770 7296 3215 7919 2176 9129 1321 695 7945 1673 4 4578 466 4142 8350 7439 6085 8381 5872 2703 6974 702 5846 7176 9179 5 7302 2727 3103...

x 3, 4, 5, 7, 8 y 3, 7, 6, 13, 14 (a) Find the estimates...

x 3, 4, 5, 7, 8 y 3, 7, 6, 13, 14 (a) Find the estimates of Bo and B1. Bo=bo= _____ (Round to three decimal places as needed.) B1=b1= ______(Round to four decimal places as needed.) (b) Compute the standard error the point estimate for se= ____ (c) Assuming the residuals are normally distributed, determine Sb1=____ (Round to four decimal places as needed.) (d) Assuming the residuals are normally distributed, test HoB1=0 versus H1:B1/=0 at the a=0.05 level of...

Consider the data. xi 1 2 3 4 5 yi 3 7 5 10 13 (a)...

Consider the data. xi 1 2 3 4 5 yi 3 7 5 10 13 (a) Compute the mean square error using equation s2 = MSE = SSE n − 2 . (Round your answer to two decimal places.) (b) Compute the standard error of the estimate using equation s = MSE = SSE n − 2 . (Round your answer to three decimal places.) (c) Compute the estimated standard deviation of b1 using equation sb1 = s Σ(xi −...

Periods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18%...

Periods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18% 20% 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.893 0.877 0.870 0.862 0.847 0.833 2 0.980 0.961 0.943 0.925 0.907 0.890 0.873 0.857 0.842 0.826 0.797 0.769 0.756 0.743 0.718 0.694 3 0.971 0.942 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.712 0.675 0.658 0.641 0.609 0.579 4 0.961 0.924 0.888 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0.636...

Post Position 1 2 3 4 5 6 7 8 9 10 Wins 19 14 11...

Post Position 1 2 3 4 5 6 7 8 9 10 Wins 19 14 11 15 15 7 8 12 5 11 The table below lists the frequency of wins for different post positions in the Kentucky Derby horse race. Use a 0.05 significance level to test the claim that the likelihood of winning is the same for the different post positions. What is the critical value (the X2 value)? [Round to the nearest thousandths place]

ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5...

ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5 8 7 6 5 7 7 6 7 8 8 8 9 7 8 10 12 11 Test the significance of the correlation coefficient. Then use math test scores (X) to predict physics test scores (Y). Do the following: Create a scatterplot of X and Y. Write the regression equation and interpret the regression coefficients (i.e., intercept and slope). Predict the physics score for each....

[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...

[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Find mean, median, mode, variance, standard deviation, coefficient of variation, range, 70th percentile, 3rdquartile of the data and skewness and define what each of these statistics measure. For example, mean is a measure of the central tendency, what about the rest? Use Chebyshev’s rule to find...

Question