For this assignment use XLMD_Production.xls. Its list definition table is as follows: A. BATCHA unique number that identifies each batch or group of products produced B. PRODUCTA unique number that identifies each product C. MACHINEA unique number that identifies each machine on which products are produced D. EMPLOYEEA unique number that identifies each employee producing products E. BATCH SIZEThe number of products produced in a given batch F. NUM DEFECTIVE

The number of defective products produced in a given batch It seems to have some real problems. There are an unacceptable number of defective products being produced. The task is to use some combination of Filter, conditional formatting, and pivot tables to illustrate where the problems seem to be concentrated, by product, by employee, by machine, or even by batch size. Based on your analysis, recommend how to correct the problems.

Below Picture represents a table in Excel.

BATCH MACHINE 5 NUM DE FECTIVE 16 10 13 12 6 6 6 8 20 14 17 6 5 7 6 21 5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 8 7 6 8 EMPLOYEE 3333 5555 2222 4444 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 2222 3333 4444 5555 4444 5555 3333 8 1234se789HHEHEp8a88848588528%888mm 1%%9mm PRODUCT 10 20 30 30 20 20 30 10 10 30 20 30 10 30 30 10 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 30 20 20 30 30 10 10 m n = tm > 0 0 1 - 0 0 = O n n n ( 2 3 = 3 = 0 3 n = 3 cm > n = n th 02 0 0 0 Uni BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 5000 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 coco Owo OwaNon conococo no 27 18 29 30 31 32 33 34 2222 23 8 5 19 37 38 39 40 41 42 43 44 45 46 8 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 1111 4444 2222 5555 4444 5555 1111 7 8 7 5 48 49 50 51 18 11 14 17 19 7 5 B8%88m88md&&w88m88TR 5 6 77 6 57 6 7 33 s 7 S6 7 6 73 s T 57 6 7 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 CESS 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 10 21 15 6 9 0 30 10 30 30 30 20 Qus268 BATCH MACHINE 5 NUM DE FECTIVE 16 10 13 12 6 6 6 8 20 14 17 6 5 7 6 21 5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 8 7 6 8 EMPLOYEE 3333 5555 2222 4444 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 2222 3333 4444 5555 4444 5555 3333 8 1234se789HHEHEp8a88848588528%888mm 1%%9mm PRODUCT 10 20 30 30 20 20 30 10 10 30 20 30 10 30 30 10 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 30 20 20 30 30 10 10 m n = tm > 0 0 1 - 0 0 = O n n n ( 2 3 = 3 = 0 3 n = 3 cm > n = n th 02 0 0 0 Uni BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 5000 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 coco Owo OwaNon conococo no 27 18 29 30 31 32 33 34 2222 23 8 5 19 37 38 39 40 41 42 43 44 45 46 8 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 1111 4444 2222 5555 4444 5555 1111 7 8 7 5 48 49 50 51 18 11 14 17 19 7 5 B8%88m88md&&w88m88TR 5 6 77 6 57 6 7 33 s 7 S6 7 6 73 s T 57 6 7 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 CESS 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 10 21 15 6 9 0 30 10 30 30 30 20 Qus268