SUMMARY OUTPUT
Regression Statistics
Multiple R 0.514412452
R Square 0.26462017
Adjusted R Square 0.089529735
Standard Error 0.541591981
Observations 27
ANOVA
df SS MS
Regression 5 2.216536953 0.443307391
Residual 21 6.159759 0.293321873
Total 26 8.376296296
ANOVA
F Significance F
Regression 1.51133424 0.228794792
Residual
Total
Coefficients Standard Error t Stat
Intercept 1.996841973 1.272797329 1.568860908
X1 - # of hours studying 0.009900721 0.016536726 0.598711065
X2 # of hours studying for 0.076292741 0.056537054 1.349429003
tests
X3 - # of hours spent in -0.136520264 0.069221501 -1.972223384
bars
X4 -Highlight Text ? 1-Yes 0.063590148 0.260623817 0.243992081
X5 - avg # of credit hrs 0.137937105 0.075212915 1.833955048
per term
P-value Lower 95% Upper 95%
Intercept 0.131626283 -0.650085432 4.643769379
X1 - # of hours studying 0.555769379 -0.024489289 0.044290731
X2 # of hours studying for 0.19156885 -0.04128252 0.193868002
tests
X3 - # of hours spent in 0.061897232 -0.280474281 0.007433754
bars
X4 -Highlight Text ? 1-Yes 0.809604879 -0.478406845 0.60558714
X5 - avg # of credit hrs 0.080872162 -0.018476741 0.294350951
per term
Lower 95.0% Upper 95.0%
Intercept -0.650085432 4.643769379
X1 - # of hours studying -0.024489289 0.044290731
X2 # of hours studying for -0.04128252 0.193868002
tests
X3 - # of hours spent in -0.280474281 0.007433754
bars
X4 -Highlight Text ? 1-Yes -0.478406845 0.60558714
X5 - avg # of credit hrs -0.018476741 0.294350951
per term
DURBIN WATSON TEST
1.882461849
GPA - Y Squared
Residuals
4.8 0.522315613
4.3 0.004015728
3.8 0.001429006
3.8 0.034485572
4.2 0.091683888
4.3 0.0314924
3.8 0.093325312
4.3 0.000703375
4 0.097171001
3.8 0.010516056
3.1 0.305114801
3.9 0.002117972
3.2 0.617230252
4.9 0.486111688
4.4 0.165861624
4.5 0.259291675
4.6 0.066428222
4 0.016045184
3.7 0.005459469
3.5 0.024814139
2.8 1.194120606
4.3 0.020667941
5 0.201309456
3 1.092350026
4.1 0.022523488
4.1 0.030235194
4.6 0.762939656
The LM Stat to Check for Heteroscedasticity
LM STAT = 27 * 3.2589
0.1207 =
The Restricted Regression
SSE used for F-Test of significance of X1 X2 and X4
GPA - Y X3 - # of X5 - avg # of
hours spent in credit hrs per
bars term
4.80 6.00 16.00
4.30 1.00 15.00
3.80 4.00 15.00
3.80 8.00 17.00
4.20 4.00 15.00
4.30 3.00 13.00
3.80 7.00 17.00
4.30 5.00 19.00
4.00 6.00 19.00
3.80 6.00 15.00
3.10 7.00 16.00
3.90 5.00 15.00
3.20 4.00 16.00
4.90 4.00 17.00
4.40 4.00 16.00
4.50 4.00 17.00
4.60 3.00 17.00
4.00 4.00 15.00
3.70 6.00 14.00
3.50 7.00 17.00
2.80 6.00 15.00
4.30 5.00 15.00
5.00 5.00 19.00
3.00 4.00 16.00
4.10 6.00 18.00
4.10 7.00 17.00
4.60 7.00 15.00
Regression Statistics
Multiple R 0.411092732
R Square 0.168997234
Adjusted R Square 0.099747004
Standard Error 0.538544543
Observations 27
ANOVA
df SS MS
Regression 2 1.415570909 0.707785454
Residual 24 6.960725 0.290030224
Total 26 8.376296296
ANOVA
F Significance F
Regression 2.440385155 0.108450018
Residual
Total
The F-test to check the joint significance of X1, X2 and X4
F = ( Restricted SSE -Unrestricted SSE) / K1
Unrestricted SSE / (n - K - 1)
F = (6.960725388 -6.15975934309105 ) / 2
6.15975934309105 / ( 27 - 2 -1 )
F = 1.560384
Coefficients Standard Error t Stat
Intercept 2.697334552 1.133818475 2.378982713
X3 - # of hours spent in -0.124616961 0.068366015 -1.822791071
bars
X5 - avg # of credit hrs 0.121947495 0.072422637 1.683831183
per term
P-value Lower 95% Upper 95%
Intercept 0.025661857 0.357248714 5.037420391
X3 - # of hours spent in 0.080817761 -0.265717452 0.016483529
bars
X5 - avg # of credit hrs 0.105178345 -0.027525451 0.271420441
per term
Lower 95.0% Upper 95.0%
Intercept 0.357248714 5.037420391
X3 - # of hours spent in -0.265717452 0.016483529
bars
X5 - avg # of credit hrs -0.027525451 0.271420441
per term