An efficiency expert wants to determine whether the time an assembly worker requ

Question

An efficiency expert wants to determine whether the time an assembly worker requires to perform a standard task might be related to 1) number of years on the job, 2) the score on a pre-employment aptitude test, and 3) the shift they are working.

The data collected is in the file Employees.xlsx.

Assuming all other variables are the same, how much faster is the afternoon shift worker than the morning shift worker?

Time Years TestScore Shift 52 7 73 Morning 48 14 78 Morning 56 8 71 Night 52 6 75 Morning 48 10 78 Afternoon 45 6 78 Afternoon 42 10 80 Afternoon 51 11 72 Night 51 10 79 Night 53 6 77 Night 47 8 79 Morning 45 12 84 Afternoon 49 12 72 Afternoon

Explanation / Answer

Time = 82.96 -0.168* year-0.452* Test Score+2.76* Morning shift +5.087* After shift

After noon shift is faster than morning shift by (5.087-2.76) = 2.31

SUMMARY OUTPUT Regression Statistics Multiple R 0.895989 R Square 0.802797 Adjusted R Square 0.704195 Standard Error 2.09289 Observations 13 ANOVA df SS MS F Significance F Regression 4 142.6508 35.6627 8.141814 0.006369 Residual 8 35.04152 4.380191 Total 12 177.6923 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 82.96491 13.79167 6.015583 0.000318 51.16127 114.7686 51.16127 114.7686 Years -0.16864 0.239299 -0.70472 0.50098 -0.72047 0.383185 -0.72047 0.383185 Test Score -0.45253 0.176352 -2.56607 0.033331 -0.8592 -0.04586 -0.8592 -0.04586 Shift - Morning 2.766256 1.475953 1.874217 0.097771 -0.6373 6.16981 -0.6373 6.16981 Shift Night 5.087458 1.55915 3.262968 0.011476 1.492051 8.682865 1.492051 8.682865

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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