Review Technology Plug-In 3 Problem Solving Using Excel 2016. Complete exercise 1. Production Errors 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. Make fifteen pivottables as follows.

1. Four one-factor pivottables that investigate the defective rates. Use Product, Machine, Employee, and Batch Size as row fields and Num Defect as the value field to make four pivottables.

2. Six two-factor pivottables. Use Product x Machine, Product x Employee, Product x Batch Size, Machine x Employee, Machine x Batch Size, Employee x Batch Size as row and column fields respectively. For example, when you use Product x Machine factors, you put Product as the row field and Machine as the column field. Still, Num Defect is the value field.

3. Four three-factor pivottables. Use Product x Machine x Employee, Product x Machine x Batch Size, Product x Employee x Batch Size, Machine x Employee x Batch Size as row and column fields respectively. For example, when you use Product x Machine x Employee factors, you put Product and Machine as the row fields and Machine as the column field. Still, Num Defect is the value field.

4. One four-factor pivottable. Use Product x Machine x Employee x Batch size as row and column fields. The first three factors can be the row fields, and the last one is the column field. Still, Num Defect is the value field.

Here is the data for this question

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