Step 1 Prepare your data for analysis by calculating two Defect Rates. The first rate (BatchDefectRate) should be created in column G of the data table using an Excel formula. This tells you the (per row) rate of defects in a %. After youve created a Pivot Table from the table, though, youll next want to create a Calculated Field (under Fields, Items & Sets) and name it to DefectRate. The Formula for DefectRate = DEFECTIVE QTY / BATCH QTY. Play around with these two rates in the Values area of a PivotTable (using the Average aggregation for BatchDefectRate and Sum for DefectRate), and convince yourself that they yield different answers .

Step 2. Conduct your analysis. You will use the calculated field defect rate for all analyses. While the executives have set you up to answer some initial questions first (in the data description section), this is the smaller part of the analysis. The important part is to determine which combination of two factors is causing the highest defect rate. Use the suggested notes on the last page of the instructions file or your own method for capturing insights from the many PivotTables you'll create (complete analyses generate 10+), along with your observations about each.

Step 3 Once you have finished your analysis, write up a maximum 3-page report in memo format communicating your results. This should contain all the sections requested in the Required Organization and Content section of the instructions and include the top 3-5 tables and/or charts in the appropriate sections as indicated by the rubric. These will answer the executives' questions and show the root cause of the problem.

BATCH	PRODUCT	MACHINE	EMPLOYEE	BATCH QTY	DEFECTIVE QTY	BatchDefectRate
1	Dress	5	Liam	250	12
2	Aloha	6	Elijah	750	24
3	Tunic	8	Charlotte	500	19
4	Dress	8	Freya	500	21
5	Formal	7	Freya	750	18
6	Aloha	8	Ruby	1000	29
7	Dress	5	Charlotte	1000	20
8	Formal	8	Ruby	750	25
9	Dress	6	Freya	250	12
10	Tunic	7	Elijah	250	14
11	Aloha	8	Liam	750	15
12	Dress	8	Ruby	1000	18
13	Formal	7	Elijah	1000	43
14	Formal	5	Ruby	750	22
15	Formal	6	Ruby	250	16
16	Tunic	6	Liam	250	22
17	Dress	7	Liam	250	8
18	Aloha	6	Freya	500	8
19	Dress	8	Ruby	1000	26
20	Tunic	7	Ruby	1000	20
21	Aloha	8	Elijah	750	21
22	Formal	6	Freya	500	14
23	Aloha	6	Freya	750	10
24	Dress	7	Ruby	1000	21
25	Tunic	8	Ruby	250	20
26	Tunic	6	Liam	1000	22
27	Dress	7	Freya	750	44
28	Aloha	5	Elijah	500	24
29	Tunic	8	Elijah	500	35
30	Formal	6	Freya	750	30
31	Dress	7	Liam	250	17
32	Aloha	8	Elijah	1000	14
33	Tunic	6	Liam	750	12
34	Aloha	7	Liam	500	20
35	Aloha	5	Freya	500	25
36	Aloha	6	Freya	750	13
37	Aloha	8	Elijah	1000	11
38	Dress	6	Ruby	250	22
39	Formal	7	Elijah	250	19
40	Tunic	8	Freya	1000	11
41	Aloha	7	Freya	250	11
42	Tunic	8	Elijah	500	22
43	Formal	5	Liam	750	27
44	Formal	5	Liam	250	14
45	Dress	8	Liam	1000	36
46	Tunic	7	Freya	250	23
47	Aloha	5	Freya	500	21
48	Formal	5	Ruby	500	10
49	Dress	5	Elijah	750	16
50	Aloha	6	Freya	250	22
51	Tunic	7	Ruby	1000	32
52	Dress	8	Freya	750	19
53	Tunic	6	Ruby	500	18
54	Formal	7	Elijah	750	17
55	Aloha	5	Ruby	1000	26
56	Formal	6	Liam	250	34
57	Aloha	7	Freya	250	6
58	Dress	6	Elijah	1000	17
59	Tunic	7	Freya	250	8
60	Aloha	8	Liam	1000	34
61	Tunic	7	Elijah	500	20
62	Dress	7	Ruby	250	16
63	Formal	6	Liam	1000	23
64	Dress	7	Charlotte	750	18
65	Tunic	5	Charlotte	1000	23
66	Aloha	8	Ruby	250	23
67	Formal	7	Charlotte	250	19
68	Formal	6	Charlotte	1000	14
69	Dress	7	Charlotte	250	9
70	Tunic	6	Charlotte	1000	22
71	Tunic	5	Ruby	500	16
72	Dress	7	Charlotte	250	19
73	Aloha	6	Charlotte	1000	16
74	Tunic	5	Elijah	500	13
75	Formal	5	Elijah	750	18
76	Dress	5	Freya	250	27
77	Aloha	5	Freya	1000	33
78	Tunic	8	Freya	750	9
79	Aloha	6	Elijah	500	14
80	Formal	5	Elijah	750	21
81	Aloha	5	Liam	1000	31
82	Formal	6	Liam	250	20
83	Dress	7	Freya	250	12
84	Formal	6	Elijah	1000	13
85	Tunic	7	Freya	250	6
86	Aloha	8	Liam	1000	26
87	Tunic	5	Elijah	750	13
88	Dress	7	Freya	500	21
89	Formal	6	Liam	500	22
90	Dress	7	Charlotte	750	16
91	Aloha	5	Charlotte	250	9
92	Aloha	8	Liam	1000	27
93	Tunic	6	Elijah	750	19
94	Dress	5	Ruby	500	23
95	Formal	8	Liam	500	19
96	Dress	6	Charlotte	750	23
97	Aloha	6	Liam	1000	20
98	Dress	7	Elijah	250	23
99	Formal	6	Ruby	250	27
100	Dress	7	Liam	1000	15
101	Tunic	8	Charlotte	250	21
102	Aloha	7	Liam	500	46
103	Formal	7	Elijah	750	17
104	Aloha	6	Ruby	250	26
105	Dress	5	Charlotte	1000	18
106	Aloha	6	Freya	500	8
107	Formal	5	Liam	750	29
108	Formal	6	Liam	1000	17
109	Tunic	5	Elijah	500	17
110	Aloha	5	Charlotte	250	31