a)
p=number of independent variables= | 2 | |||
MSR =SSR/p = | 3095.125 | |||
MSE=(SSE/(n-p-1))= | 53.589 |
b)
F test statistic =MSR/MSE= | 57.76 |
p value = | 0.0000 | |||
Conclusion: we can conclude that model is significant |
c)
t test statistic =coefficient/standard error = | 7.26 | ||||
p value = | 0.0002 |
conclude that beta1 is significant
d)
t test statistic =coefficient/standard error = | 9.12 | ||||
p value = | 0.0000 |
conclude that beta2 is significant
The exercise involving data in this and subsequent sections were designed to be solved using Excel....
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 + 0.5906x1 +0.4980:22 Here SST = 6,614.875, SSR = 6,040.125, Sb, = 0.0812, and Sb= 0.0696. a. Compute MSR and MSE (to 3 decimals). MSR MSE b. Compute the F test statistic (to 2 decimals). Use F table. What is the p-value? ( - Select your answer - At...
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 =...
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. j29.12700.5906x1 +0.4980x2 Here SST 6,877.125, SSR = 6,320.875, s», = 0.0824, and s 0.0658 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...
lework 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. | 9= 29.1270 +0.5906zI +0.498022 Here SST = 6,863.625, SSR = 6,273.500, sb, = 0.0744, and Sby = 0.0555. a. Compute MSR and MSE (to 3 decimals). MSR MSE b. Compute the F test statistic (to 2 decimals). Use F table. What is the p-value? - Select your answer - At...
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.4980:02 Here SST = 6,894.875, SSR = 6,237.875, Sby = 0.0777, and $by = 0.0667 a. Compute MSR and MSE (to 3 decimals). MSR 3118.938 MSE 93.857 b. Compute the F test statistic (to 2 decimals). Use F table. 33.23 What is the p-value? less than .01 than...
eBook Video 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+0.5906, +0.4980ry Here SST 6,891.125, SSR-6,315.000, 0.0848, and a-0.0634. a. Compute MSR and MSE (to 3 decimals). MSR MSE b. Compute the P test statistic (to 2 decimals). Use F table. What is the p-value? Select your answer At a 05, what is your conclusion? Select your answer c. Compute...
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 g =29.12700.5906x1 0.4980x2 Here SST 6,787.125, SSR = 6,479.625, s» = 0.0767, and s, =0.0609. a. Compute MSR and MSE (to 3 decimals). MSR MSE b. Compute the F test statistic (to 2 decimals). Use F table. What is the p-value? Select your answer- .05, what is your conclusion? At a -Select...
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 + 0.590621 +0.498022 Here SST = 6,943.875, SSR = 6,696.375, 85, = 0.0752, and 86 = 0.0513. a. Compute MSR and MSE (to 3 decimals). MSR 3348.188 MSE 35.337 b. Compute the F test statistic (to 2 decimals). Use F table. 94.72 ♡ What is the p-value? less than...
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,614.875, SSR = 6,040.125, Sbı = 0.0812, and Sba = 0.0696. a. Compute MSR and MSE (to 3 decimals). MSR 3020.063 MSE 82.107 b. Compute the F test statistic (to 2 decimals). Use F table. 36.78 What is the p-value? less than .01 At...
need it ASAP thanks 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.59061 +0.49802, Here SST = 6,532.000, SSR = 6,078.625, 86, = 0.0775, and 8h = 0.0670. a. Compute MSR and MSE (to 3 decimals). MSR MSE b. Compute the F test statistic (to 2 decimals). Use F table. What is the p-value? - Select your...