consider the following dataset for all the analyses.the dataset provides 50 obse
ID: 3129090 • Letter: C
Question
consider the following dataset for all the analyses.the dataset provides 50 observations relating the speed of a car to distance it takes for the car to stop.the data were recorded in 1920s.
4
a.conduct and explain the correlation analysis relating the speed to distance.provide the type of correlation analysis you used alongside the formula.
b.conduct a regression analysis predicting the distance it takes for a car to stop from the speed the car was traveling.provide the appropriate summary of residuals.provide the appropriate plots for the analysis you conducted.provide a write up summarizing your findings in words.
speed distance 4 24
10 7 4 7 22 8 16 9 10 10 18 10 26 10 34 11 17 11 28 12 14 12 20 12 24 12 28 13 26 13 34 13 34 13 46 14 26 14 36 14 60 14 80 15 20 15 26 15 54 16 32 16 40 17 32 17 40 17 50 18 42 18 56 18 76 18 84 19 36 19 46 19 68 20 32 20 48 20 52 20 56 20 64 22 66 23 54 24 70 24 92 24 93 24 120 25 85Explanation / Answer
sol)
From Excel
From Excel
a) The correlation between speed an distance is 0.8069
we can say that there is positive correlation between them
b)
The Regression equation is
y=a+bx
frommm excel
y= -17.58 +3.93(speed)
slope=3.93
and intercept = -17.58
since slope is positive we can say that there is positive relation.
and coefficient of determination is 0.65
Hence 65% of variation is due to speed
SUMMARY OUTPUT Regression Statistics Multiple R 0.806894901 R Square 0.651079381 Adjusted R Square 0.643810201 Standard Error 15.37958675 Observations 50 ANOVA df SS MS F Significance F Regression 1 21185.46 21185.46 89.56711 1.49E-12 Residual 48 11353.52 236.5317 Total 49 32538.98 Coefficients Standard Error t Stat P-value Lower 95% Intercept -17.57909489 6.75844 -2.60106 0.012319 -31.1678 speed 3.932408759 0.415513 9.46399 1.49E-12 3.096964Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.