3. Exercise 13.19 (Self-Test) Algorithmic eBook Video Al The exercise involving

Question

3. Exercise 13.19 (Self-Test) Algorithmic eBook Video Al 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 +5906x1 + .4980x2 Here SST = 6724.125, SSR = 6216.375, Sb1 = .0813, and Sbz = .0567 a. Compute MSR and MSE (to 3 decimals) Here SST = 7,060.331, SSR = 6,216.375, sb1 = 0.0854, and Sb2 = 0.0595 a. Compute MSR and MSE (to 3 decimals) MSR MSE b. Compute the Ftest statistic (to 2 decimals) What is the p-value? Select At a = .05, what is your conclusion? Select c. Compute the t test statistic for the significance of 1 (to 2 decimals) The p-value is Select At a = .05, what is your conclusion? 5 Select d. Compute the t test statistic for the significance of 2 (to 2 decimals) The p-value is Select At a = .05, what is your conclusion? Select

Explanation / Answer

a)

MSR=SSR/df=6216.375/2=3108.1875

MSE=SSE/df=843.956/7=120.5651, SSE=SST-SSR=7060.331-6216.375=843.956

b)

F=3108.1875/120.5651=25.78

p-value=0.0005

Reject the null hypothesis

c)

0.5906/0.0854=6.9156

The P-Value is 0.000123.

The result is significant at p < .05.

d)

0.4980/0.0567=8.783

The P-Value is 0.000022.

The result is significant at p < .05.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.