Question

Use the following information to answer questions 1-8.

A statistics professor wishes to investigate the relation between a student’s final course grade and grades on a midterm and a major project.

A random sample of 10 students is taken.

X₁         X₂                Y

Midterm	Project	Course Grade
88	90	83
95	80	83
91	80	92
94	93	94
95	90	89
93	58	77
91	90	91
87	74	73
82	92	70
87	74	75

The Excel output for the regression model is:

ANOVA
	df	SS	MS	F
Regression	2	498.3391	249.1696	10.15474
Residual	7	171.7609	24.53727
Total	9	670.1
	Coefficients	Standard Error	t Stat	P-value	Lower 95%		Upper 95%
Intercept	-86.8963	38.43591	-2.26081	0.058262	-177.783		3.990091
X Variable 1	1.526698	0.390809	3.90651	0.00585	0.602583		2.450814
X Variable 2	0.386546	0.148354	2.605569	0.035139	0.035745		0.737347

1. What is the value of the coefficient of determination, R²?

   		.25
   		.34
   		.86
   		.74

10 points   

QUESTION 8

1. What is the P-value for problem 3?

   		.05< p-value<.10
   		.025< p-value<.05
   		.01< p-value<.025
   		p-value<.01

Answer 1

Solution :

Coefficient of determination

= SSR / SST

= 498.3391 / 670.1

= 0.74

P-value is between   p-value<.01