Answer & Explanation:Review Technology Plug-In 3 Problem Solving Using Excel 2010. Complete exercise 1. Production ErrorsEstablished 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.
2010_technology_plugin_t3.pdf
