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. your submission for this assignment will consist of two files, both of which should be uploaded to the dropbox for the assignment: one will be your assignment spreadsheet, containing the worksheets you have used to solve this problem (pivot tables, custom filters & conditional formatting).the second file will be a one page word document, 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).batch product machine employee batch size num defective1 10 5 500 162 20 7 1 103 30 6 5000 134 30 8 1000 125 20 6 1000 56 20 7 5000 97 30 8 1 208 10 5 1 149 10 6 5000 1710 30 7 500 1911 20 5 500 412 30 7 1000 713 10 8 5000 514 30 6 1 815 30 7 1 2116 10 5 5000 1517 10 6 500 618 10 8 500 919 10 7 500 020 20 6 1000 1521 10 7 1 1222 20 8 1 1023 30 7 1 824 30 8 5000 1225 20 7 1000 626 20 6 1000 827 20 6 5000 528 30 7 1 1829 30 8 500 1530 30 5 500 431 10 6 1 1332 10 5 500 533 20 7 5000 1834 30 5 1000 1135 30 8 1000 2336 20 6 5000 1437 10 7 500 338 30 8 1 939 10 6 5000 140 10 7 1000 1541 20 5 1000 1942 20 6 5000 343 30 8 1 044 20 6 500 1245 30 7 500 646 20 8 1 847 20 7 500 548 30 5 5000 1849 30 8 1000 1550 10 6 1000 451 10 7 5000 1352 10 5 500 553 10 6 1 1854 20 7 500 1155 10 7 5000 2356 20 6 1000 1457 30 5 1000 358 30 7 5000 959 20 6 500 1760 20 7 1 1961 20 8 5000 462 30 8 1000 763 30 6 1000 564 30 7 5000 865 10 5 1 2166 10 6 500 1567 20 7 500 668 30 6 1 969 20 7 500 070 10 8 1 1571 30 6 5000 1272 30 7 1000 1073 30 5 500 874 20 7 500 1275 10 6 1 676 10 7 5000 8