The exercise involving data in this and subsequent sections were designed to be solved using Excel.

The following estimated regression equation is based on 10 observations was presented.

ŷ = 29.1270 + .5906×1 + .4980×2

Here SST = 6724.125, SSR = 6216.375, Sb1 = .0813, and Sb2 = .0567.

a.  Compute MSR and MSE (to 3 decimals).

MSR

MSE

b.  Compute F and perform the appropriate F test. Use α = .05.

 (to 2 decimals)

c.  Perform a t test for the significance of β1. Use α = .05.

t test statistic =  (to 2 decimals)

What is the p-value?

– Select your answer -less than .01between .01 and .02between .02 and .05between .05 and .10between .10 and .20between .20 and .40greater than .40Item 5

What is your conclusion?

– Select your answer -SignificantNot significantItem 6

d.  Perform a t test for the significance of β2. Use α = .05.

t test statistic =  (to 2 decimals)

What is the p-value? – Select your answer -less than .01between .01 and .02between .02 and .05between .05 and .10between .10 and .20between .20 and .40greater than .40Item 8

What is your conclusion?

– Select your answer -SignificantNot significant