Assignment Two - provide Average and Range charts per below. Calculate limits based on first 30 subgroups, then plot the charts for average and range After sample #100, maintenance replaced a bearing in the equipment. Recalculate the control limits for data after sample #100 based on samples 101-130. Comment on any patterns that suggest assignable causes are present. Sample 1 2 3 4 5 6 7 8 149.8 144.6 154.9 141.9 145.4 141.4 139.3 144.6 145.8 136.3 152.7 140.8 144.4 140.6 144 143.7 148.9 146.8 140.5 152.7 149.1 150.3 151.7 147.3 144.9 152 143.7 139.6 152 144.1 143.7 141.8 143.1 150.2 147.5 145.7 142.2 146.4 143.2 139.4 141.8 149.1 147.8 150.1 140.7 140.6 143 143.3 139.9 142.6 146.7 147.3 144.9 144.6 149.7 144.8 151.6 149.8 151.5 149.3 138.4 151 149.5 149 142.3 149 147.2 145.8 144.6 142.3 145.7 147.6 141.1 144.6 149.7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 144,4 146.4 148.4 146.4 150.1 145.8 143.3 143.3 159.8 142.6 145.6 147.3 145.9 151 148.6 142.2 147,2 149.1 139.4 142.7 148.3 140.3 146.2 146.8 152.5 146.6 140.3 153,4 148.7 1472 148.3 1412 1422 142.5 149.6 146.7 145 147 144.6 1479 142.6 147.5 144.9 144.9 146 154.3 138.4 150.6 144,3 149.3 145.3 142.1 142.4 149.5 140.8 150.1 147 150,5 138,8 148.4 142.8 152.2 142.5 145.2 144 146.4 147.9 144.7 141 147.4 137 142.3 146.4 145.8 143,8 148,1 143,4 143.8 149 150.3 150 146.1 145.2 148.7 144.9 147.7 144.1 143.3 140.2 141.3 146.3 144.5 149.2 143.3 141.7 142.1 154.3 149.6 147,4 143.5 144.4 146,9 151:4 152.9 148.6 155 141.7 141.5 1421 145 152.3 142.7 147.5 146,9 150.2 145.9 139.6 142.6 141.5 143.2 138.3 150.7 145.1 143.9 149.7 147.2 144,8 139 144.7 149.7 152.9 139.3 157.2 150.9 139.8 1472 144.5 150.8 152.5 149.2 150.9 144 145.9 140.2 149.9 143.1 144,5 149.4 145.4 146 146.5 149.2 150.5 154,6 143.6 138.5 147.8 146.6 146.8 141.3 144.5 146.1 141.6 144.2 148,6 145.5 144.2 149.1 145.7 148.2 146.9 148.7 148.5 145.5 155.2 142 1474 145.2 138.7 40 2 50 51 52 G H 1457 145.7 142& 1412 1414 144.21 1497 1514 54 55 56 57 30 59 60 51 62 63 64 65 66 67 68 141.9 1466 144.2 153.4 143.8 15. 149.0 142.5 342.9 143.5 146.8 147.6 148.9 1461 147.7 150 1413 149 1463 149.6 1935 1396 151.7 1569 147.0 141 1414 150.1 1465 1457 145 146 1505 147.0 1452 1505 146 142 148 145.7 1425 152.1 141.6 139.4 1437 144.4 146.6 1495 140.7 14,2 150.3 145 145.4 142 1452 142.6 142.9 1453 144.6 1418 147 146.9 146.7 148.6 142.5 145.9 150.6 146.8 1508 150.3 143.1 141 138.1 245 148.2 144.4 144.8 143.6 & 144 1465 144 148.4 1487 1515 1456 1367 14& 1518 1408 1386 1439 70 71 72 73 74 75 76 77 78 79 90 B1 B2 83 B4 BS 152 146.5 145.3 155.2 144.9 149.6 146.7 144 151.6 149.9 146.8 143.2 1473 148.7 1414 152.5 1421 150 1436 144 148.5 1519 1426 145.2 144.1 1441 137.1 145.6 143.2 145.7 149.4 149.4 145.6 151.6 145.7 1473 1454 145.5 145.2 144.8 153.7 1434 147.5 1472 144.1 147 154.1 144.5 140.7 155.B 138.2 142 144.1 1466 147.2 149.1 156 145 1464 146.3 1421 145 146.6 148.6 139.7 144.3 149.5 148.7 1446 1549 1378 1445 1528 147.1 1373 1453 1427 1473 1403 145 1558 BH 89 PO 91 92 93 94 95 96 97 98 140.7 146.4 144 1469 149.4 1393 147.5 1391 1435 1430 148 1425 147.2 1568 144.1 1477 145.7 1414 1434 1448 149 144.9 139.3 1542 142.9 149 144.9 143.4 144.3 14.5 1417 147.0 143.0 1469 144.2 150.1 146.5 146.6 145 148.7 146.2 146.4 142.7 146.8 149.4 149.3 158,5 147.5 149.2 143.0 143.8 141,6 150,6 147 1446 66 149.4 1488 1422 1413 1417 147.5 1458 100 101 102 102 103 104 105 106 102 10 106 145 143.4 147.2 144.5 1435 1440 149.8 104 1471 114 24 A- 11 1463 1451 1441 14.4 1469 141 1457 1467 142 1478 E 147.9 14 45 11.6 1461 1438 1 141.6 3452 145.2 144.4 141.5 139.9 1468 1415 149.1 145.4 144 3470 - 1422 149.7 121 1437 149 149.5 1458 1487 123 124 1393 1453 1496 1473 1 142.7 122 1433 142 105 25 , 130 131 147.5 MS- 145.3 147.5 144 142.8 145.3 145.7 1511 147.2 147.2 16 149.8 1467 1465 145 145 1421 147 133 34 135 136 197 516 139 1069 1423 147.8 1472 1463 54 346.2 145.2 145.5 145.3 145.6 145.8 1453 1436 105 145 1486 147.9 1421 1421 1503 14345 14 1 1473 145.5 1516 1452 145.5 147.3 3412 141 142 149 144 1 146 147 AE 149 150 151 152 144.3 3.9 5464 14 1473 144.2 142.2 14 1501 14. 148.5 1469 : 145.2 1 149.1 14: 145.6 GA =468 15) 1 C. 1486 1451 . 154 155 156 157 34E 154 160 161 162 163 164 165 JAE 167 1AE 169 170 171 172 1478 14: 14 1458 30 146.2 147 145 147.2 145.5 1473 150 149.0 1469 150 1566 1462 14E 1458 1489 1456 1456 145.4 1483 145 144.8 1473 1430 145.9 1469 145.2 146.3 1441 146 1462 142.8 140 1458 1422 1463 144.4 1486 130 1463 342 : 1476 146.3 1472 1477 146 145.1 1403 1513 3656 346 105 140 1452 145.4 143 146 149.1 114 175 176 177 176 129 186 181 182 183 184 185 186 3 145 1471 1452 1451 150 2 1469 108 1433 101 149.9 1489 3472 E- -- 1 3625 1993 187 100 2472 145.7 188 189 1457 1464 1443 145.9 1451 1453 1475 1415 191 1425 147 14514 1464 195 1 14 105 Assignment Two - provide Average and Range charts per below. Calculate limits based on first 30 subgroups, then plot the charts for average and range After sample #100, maintenance replaced a bearing in the equipment. Recalculate the control limits for data after sample #100 based on samples 101-130. Comment on any patterns that suggest assignable causes are present. Sample 1 2 3 4 5 6 7 8 149.8 144.6 154.9 141.9 145.4 141.4 139.3 144.6 145.8 136.3 152.7 140.8 144.4 140.6 144 143.7 148.9 146.8 140.5 152.7 149.1 150.3 151.7 147.3 144.9 152 143.7 139.6 152 144.1 143.7 141.8 143.1 150.2 147.5 145.7 142.2 146.4 143.2 139.4 141.8 149.1 147.8 150.1 140.7 140.6 143 143.3 139.9 142.6 146.7 147.3 144.9 144.6 149.7 144.8 151.6 149.8 151.5 149.3 138.4 151 149.5 149 142.3 149 147.2 145.8 144.6 142.3 145.7 147.6 141.1 144.6 149.7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 144,4 146.4 148.4 146.4 150.1 145.8 143.3 143.3 159.8 142.6 145.6 147.3 145.9 151 148.6 142.2 147,2 149.1 139.4 142.7 148.3 140.3 146.2 146.8 152.5 146.6 140.3 153,4 148.7 1472 148.3 1412 1422 142.5 149.6 146.7 145 147 144.6 1479 142.6 147.5 144.9 144.9 146 154.3 138.4 150.6 144,3 149.3 145.3 142.1 142.4 149.5 140.8 150.1 147 150,5 138,8 148.4 142.8 152.2 142.5 145.2 144 146.4 147.9 144.7 141 147.4 137 142.3 146.4 145.8 143,8 148,1 143,4 143.8 149 150.3 150 146.1 145.2 148.7 144.9 147.7 144.1 143.3 140.2 141.3 146.3 144.5 149.2 143.3 141.7 142.1 154.3 149.6 147,4 143.5 144.4 146,9 151:4 152.9 148.6 155 141.7 141.5 1421 145 152.3 142.7 147.5 146,9 150.2 145.9 139.6 142.6 141.5 143.2 138.3 150.7 145.1 143.9 149.7 147.2 144,8 139 144.7 149.7 152.9 139.3 157.2 150.9 139.8 1472 144.5 150.8 152.5 149.2 150.9 144 145.9 140.2 149.9 143.1 144,5 149.4 145.4 146 146.5 149.2 150.5 154,6 143.6 138.5 147.8 146.6 146.8 141.3 144.5 146.1 141.6 144.2 148,6 145.5 144.2 149.1 145.7 148.2 146.9 148.7 148.5 145.5 155.2 142 1474 145.2 138.7 40 2 50 51 52 G H 1457 145.7 142& 1412 1414 144.21 1497 1514 54 55 56 57 30 59 60 51 62 63 64 65 66 67 68 141.9 1466 144.2 153.4 143.8 15. 149.0 142.5 342.9 143.5 146.8 147.6 148.9 1461 147.7 150 1413 149 1463 149.6 1935 1396 151.7 1569 147.0 141 1414 150.1 1465 1457 145 146 1505 147.0 1452 1505 146 142 148 145.7 1425 152.1 141.6 139.4 1437 144.4 146.6 1495 140.7 14,2 150.3 145 145.4 142 1452 142.6 142.9 1453 144.6 1418 147 146.9 146.7 148.6 142.5 145.9 150.6 146.8 1508 150.3 143.1 141 138.1 245 148.2 144.4 144.8 143.6 & 144 1465 144 148.4 1487 1515 1456 1367 14& 1518 1408 1386 1439 70 71 72 73 74 75 76 77 78 79 90 B1 B2 83 B4 BS 152 146.5 145.3 155.2 144.9 149.6 146.7 144 151.6 149.9 146.8 143.2 1473 148.7 1414 152.5 1421 150 1436 144 148.5 1519 1426 145.2 144.1 1441 137.1 145.6 143.2 145.7 149.4 149.4 145.6 151.6 145.7 1473 1454 145.5 145.2 144.8 153.7 1434 147.5 1472 144.1 147 154.1 144.5 140.7 155.B 138.2 142 144.1 1466 147.2 149.1 156 145 1464 146.3 1421 145 146.6 148.6 139.7 144.3 149.5 148.7 1446 1549 1378 1445 1528 147.1 1373 1453 1427 1473 1403 145 1558 BH 89 PO 91 92 93 94 95 96 97 98 140.7 146.4 144 1469 149.4 1393 147.5 1391 1435 1430 148 1425 147.2 1568 144.1 1477 145.7 1414 1434 1448 149 144.9 139.3 1542 142.9 149 144.9 143.4 144.3 14.5 1417 147.0 143.0 1469 144.2 150.1 146.5 146.6 145 148.7 146.2 146.4 142.7 146.8 149.4 149.3 158,5 147.5 149.2 143.0 143.8 141,6 150,6 147 1446 66 149.4 1488 1422 1413 1417 147.5 1458 100 101 102 102 103 104 105 106 102 10 106 145 143.4 147.2 144.5 1435 1440 149.8 104 1471 114 24 A- 11 1463 1451 1441 14.4 1469 141 1457 1467 142 1478 E 147.9 14 45 11.6 1461 1438 1 141.6 3452 145.2 144.4 141.5 139.9 1468 1415 149.1 145.4 144 3470 - 1422 149.7 121 1437 149 149.5 1458 1487 123 124 1393 1453 1496 1473 1 142.7 122 1433 142 105 25 , 130 131 147.5 MS- 145.3 147.5 144 142.8 145.3 145.7 1511 147.2 147.2 16 149.8 1467 1465 145 145 1421 147 133 34 135 136 197 516 139 1069 1423 147.8 1472 1463 54 346.2 145.2 145.5 145.3 145.6 145.8 1453 1436 105 145 1486 147.9 1421 1421 1503 14345 14 1 1473 145.5 1516 1452 145.5 147.3 3412 141 142 149 144 1 146 147 AE 149 150 151 152 144.3 3.9 5464 14 1473 144.2 142.2 14 1501 14. 148.5 1469 : 145.2 1 149.1 14: 145.6 GA =468 15) 1 C. 1486 1451 . 154 155 156 157 34E 154 160 161 162 163 164 165 JAE 167 1AE 169 170 171 172 1478 14: 14 1458 30 146.2 147 145 147.2 145.5 1473 150 149.0 1469 150 1566 1462 14E 1458 1489 1456 1456 145.4 1483 145 144.8 1473 1430 145.9 1469 145.2 146.3 1441 146 1462 142.8 140 1458 1422 1463 144.4 1486 130 1463 342 : 1476 146.3 1472 1477 146 145.1 1403 1513 3656 346 105 140 1452 145.4 143 146 149.1 114 175 176 177 176 129 186 181 182 183 184 185 186 3 145 1471 1452 1451 150 2 1469 108 1433 101 149.9 1489 3472 E- -- 1 3625 1993 187 100 2472 145.7 188 189 1457 1464 1443 145.9 1451 1453 1475 1415 191 1425 147 14514 1464 195 1 14 105