Question
In: Statistics and Probability
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)? |
Solutions
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 agoRelated Solutions
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)....
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...
[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
Split the dataset in two equal parts. You have 30 datavalues.
If you split the data in two equal parts each part will contain 15
data values. Call the first part Y and second part
X.Draw scatter plot of the 2 datasets, X being on the horizontal...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Tidewater Company uses the product cost concept of applying the cost-plus approach to product pricing. The...
- Create 5 short-term plan of technology projects that you can perform outside of an I.T. department...
- Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
- Toady and Froggy were running a vegan cafe together. The business was having financial difficulties.Betelguese, who...
- 1. The following questions concern Jesse Gelsinger who suffered from partial OTC. a. In the...
- Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales...
- TzeMay was one of the first women engineering students at ABC University. She graduated in 1995...
ADVERTISEMENT