MAT510Formulasineedthis.xlsx
Sheet1
| Counts | Country Code | Cycle Time | Moving Range (MR) | Avg | UCL | LCL | Country Code | Average Cycle Time | Avg. Moving Range | UCL | LCL |
| 1 | 1 | 20 | | 34.00 | 84.21 | 0 | 1 | 34.00 | 18.875 | 84.21 | 0 |
| 2 | 1 | 24 | 4 | 34.00 | 84.21 | 0 | 5 | 36.25 | 42.29 | 148.73 | 0 |
| 3 | 1 | 46 | 22 | 34.00 | 84.21 | 0 | 6 | 42.75 | 25.4285714286 | 110.39 | 0 |
| 4 | 1 | 26 | 20 | 34.00 | 84.21 | 0 | 7 | 46.76 | 34.9375 | 139.70 | 0 |
| 5 | 1 | 15 | 11 | 34.00 | 84.21 | 0 | 8 | 37.50 | 15.6666666667 | 88.44 | 0 |
| 6 | 1 | 15 | 0 | 34.00 | 84.21 | 0 | 14 | 59.20 | | 46.76 | 0 |
| 7 | 1 | 31 | 16 | 34.00 | 84.21 | 0 | 17 | 29.29 | | | 0 |
| 8 | 1 | 31 | 0 | 34.00 | 84.21 | 0 |
| 9 | 1 | 32 | 1 | 34.00 | 84.21 | 0 |
| 10 | 1 | 15 | 17 | 34.00 | 84.21 | 0 |
| 11 | 1 | 89 | 74 | 34.00 | 84.21 | 0 |
| 12 | 1 | 36 | 53 | 34.00 | 84.21 | 0 |
| 13 | 1 | 33 | 3 | 34.00 | 84.21 | 0 |
| 14 | 1 | 21 | 12 | 34.00 | 84.21 | 0 |
| 15 | 1 | 22 | 1 | 34.00 | 84.21 | 0 |
| 16 | 1 | 50 | 28 | 34.00 | 84.21 | 0 |
| 17 | 1 | 81 | 31 | 34.00 | 84.21 | 0 |
| 18 | 1 | 28 | 53 | 34.00 | 84.21 | 0 |
| 19 | 1 | 34 | 6 | 34.00 | 84.21 | 0 |
| 20 | 1 | 34 | 0 | 34.00 | 84.21 | 0 |
| 21 | 1 | 52 | 18 | 34.00 | 84.21 | 0 |
| 22 | 1 | 19 | 33 | 34.00 | 84.21 | 0 |
| 23 | 1 | 44 | 25 | 34.00 | 84.21 | 0 |
| 24 | 1 | 33 | 11 | 34.00 | 84.21 | 0 |
| 25 | 1 | 19 | 14 | 34.00 | 84.21 | 0 |
| 1 | 5 | 29 | | 36.25 | 148.73 | 0 |
| 2 | 5 | 44 | 15 | 36.25 | 148.73 | 0 |
| 3 | 5 | 9 | 35 | 36.25 | 148.73 | 0 |
| 4 | 5 | 5 | 4 | 36.25 | 148.73 | 0 |
| 5 | 5 | 29 | 24 | 36.25 | 148.73 | 0 |
| 6 | 5 | 24 | 5 | 36.25 | 148.73 | 0 |
| 7 | 5 | 129 | 105 | 36.25 | 148.73 | 0 |
| 8 | 5 | 21 | 108 | 36.25 | 148.73 | 0 |
| 1 | 6 | 64 | | 42.75 | 110.39 | 0 |
| 2 | 6 | 26 | 38 | 42.75 | 110.39 | 0 |
| 3 | 6 | 47 | 21 | 42.75 | 110.39 | 0 |
| 4 | 6 | 27 | 20 | 42.75 | 110.39 | 0 |
| 5 | 6 | 27 | 0 | 42.75 | 110.39 | 0 |
| 6 | 6 | 40 | 13 | 42.75 | 110.39 | 0 |
| 7 | 6 | 79 | 39 | 42.75 | 110.39 | 0 |
| 8 | 6 | 32 | 47 | 42.75 | 110.39 | 0 |
| 1 | 7 | 11 | | 46.76 | 139.70 | 0 |
| 2 | 7 | 14 | 3 | 46.76 | 139.70 | 0 |
| 3 | 7 | 41 | 27 | 46.76 | 139.70 | 0 |
| 4 | 7 | 18 | 23 | 46.76 | 139.70 | 0 |
| 5 | 7 | 42 | 24 | 46.76 | 139.70 | 0 |
| 6 | 7 | 44 | 2 | 46.76 | 139.70 | 0 |
| 7 | 7 | 157 | 113 | 46.76 | 139.70 | 0 |
| 8 | 7 | 53 | 104 | 46.76 | 139.70 | 0 |
| 9 | 7 | 26 | 27 | 46.76 | 139.70 | 0 |
| 10 | 7 | 50 | 24 | 46.76 | 139.70 | 0 |
| 11 | 7 | 29 | 21 | 46.76 | 139.70 | 0 |
| 12 | 7 | 61 | 32 | 46.76 | 139.70 | 0 |
| 13 | 7 | 88 | 27 | 46.76 | 139.70 | 0 |
| 14 | 7 | 7 | 81 | 46.76 | 139.70 | 0 |
| 15 | 7 | 53 | 46 | 46.76 | 139.70 | 0 |
| 16 | 7 | 53 | 0 | 46.76 | 139.70 | 0 |
| 17 | 7 | 48 | 5 | 46.76 | 139.70 | 0 |
| 1 | 8 | 43 | 5 | 37.50 | 88.44 | 0 |
| 2 | 8 | 28 | 15 | 37.50 | 88.44 | 0 |
| 3 | 8 | 47 | 19 | 37.50 | 88.44 | 0 |
| 4 | 8 | 19 | 28 | 37.50 | 88.44 | 0 |
| 5 | 8 | 42 | 23 | 37.50 | 88.44 | 0 |
| 6 | 8 | 46 | 4 | 37.50 | 88.44 | 0 |
| 1 | 14 | 38 | 8 | 59.20 | 46.76 | 0 |
| 2 | 14 | 150 | 112 | 59.20 | | 0 |
| 3 | 14 | 24 | 126 | 59.20 | | 0 |
| 4 | 14 | 42 | 18 | 59.20 | | 0 |
| 5 | 14 | 42 | 0 | 59.20 | | 0 |
| 1 | 17 | 23 | 19 | 29.29 | | 0 |
| 2 | 17 | 41 | 18 | 29.29 | | 0 |
| 3 | 17 | 21 | 20 | 29.29 | | 0 |
| 4 | 17 | 23 | 2 | 29.29 | | 0 |
| 5 | 17 | 13 | 10 | 29.29 | | 0 |
| 6 | 17 | 41 | 28 | 29.29 | | 0 |
| 7 | 17 | 43 | 2 | 29.29 | | 0 |