# need it ASAP thanks The exercise involving data in this and subsequent sections were designed to...

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 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?

(a)

There are 2 predictor variables so degree of freedom of regression is

There are total 10 observations so degree of freedom of error is

(B)

The F test statistics is

The p-value is

p-value < 0.001

Since p-value is less than level of significance so we reject the null hypothesis.

(C)

t = 7.62, p-value < 0.001, Reject H0

(d)

t = 7.43, p-value < 0.001, Reject H0

#### Earn Coin

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### eBook Video The exercise involving data in this and subsequent sections were designed to be solved...

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 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 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 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.590601 +0.4980:3 Here SST = 6,565.375, SSR = 6,190.250, 81 = 0.0814, and 81% = 0.0546 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...

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

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 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 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...