70.2K

Verified Solution

Link Copied!

Production Errors Attached Files 13 Tshirt Production Data Flexx (12126 KB) Established in 2000 tshirts com has rapidly become the place to find order and save on Tshirts One huge selling factor is that the company manufactures its own T-Shirts However, the quality manager for production plant, Kasey Hamish has noticed an unacceptable number of defective T Shirts being produced You have been hired to assist Kasey in understanding where theproblems are concentrated He suggests using Excor Pivot Table feature to perform an analysis and has provided you with the Ta Tshirt Production Data Filexx The following is abne definition of the information within the data 1 Batch A unique number that identifies each batch or group of products produced 2 Product Aunque number that identities each product 3 Machine Aunque number that identifies each machine on which products are produced 4 Employee. Aunque number that does each employee producing products 5 Batch Sure The number of products produced in a given batch Numelect the number of detective products produced in a given batch fr H8 G H D EMPLOYEE 3333 5555 2222 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 A BATCH PRODUCT 1 10 2 20 3 30 4 30 5 20 6 20 7 30 8 10 9 10 10 30 11 20 12 30 13 10 14 30 15 30 16 10 17 10 18 10 19 10 20 20 21 10 22 20 23 30 24 30 25 20 26 20 Sheet1 MACHINE 5 7 6 8 6 7 8 5 6 7 5 7 8 6 7 5 6 8 7 6 7 8 7 8 7 6 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 BATCH SIZE 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 F NUM DEFECTIVE 16 10 13 12 5 9 20 14 17 19 4 7 5 8 21 15 9 0 15 12 10 8 12 6 Sheet1 File Home Insert Draw Page Layout Formulas Data Review View Add-ins Help Team D) PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing HS f E F C 6 6 7 8 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 A 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 B 20 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 30 20 20 6 5 7 5 8 6 7 8 6 7 5 6 8 6 7 B 7 5 8 6 7 5 D 1111 2222 3333 4444 5555 4444 5555 3333 2222 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 8 5 18 15 4 13 5 18 11 23 14 3 9 1 15 19 3 0 12 6 8 5 18 15 4 13 5 1111 4444 2222 5555 4444 5555 1111 2222 Sheet1 File Home PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit. It's safer to stay in Protected View. Enable Editing HE > fr F E G 53 54 55 56 57 58 59 60 61 62 63 64 C567765767886 A 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 B 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 D 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 5555 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 5 18 11 23 14 3 9 17 19 4 7 5 8 21 15 6 9 0 15 12 10 8 12 6 8 7 5 6 7 6 7 8 6 7 5 7 6 7 66 67 68 69 70 71 72 73 74 75 76 77 78 79 Sheet1 Production Errors Attached Files 13 Tshirt Production Data Flexx (12126 KB) Established in 2000 tshirts com has rapidly become the place to find order and save on Tshirts One huge selling factor is that the company manufactures its own T-Shirts However, the quality manager for production plant, Kasey Hamish has noticed an unacceptable number of defective T Shirts being produced You have been hired to assist Kasey in understanding where theproblems are concentrated He suggests using Excor Pivot Table feature to perform an analysis and has provided you with the Ta Tshirt Production Data Filexx The following is abne definition of the information within the data 1 Batch A unique number that identifies each batch or group of products produced 2 Product Aunque number that identities each product 3 Machine Aunque number that identifies each machine on which products are produced 4 Employee. Aunque number that does each employee producing products 5 Batch Sure The number of products produced in a given batch Numelect the number of detective products produced in a given batch fr H8 G H D EMPLOYEE 3333 5555 2222 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 A BATCH PRODUCT 1 10 2 20 3 30 4 30 5 20 6 20 7 30 8 10 9 10 10 30 11 20 12 30 13 10 14 30 15 30 16 10 17 10 18 10 19 10 20 20 21 10 22 20 23 30 24 30 25 20 26 20 Sheet1 MACHINE 5 7 6 8 6 7 8 5 6 7 5 7 8 6 7 5 6 8 7 6 7 8 7 8 7 6 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 BATCH SIZE 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 F NUM DEFECTIVE 16 10 13 12 5 9 20 14 17 19 4 7 5 8 21 15 9 0 15 12 10 8 12 6 Sheet1 File Home Insert Draw Page Layout Formulas Data Review View Add-ins Help Team D) PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing HS f E F C 6 6 7 8 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 A 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 B 20 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 30 20 20 6 5 7 5 8 6 7 8 6 7 5 6 8 6 7 B 7 5 8 6 7 5 D 1111 2222 3333 4444 5555 4444 5555 3333 2222 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 8 5 18 15 4 13 5 18 11 23 14 3 9 1 15 19 3 0 12 6 8 5 18 15 4 13 5 1111 4444 2222 5555 4444 5555 1111 2222 Sheet1 File Home PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit. It's safer to stay in Protected View. Enable Editing HE > fr F E G 53 54 55 56 57 58 59 60 61 62 63 64 C567765767886 A 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 B 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 D 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 5555 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 5 18 11 23 14 3 9 17 19 4 7 5 8 21 15 6 9 0 15 12 10 8 12 6 8 7 5 6 7 6 7 8 6 7 5 7 6 7 66 67 68 69 70 71 72 73 74 75 76 77 78 79 Sheet1

Answer & Explanation Solved by verified expert

See Answer