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. y = 29.1270 + .5906x1 + .4980x2 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
e. What is your conclusion? - Select your answer -SignificantNot significant