COMM207 Busi Problem#3: Below is a partial multiple regression Excel output. Sou

Question

COMM207 Busi Problem#3: Below is a partial multiple regression Excel output. Source Model Error Total df 32.774 21.886 54.660 292 297 Variable Intercept Y1 Coefficient () Estimate 22.02 -.18 Standard Error 04 25 -4.69 3.67 22.32 1.70 0.40 3.60 1. Write the least squares equation (the estimated regression line). 2. Test the significance of variable Xs in the model at = .05. 3 Determine the95% interval for34(ba 3.67) and interpret its meaning. 4. Calculate R2. (5 marks) Problem #4: Vecima Electronics Inc. claims that a certain circuit board has a median operating life of greater than 20,000 hours. A random sample of 25 such circuit boards showed 17 circuit boards failing after 20,000 hours. Assume the useful life of the circuit board is not normally distributed 1. State the null and alternative hypotheses. 2. At a = 0.05 (Table Z= 1.645), can it be concluded that the sample supports their claim of th company? (4 marks)

Explanation / Answer

3)
1)
y^ = 22.02 -18x1 -25 x2-4.69x3 + 3.67*x4 + 22.32 x5
2)
TS = 22.32/3.60 = 6.2
p-value = 2 P(t > 6.2) = 0.0000

since p-value < 0.05
we reject the null , the variable is significant

3)
95% interval
t = 1.96
(3.67 - 1.96 * 0.40 , 3.67 + 1.96 *0.4)
=(2.886,4.454)

4)
R^2 = SS_model /SS_total = 32774/54660 = 0.599597

Please rate

Post next question again

you are allowed to ask one question at time

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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