I NEED HELP WITH INTERPRETING, in which you communicate your solution to this problem (as you identify what factors are causing the production errors - i.e. which variables appear to be most significantly associated as causes of errors in the production batches) and in which you reference each of the worksheets you created in order to justify your answers (i.e. verbally describing what each of your data analysis worksheets shows and what conclusions can be drawn from it).

Helpful Hint: To achieve especially good presentation / substantiation of your answers, don't hesitate to use conditional formatting upon select rows/columns on your pivot table(s) to better highlight the computations and conclusions which underlie your answers and your overall solution narrative. Moreover, in composing your document, while addressing all exercise questions, please try to also go beyond this by telling a coherent and unified story.

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. How- ever, the quality manager for the production plant, Kasey Harnish, has noticed an unac- ceptable 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:

Batch: A unique number that identifies each batch or group of products produced.

Product: A unique number that identifies each product.

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

produced.

Employee: A unique number that identifies each employee producing products.

Batch Size: The number of products produced in a given batch.

Num Defect: The number of defective products produced in a given batch.

1BATCH PRODUCT MACHINE EMPLOYEE BATCH SIZE NUM DEFECTIVE Defective % 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 2 4 0% 0% 0% 0% 2% 0% 0% no/