In: Statistics and Probability
An analyst has kept track of number of defect produced by five workers on five different machines the result are shown below for a run of 400 units per machine
| 
 M1  | 
 M2  | 
 M3  | 
 M4  | 
 M5  | 
||
| 
 1  | 
 1  | 
 7  | 
 4  | 
 8  | 
 2  | 
|
| 
 2  | 
 7  | 
 4  | 
 5  | 
 2  | 
 1  | 
|
| 
 3  | 
 3  | 
 4  | 
 3  | 
 2  | 
 3  | 
|
| 
 4  | 
 9  | 
 2  | 
 8  | 
 8  | 
 5  | 
|
| 
 5  | 
 0  | 
 3  | 
 2  | 
 4  | 
 3  | 
|
USE excel and determine the set of assisments that will minimize the toatal number of error