Copper wires are covered with a thin plastic coating, and engineers want to avoid undercoating or overcoating the wires. Of the thousands of wires coated per hour, six are selected at random and the sample mean thickness of the coating (mils) is measured. You have been provided with data from the last 120 hours. Use the first 20 samples as the base period. Draw the appropriate control chart(s) The data is available in an xlsx file on Canvas. There are 120 rows of data, and each row is one of the samples of size 6. For example in the first row you will see the observations { 140.8, 147.1, 153.6, 150.3, 152.0, 147.0}. These are the six coatings (measured in mils) measured in the first sample (Hour #1). 7a Find the values of the LCL and UCL for the chart(s). 7b What assumptions about the data are you required to make? 70 Does this process appear to be in control? Comment. 1 2 147.0 155.2 149.4 3 4 153.6 149.5 144.2 153.4 155.3 149.8 152.0 149.7 155.9 149.9 148.2 151.1 145.4 154.1 148.1 154.8 5 6 149.6 7 150.4 143.8 08 157.8 8 9 150.5 10 11 12 13 140.8 150.8 148.4 148.7 149.0 143.8 145.3 155.1 141.5 154.8 153.5 147.1 155.3 142.6 158.8 145.0 142.8 157.2 152.5 147.1 152.4 157.3 147.7 155.5 146.7 157.8 143.3 146.0 142.4 150.2 151.0 146.8 152.3 148.6 155.7 151.0 150.6 146.9 144.4 144.4 154.0 142.9 145.5 146.5 151.3 149.4 14 150.3 157.3 154.1 149.1 142.2 148.8 151.3 156.9 156.9 150.7 154.6 152.0 147.0 149.8 154.1 144.8 149.3 147.1 152.0 147.5 148.2 153.1 154.7 158.5 151.1 1479 151.3 151.3 152.5 147.6 156.7 156.4 151.8 152.0 145.5 150.4 148.3 154.0 150.9 139.7 158.1 156.2 152.0 153.1 148.8 154.7 148.4 145.8 142.3 152.1 145.3 152.1 154.1 143.5 141.3 147.9 15 16 17 152.4 144.1 151.6 156.6 149.2 156.6 147.2 148.6 143.2 144.9 148.7 154.0 153.5 150.9 143.1 150.8 18 19 20 150.1 151.2 141.0 21 22 23 24 25 26 27 148.4 154.1 165.4 146.2 157.9 148.1 152.9 146.3 143.3 146.8 153.8 155.9 156.6 148.8 159.2 144.8 143.3 28 141.0 29 151.7 30 153.3 153.1 145.6 154.0 154.6 149.3 31 32 33 149.4 148.2 158.1 157.1 145.9 158.0 154.3 158.5 156.9 149.8 156.5 148.7 151.6 144.7 145.6 153.4 157.2 150.1 157.4 145.4 147.1 154.1 145.0 154.5 34 147.5 35 36 37 38 39 40 140.9 157.1 149.5 147.4 152.5 150.4 148.4 140.3 145.0 143.0 142.4 146.6 152.0 157.1 142.0 145.6 152.6 149.7 151.7 154.5 148.4 149.7 143.4 149.2 148.6 148.5 155.8 148.4 147.7 150.7 156.9 147.4 147.3 152.8 145.7 148.0 146.1 154.7 146.2 145.1 159.0 144.7 155.3 143.6 153.6 151.1 145.5 146.0 141.8 142.4 144.1 145.0 149.4 153.2 151.3 151.8 152.5 150.5 144.4 158.9 140.4 150.1 150.3 146.2 158.6 148.6 154.3 41 149.0 153.8 152.4 148.8 147.9 149.6 140.1 153.4 146.3 155.4 143.3 150.3 157.4 154.2 153.4 147.6 151.1 152.4 154.5 145.8 42 43 44 45 46 157.3 160.8 152.1 145.8 144.0 151.1 150.4 136.7 47 153.3 146.3 151.1 154.4 151.4 146.0 151.2 153.3 147.6 147.6 147.9 142.9 147.4 147.6 154.3 48 159.8 49 50 147.4 51 52 149.8 149.8 160.2 147.7 149.7 147.5 154.0 153.1 150.9 143.6 149.6 162.7 138.7 145.4 53 54 148.2 153.2 158.7 55 152.0 155.2 151.5 56 57 58 161.2 152.9 155.9 147.4 151.1 151.9 148.7 142.0 151.5 145,0 154.0 59 60 155.8 61 62 155.1 63 64 65 66 67 688 69 70 71 72 73 74 75 76 149.7 152.8 147.0 144.7 147.2 155.9 152.5 140.6 150.6 147.9 153.4 146.1 155.8 151.6 141.7 154.1 157.4 151.9 154.9 151.1 157.2 145.6 141.2 143.6 153.6 151.6 154.6 147.9 151.0 154.2 159.5 149.9 151.6 145.7 155.6 146.7 154.4 152.6 153.3 155.1 145.5 148.5 146.9 145.9 141.8 152.8 142.5 152.4 145.0 142.9 155.9 150.4 151.7 138.2 157.5 145.0 149.1 149.0 150.4 158.4 160.2 157.1 154.3 150.2 148.8 149.5 148.8 154.7 155.5 145.3 151.1 161.9 147.6 153.9 150.7 153.7 154.7 144.0 151.6 147.5 143.1 147.6 147.5 153.1 147.4 149.7 151.1 156.0 143.4 153.2 150.1 140.1 152.5 147.9 141.1 154.8 145.3 149.3 146.4 143.9 146.3 151.3 151.3 154.4 148.2 148.4 147.3 146.9 153.7 152.1 147.1 151.0 150.5 152.1 145.2 156.2 156.1 144.3 141.9 147.9 153.4 137.7 148.3 154.9 152.3 157.7 153.9 158.4 154.4 144.9 153.7 148.5 149.8 153.6 148.1 147.4 157.4 147.8 151.3 154.1 77 149.1 78 79 153.3 80 145.6 141.6 81 157.4 145.0 82 160.7 883 84 144.7 146.9 151.1 137.3 152.8 155.7 151.6 145.5 150.9 151.8 144.3 159,0 156.6 154.1 144.6 151.8 85 86 887 156.1 147.8 148.5 154.5 153.0 146.5 150.2 140.5 150.0 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 150.5 158.1 155.5 144.1 154.9 146.2 157.6 146.6 146.8 159.2 147.6 146.4 152.4 165.8 165.3 154.8 161.5 161.0 157.3 152.1 143.4 146.8 143.0 146.6 157.0 152.6 151.3 154.1 144.7 154.9 149.3 148.2 149.7 152.8 147.7 155.5 151.3 149.0 157.5 164.0 162.6 151.8 162.6 156.5 166.0 148.5 148.7 143.0 152.4 151.2 157.5 149.0 155.2 141.3 163.7 146.0 155.9 153.6 149.2 157.7 157.2 155.4 154.0 150.0 149.0 154.6 162.1 164.0 161.2 162.2 150.7 142.5 143.3 152.3 149.1 150.9 151.5 151.6 143.5 140.2 144.8 152.1 143.6 149.9 154.1 141.0 151.7 145.0 157.8 147.4 161.8 160.5 161.0 158.4 148.0 151.1 147.7 154.2 146.9 139.2 154.9 143.9 155.1 145.4 148.7 143.2 149.9 154.8 162.2 160.9 156.4 163.4 156.3 160.4 149.8 146.0 147.3 147.0 148.3 142.1 166.3 155.6 159.7 161.0 157.1 156.8 155.4 149.6 153.5 145.0 148.6 103 104 105 106 107 [108 158.6 161.9 148.6 154.0 152.9 148.9 143.3 150.7 146.8 109 110 111 112 113 154.0 142.6 149.6 148.1 150.8 151.2 114 149.8 158.9 154.5 153.2 152.0 157.8 144.5 148.6 153.9 152.6 149.7 150.5 150.4 143.0 144.4 145.7 156.5 157.7 146.8 153.4 145.1 160.1 153.0 149.2 148.2 148.4 146.9 152.9 151.1 162.7 146.6 161.7 156.3 148.2 115 161.1 160.2 146.3 151.8 155.2 150.2 146.1 154.6 143.1 142.6 146.7 148.0 144.0 148.0 142.8 153.8 142.4 146.4 149.7 147.9 156.6 152.0 116 117 118 119 120 147.9 151.0 140.0 162.5 144.8 139.8