You are given the following data, where X1 (final percentage in science class) and X2 (number of absences) are used to predict Y (standardized science test score in third grade):

Y X1 X2

480 98 0

415 95 2

310 61 5

345 70 3

350 70 3

450 89 1

400 82 0

465 92 2

375 92 6

390 80 1

420 80 2

410 72 1

Determine the following multiple regression values.

Report intercept and slopes for regression equation accurate to 3 decimal places:

Intercept: a=

Partial slope X1: b1=

Partial slope X2:b2=

Report sum of squares accurate to 3 decimal places:

SSreg

SSres

Test the significance of the overall regression model (report F-ratio accurate to 3 decimal places and P-value accurate to 4 decimal places):

F-ratio =

P-value =

Report the variance of the residuals accurate to 3 decimal places:

MSres=

Report the test statistics for the regression coefficients accurate to 3 decimal places:

t1=

t2=