In an effort to increase production of an automobile part, thefactory manager decides to play music in the manufacturing area.Eight workers are selected, and the number of items each producedfor a specific day is recorded. After one week of music, the sameworkers are monitored again. The data are given in the tablebelow.
Can the manager conclude that the music has changed theproduction level?
Worker | Before | After |
1 | 6 | 8 |
2 | 8 | 11 |
3 | 10 | 9 |
4 | 9 | 13 |
5 | 5 | 7 |
6 | 12 | 12 |
7 | 9 | 8 |
8 | 7 | 10 |
Perform the appropriate hypothesis test with a significancelevel of 0.05.
Do your work in an Excel file. Make Excel do the teststatistic calculation.!!!!!!!!!!!
