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

August 30, 2017

Question
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

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