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 identifies each batch or group of products produced. 

B. Product: A unique number that identifies each product. 

C. Machine: A unique number that identifies each machine on which products are produced. 

D. Employee: A unique number that identifies 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	3333	500	16
2	20	7	5555	10000	10
3	30	6	2222	5000	13
4	30	8	4444	1000	12
5	20	6	3333	1000	5
6	20	7	1111	5000	9
7	30	8	2222	10000	20
8	10	5	3333	10000	14
9	10	6	1111	5000	17
10	30	7	5555	500	19
11	20	5	3333	500	4
12	30	7	4444	1000	7
13	10	8	2222	5000	5
14	30	6	3333	10000	8
15	30	7	1111	10000	21
16	10	5	1111	5000	15
17	10	6	1111	500	6
18	10	8	4444	500	9
19	10	7	3333	500	0
20	20	6	2222	1000	15
21	10	7	5555	10000	12
22	20	8	3333	10000	10
23	30	7	4444	10000	8
24	30	8	2222	5000	12
25	20	7	5555	1000	6
26	20	6	1111	1000	8
27	20	6	2222	5000	5
28	30	7	3333	10000	18
29	30	8	4444	500	15
30	30	5	5555	500	4
31	10	6	4444	10000	13
32	10	5	5555	500	5
33	20	7	3333	5000	18
34	30	5	2222	1000	11
35	30	8	4444	1000	23
36	20	6	1111	5000	14
37	10	7	3333	500	3
38	30	8	2222	10000	9
39	10	6	4444	5000	1
40	10	7	2222	1000	15
41	20	5	2222	1000	19
42	20	6	2222	5000	3
43	30	8	2222	10000	0
44	20	6	3333	500	12
45	30	7	1111	500	6
46	20	8	4444	10000	8
47	20	7	2222	500	5
48	30	5	5555	5000	18
49	30	8	4444	1000	15
50	10	6	5555	1000	4
51	10	7	1111	5000	13
52	10	5	2222	500	5
53	10	6	3333	10000	18
54	20	7	4444	500	11
55	10	7	5555	5000	23
56	20	6	2222	1000	14
57	30	5	1111	1000	3
58	30	7	3333	5000	9
59	20	6	2222	500	17
60	20	7	4444	10000	19
61	20	8	3333	5000	4
62	30	8	5555	1000	7
63	30	6	4444	1000	5
64	30	7	1111	5000	8
65	10	5	2222	10000	21
66	10	6	1111	500	15
67	20	7	2222	500	6
68	30	6	3333	10000	9
69	20	7	4444	500	0
70	10	8	2222	10000	15
71	30	6	5555	5000	12
72	30	7	4444	1000	10
73	30	5	5555	500	8
74	20	7	3333	500	12
75	10	6	1111	10000	6
76	10	7	5555	5000	8

Answer rating: 100% (QA)

Before putting the pivot we will insert a column called Defective in which we calculate the percenta... View the full answer