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 acceptable 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. Analysis #1: Number of batches of each product produced in each Machine Analysis #2: The sum of defective products, from each product group, produced by each employee Analysis #3: The sum of batch size, and the sum of defective products for each employee Here is the data for the problem BATCH PRODUCT MACHINE EMPLOYEE BATCH SIZE NUM DEFECTIVE 1 10 5 3333 500 16 2 20 7 5555 10000 10 3 30 6 2222 5000 13 4 30 8 4444 1000 12 5 20 6 3333 1000 5 6 20 7 1111 5000 9 7 30 8 2222 10000 20 8 10 5 3333 10000 14 9 10 6 1111 5000 17 10 30 7 5555 500 19 11 20 5 3333 500 4 12 30 7 4444 1000 7 13 10 8 2222 5000 5 14 30 6 3333 10000 8 15 30 7 1111 10000 21 16 10 5 1111 5000 15 17 10 6 1111 500 6 18 10 8 4444 500 9 19 10 7 3333 500 0 20 20 6 2222 1000 15 21 10 7 5555 10000 12 22 20 8 3333 10000 10 23 30 7 4444 10000 8 24 30 8 2222 5000 12 25 20 7 5555 1000 6 26 20 6 1111 1000 8 27 20 6 2222 5000 5 28 30 7 3333 10000 18 29 30 8 4444 500 15 30 30 5 5555 500 4 31 10 6 4444 10000 13 32 10 5 5555 500 5 33 20 7 3333 5000 18 34 30 5 2222 1000 11 35 30 8 4444 1000 23 36 20 6 1111 5000 14 37 10 7 3333 500 3 38 30 8 2222 10000 9 39 10 6 4444 5000 1 40 10 7 2222 1000 15 41 20 5 2222 1000 19 42 20 6 2222 5000 3 43 30 8 2222 10000 0 44 20 6 3333 500 12 45 30 7 1111 500 6 46 20 8 4444 10000 8 47 20 7 2222 500 5 48 30 5 5555 5000 18 49 30 8 4444 1000 15 50 10 6 5555 1000 4 51 10 7 1111 5000 13 52 10 5 2222 500 5 53 10 6 3333 10000 18 54 20 7 4444 500 11 55 10 7 5555 5000 23 56 20 6 2222 1000 14 57 30 5 1111 1000 3 58 30 7 3333 5000 9 59 20 6 2222 500 17 60 20 7 4444 10000 19 61 20 8 3333 5000 4 62 30 8 5555 1000 7 63 30 6 4444 1000 5 64 30 7 1111 5000 8 65 10 5 2222 10000 21 66 10 6 1111 500 15 67 20 7 2222 500 6 68 30 6 3333 10000 9 69 20 7 4444 500 0 70 10 8 2222 10000 15 71 30 6 5555 5000 12 72 30 7 4444 1000 10 73 30 5 5555 500 8 74 20 7 3333 500 12 75 10 6 1111 10000 6 76 10 7 5555

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 acceptable 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. Analysis #1: Number of batches of each product produced in each Machine Analysis #2: The sum of defective products, from each product group, produced by each employee Analysis #3: The sum of batch size, and the sum of defective products for each employee Here is the data for the problem BATCH PRODUCT MACHINE EMPLOYEE BATCH SIZE NUM DEFECTIVE 1 10 5 3333 500 16 2 20 7 5555 10000 10 3 30 6 2222 5000 13 4 30 8 4444 1000 12 5 20 6 3333 1000 5 6 20 7 1111 5000 9 7 30 8 2222 10000 20 8 10 5 3333 10000 14 9 10 6 1111 5000 17 10 30 7 5555 500 19 11 20 5 3333 500 4 12 30 7 4444 1000 7 13 10 8 2222 5000 5 14 30 6 3333 10000 8 15 30 7 1111 10000 21 16 10 5 1111 5000 15 17 10 6 1111 500 6 18 10 8 4444 500 9 19 10 7 3333 500 0 20 20 6 2222 1000 15 21 10 7 5555 10000 12 22 20 8 3333 10000 10 23 30 7 4444 10000 8 24 30 8 2222 5000 12 25 20 7 5555 1000 6 26 20 6 1111 1000 8 27 20 6 2222 5000 5 28 30 7 3333 10000 18 29 30 8 4444 500 15 30 30 5 5555 500 4 31 10 6 4444 10000 13 32 10 5 5555 500 5 33 20 7 3333 5000 18 34 30 5 2222 1000 11 35 30 8 4444 1000 23 36 20 6 1111 5000 14 37 10 7 3333 500 3 38 30 8 2222 10000 9 39 10 6 4444 5000 1 40 10 7 2222 1000 15 41 20 5 2222 1000 19 42 20 6 2222 5000 3 43 30 8 2222 10000 0 44 20 6 3333 500 12 45 30 7 1111 500 6 46 20 8 4444 10000 8 47 20 7 2222 500 5 48 30 5 5555 5000 18 49 30 8 4444 1000 15 50 10 6 5555 1000 4 51 10 7 1111 5000 13 52 10 5 2222 500 5 53 10 6 3333 10000 18 54 20 7 4444 500 11 55 10 7 5555 5000 23 56 20 6 2222 1000 14 57 30 5 1111 1000 3 58 30 7 3333 5000 9 59 20 6 2222 500 17 60 20 7 4444 10000 19 61 20 8 3333 5000 4 62 30 8 5555 1000 7 63 30 6 4444 1000 5 64 30 7 1111 5000 8 65 10 5 2222 10000 21 66 10 6 1111 500 15 67 20 7 2222 500 6 68 30 6 3333 10000 9 69 20 7 4444 500 0 70 10 8 2222 10000 15 71 30 6 5555 5000 12 72 30 7 4444 1000 10 73 30 5 5555 500 8 74 20 7 3333 500 12 75 10 6 1111 10000 6 76 10 7 5555

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%

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.

