7) Ford would like to develop a regression sold per month by a dealership employ

Question

7) Ford would like to develop a regression sold per month by a dealership employee based experience (Exp), the employee's weekly base salary before commissionsals f-high education level of the employee. There are three levels of education school degree, associate's degree, and bachelor's degree. The following dummy variabies have been defined. model that would predict the number of ears on the employee's number of years of sales y base salary before commissions (Salary), and the in the sales force-high variables ligh School0ED2 ssociate's egree EDI achelor's The following Excel output shows the partially completed regression output from a random sample of employees from the previous month. SUMMARY OUTPUT Multiple R R Square Adjusted R Square Standard Error Observations 0.9035 1.7353 ANOVA Ss MS F Significance F 4.0112E-07 60.23 Residual Total 327.84 P-value Lower 95% Upper 95% Standard Error 1.6352 0.1254 0.0044 1.3553 1.0705 Coericients tstat Intercept Exp Salary ED1 ED2 0.2393 0.0127 2.9845 2.5638 0.3265 0.0709 0.0097 0.0396 0.0265 7) An employee with a bachelor's degree will average_ more cars sales per month than an employee with a high school degree. A) 2.9845 B) 1.3553 C) 2.5638 D) 0.4207

Explanation / Answer

8) option D. by subtract the two coefficients.

9) 1.64 + (7*0.2393 + 0.0127*400 + 2.9845) = 11.4

10) R-squared = 1 - residual/total = 327.84 - 60.23 = 267.61(option B)

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

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