. 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. How- ever, 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.
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. How-
ever, 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.


Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images









