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. y = 29.1270+ 0.5906x1 +0.4980x2 Here SST = 6,765.750, SSR = 6,527.625, 8b, = 0.0786, and 8ty = 0.0690. a. Compute MSR and MSE (to 3 decimals). MSR MSE b. Compute the F test statistic (to 2 decimals). Use Ftable. What is the p-value? - Select your answer - At a = .05, what is your conclusion? - Select your answer - c. Compute the t test statistic for the significance of B1 (to 2 decimals). Use t table. The p-value is - Select your answer - - At a = .05, what is your conclusion? - Select your answer -

Answer 1

Solution:

df SS Source MS F 6527.625 3263,813 = 3263.813 = 95.94409 34.01786 Regression 6527.625 0.0000 238.125 = 34.01786 6765.75-6527.625 238.125 7 Error 7 Total 9 6765.75 Coefficient p-value SE 0.5906 = 7.513995 0.5906 0.0786 0.000136 х1 0.0786 0.498 = 7.217391 0.498 0.069 x2 0.069 0.000175 N

a. Compute MSR and MSE (to 3 decimals). MSR 3263.813 MSE 34.018 b. Compute the F test statistic (to 2 decimals). Use F table. 95.94 What is the p-value? less than 0.01 - Select your answer At a .05, what is your conclusion? The model is overall significant - Select your answer c. Compute the t test statistic for the significance of B1 (to 2 decimals). Use t table. 7.51 less than 0.01 The p-value is-Select your answer At a .05, what is your conclusion? There is significant relations hip between x1 and y - Select your answer d. Compute the t test statistic for the significance of B2 (to 2 decimals). Use t table. 7.22 Less than 0.01 The p-value is-Select your answer At a .05, what is your conclusion? There is significantrelationship between x2 and y -Select your ànswer