An efficiency expert wants to determine whether the time an assembly worker requ
ID: 3239522 • Letter: A
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 night 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 AfternoonExplanation / Answer
Result:
Since the coeffient of night shift is zero and coefficient of afternoon is -5.087.
Night shift is 5.087 time grater than afternoon shift.
Time Years Test Score Shift - Morning Shift Afternoon Shift Night 52 7 73 1 0 0 48 14 78 1 0 0 56 8 71 0 0 1 52 6 75 1 0 0 48 10 78 0 1 0 45 6 78 0 1 0 42 10 80 0 1 0 51 11 72 0 0 1 51 10 79 0 0 1 53 6 77 0 0 1 47 8 79 1 0 0 45 12 84 0 1 0 49 12 72 0 1 0