Analysis #1: Number of batches of each product produced in each Machine

Analysis #2: The sum of defective products, from each product group, produced by each employee

Analysis #3: The sum of batch size, and the sum of defective products for each employee

Here is the data for the problem

BATCH	PRODUCT	MACHINE	EMPLOYEE	BATCH SIZE	NUM DEFECTIVE
1	10	5	3333	500	16
2	20	7	5555	10000	10
3	30	6	2222	5000	13
4	30	8	4444	1000	12
5	20	6	3333	1000	5
6	20	7	1111	5000	9
7	30	8	2222	10000	20
8	10	5	3333	10000	14
9	10	6	1111	5000	17
10	30	7	5555	500	19
11	20	5	3333	500	4
12	30	7	4444	1000	7
13	10	8	2222	5000	5
14	30	6	3333	10000	8
15	30	7	1111	10000	21
16	10	5	1111	5000	15
17	10	6	1111	500	6
18	10	8	4444	500	9
19	10	7	3333	500	0
20	20	6	2222	1000	15
21	10	7	5555	10000	12
22	20	8	3333	10000	10
23	30	7	4444	10000	8
24	30	8	2222	5000	12
25	20	7	5555	1000	6
26	20	6	1111	1000	8
27	20	6	2222	5000	5
28	30	7	3333	10000	18
29	30	8	4444	500	15
30	30	5	5555	500	4
31	10	6	4444	10000	13
32	10	5	5555	500	5
33	20	7	3333	5000	18
34	30	5	2222	1000	11
35	30	8	4444	1000	23
36	20	6	1111	5000	14
37	10	7	3333	500	3
38	30	8	2222	10000	9
39	10	6	4444	5000	1
40	10	7	2222	1000	15
41	20	5	2222	1000	19
42	20	6	2222	5000	3
43	30	8	2222	10000	0
44	20	6	3333	500	12
45	30	7	1111	500	6
46	20	8	4444	10000	8
47	20	7	2222	500	5
48	30	5	5555	5000	18
49	30	8	4444	1000	15
50	10	6	5555	1000	4
51	10	7	1111	5000	13
52	10	5	2222	500	5
53	10	6	3333	10000	18
54	20	7	4444	500	11
55	10	7	5555	5000	23
56	20	6	2222	1000	14
57	30	5	1111	1000	3
58	30	7	3333	5000	9
59	20	6	2222	500	17
60	20	7	4444	10000	19
61	20	8	3333	5000	4
62	30	8	5555	1000	7
63	30	6	4444	1000	5
64	30	7	1111	5000	8
65	10	5	2222	10000	21
66	10	6	1111	500	15
67	20	7	2222	500	6
68	30	6	3333	10000	9
69	20	7	4444	500	0
70	10	8	2222	10000	15
71	30	6	5555	5000	12
72	30	7	4444	1000	10
73	30	5	5555	500	8
74	20	7	3333	500	12
75	10	6	1111	10000	6
76	10	7	5555	5000	8

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 7 images

SEE SOLUTION Check out a sample Q&A here