Established in 2002, t-shirts. com has rapidly become the place to find, order, and save on t-shirts. one huge selling factor is that the company manufactures its own t-shirts. however, the quality manager for the production plant, kasey harnish, has noticed an unacceptable number of defective t-shirts being produced. you have been hired to assist kasey in understanding where the problems are concentrated. he suggests using a pivottable to perform an analysis and has provided you with a data file, t3_tshirtproduction_data. xls. the following is a brief definition of the information within the data file: a. batch: a unique number that identifi es each batch or group of products produced. b. product: a unique number that identifi es each product. c. machine: a unique number that identifi es each machine on which products are produced. d. employee: a unique number that identifi es each employee producing products. e. batch size: the number of products produced in a given batch. f. num defect: the number of defective products produced in a given batch.

batch product machine employee batch size num defective
1 10 5 500 16
2 20 7 1 10
3 30 6 5000 13
4 30 8 1000 12
5 20 6 1000 5
6 20 7 5000 9
7 30 8 1 20
8 10 5 1 14
9 10 6 5000 17
10 30 7 500 19
11 20 5 500 4
12 30 7 1000 7
13 10 8 5000 5
14 30 6 1 8
15 30 7 1 21
16 10 5 5000 15
17 10 6 500 6
18 10 8 500 9
19 10 7 500 0
20 20 6 1000 15
21 10 7 1 12
22 20 8 1 10
23 30 7 1 8
24 30 8 5000 12
25 20 7 1000 6
26 20 6 1000 8
27 20 6 5000 5
28 30 7 1 18
29 30 8 500 15
30 30 5 500 4
31 10 6 1 13
32 10 5 500 5
33 20 7 5000 18
34 30 5 1000 11
35 30 8 1000 23
36 20 6 5000 14
37 10 7 500 3
38 30 8 1 9
39 10 6 5000 1
40 10 7 1000 15
41 20 5 1000 19
42 20 6 5000 3
43 30 8 1 0
44 20 6 500 12
45 30 7 500 6
46 20 8 1 8
47 20 7 500 5
48 30 5 5000 18
49 30 8 1000 15
50 10 6 1000 4
51 10 7 5000 13
52 10 5 500 5
53 10 6 1 18
54 20 7 500 11
55 10 7 5000 23
56 20 6 1000 14
57 30 5 1000 3
58 30 7 5000 9
59 20 6 500 17
60 20 7 1 19
61 20 8 5000 4
62 30 8 1000 7
63 30 6 1000 5
64 30 7 5000 8
65 10 5 1 21
66 10 6 500 15
67 20 7 500 6
68 30 6 1 9
69 20 7 500 0
70 10 8 1 15
71 30 6 5000 12
72 30 7 1000 10
73 30 5 500 8
74 20 7 500 12
75 10 6 1 6
76 10 7 5000 8