MAT 510

lenci104
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