Question

The following data give the number of hours 5 students spent studying and their corresponding grades on their midterm exams. Hours Studying 2 4 5 5 6 Midterm Grades 77 78 80 83 95 Table

Step 3 of 5 : Calculate the estimated variance of slope, s2b1. Round your answer to three decimal places.

Answer 1

using excel>data>data analysis>Regression

'we have

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.763184
R Square	0.58245
Adjusted R Square	0.443266
Standard Error	5.447377
Observations	5
ANOVA
	df	SS	MS	F	Significance F
Regression	1	124.1783	124.1783	4.184762	0.133318
Residual	3	89.02174	29.67391
Total	4	213.2
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	66.43478	8.269161	8.034042	0.004027	40.11862	92.75094
hour studying	3.673913	1.795947	2.045669	0.133318	-2.04159	9.389418

the estimated variance of slope, s2b1 = 1.7962 =3.226