For Math Stat Genius only
pcwc0506
BUS520M6A13excel.xlsxRaw Data Phone B
| Year 1 = 2016 | ||||||||||||||
| Order # | Order Month [1= Jan, etc] | Phone Type Ordered | Step # 1 [hours] | Step # 2 [Days] | Rework Step # 2 [1 = Yes, 0 = No] | Step # 3 [Hours] | Custom or Std Case? [C=1 or S=2] | Step #4a [Hours] | Step #4b [Hours] | Step #5 [minutes] | Rework Step # 5 [1 = Yes, 0 = No] | Step#6 [Days] | Delay Time at Step # 6 [days] | Step #7 [Hours] |
| 1 | 2 | B | 3 | 8 | 1 | 6 | 2 | 3 | 2 | 28 | 0 | 2 | 2 | 6 |
| 2 | 9 | B | 7 | 8 | 0 | 3 | 1 | 4 | 2 | 36 | 1 | 2 | 2 | 2 |
| 3 | 1 | B | 6 | 8 | 0 | 3 | 1 | 5 | 2 | 28 | 1 | 2 | 1 | 5 |
| 4 | 4 | B | 12 | 8 | 1 | 6 | 1 | 7 | 2 | 29 | 1 | 6 | 2 | 4 |
| 5 | 7 | B | 9 | 7 | 1 | 6 | 1 | 6 | 1 | 40 | 1 | 6 | 3 | 6 |
| 6 | 6 | B | 5 | 3 | 0 | 5 | 2 | 4 | 2 | 34 | 1 | 2 | 3 | 5 |
| 7 | 7 | B | 6 | 3 | 0 | 6 | 2 | 5 | 1 | 27 | 0 | 5 | 0 | 5 |
| 8 | 3 | B | 9 | 3 | 0 | 5 | 1 | 6 | 1 | 28 | 1 | 6 | 0 | 5 |
| 9 | 6 | B | 3 | 4 | 0 | 3 | 1 | 2 | 1 | 34 | 0 | 3 | 1 | 2 |
| 10 | 1 | B | 9 | 3 | 1 | 6 | 2 | 4 | 1 | 26 | 1 | 6 | 2 | 5 |
| 11 | 1 | B | 8 | 7 | 0 | 3 | 1 | 5 | 1 | 21 | 0 | 4 | 1 | 2 |
| 12 | 1 | B | 2 | 8 | 0 | 3 | 1 | 4 | 1 | 26 | 0 | 4 | 3 | 2 |
| 13 | 2 | B | 5 | 7 | 0 | 4 | 2 | 3 | 2 | 20 | 0 | 4 | 1 | 4 |
| 14 | 5 | B | 11 | 6 | 1 | 5 | 2 | 6 | 1 | 26 | 1 | 5 | 2 | 5 |
| 15 | 2 | B | 9 | 6 | 0 | 6 | 2 | 4 | 1 | 23 | 1 | 3 | 0 | 3 |
| 16 | 3 | B | 8 | 4 | 0 | 5 | 2 | 7 | 2 | 25 | 0 | 4 | 3 | 2 |
| 17 | 2 | B | 10 | 3 | 0 | 4 | 2 | 2 | 2 | 25 | 0 | 6 | 1 | 2 |
| 18 | 3 | B | 6 | 7 | 1 | 5 | 1 | 6 | 1 | 34 | 0 | 5 | 1 | 2 |
| 19 | 3 | B | 2 | 3 | 1 | 3 | 1 | 6 | 1 | 24 | 1 | 3 | 3 | 2 |
| 20 | 5 | B | 6 | 5 | 0 | 3 | 1 | 5 | 2 | 39 | 0 | 6 | 2 | 5 |
| 21 | 1 | B | 7 | 3 | 0 | 3 | 1 | 7 | 2 | 28 | 0 | 2 | 1 | 4 |
| 22 | 4 | B | 8 | 8 | 0 | 6 | 2 | 6 | 1 | 23 | 0 | 3 | 0 | 2 |
| 23 | 1 | B | 9 | 6 | 0 | 3 | 2 | 2 | 2 | 25 | 1 | 6 | 2 | 5 |
| 24 | 2 | B | 3 | 7 | 1 | 3 | 2 | 6 | 1 | 31 | 0 | 2 | 0 | 5 |
| 25 | 3 | B | 6 | 6 | 1 | 3 | 1 | 7 | 1 | 23 | 1 | 5 | 3 | 6 |
| 26 | 3 | B | 5 | 8 | 0 | 6 | 1 | 7 | 1 | 26 | 1 | 5 | 2 | 3 |
| 27 | 7 | B | 10 | 3 | 1 | 6 | 2 | 7 | 2 | 37 | 0 | 5 | 2 | 6 |
| 28 | 3 | B | 7 | 7 | 1 | 3 | 1 | 5 | 2 | 38 | 0 | 5 | 2 | 4 |
| 29 | 2 | B | 12 | 8 | 0 | 5 | 2 | 4 | 2 | 23 | 0 | 6 | 0 | 4 |
| 30 | 6 | B | 10 | 3 | 1 | 6 | 2 | 3 | 1 | 26 | 0 | 6 | 2 | 2 |
| 31 | 5 | B | 7 | 5 | 0 | 3 | 1 | 5 | 1 | 20 | 0 | 6 | 0 | 4 |
| 32 | 3 | B | 8 | 7 | 0 | 5 | 1 | 2 | 1 | 24 | 0 | 3 | 3 | 2 |
| 33 | 3 | B | 10 | 8 | 1 | 3 | 2 | 2 | 2 | 33 | 0 | 6 | 3 | 2 |
| 34 | 1 | B | 9 | 6 | 0 | 6 | 1 | 3 | 1 | 26 | 1 | 6 | 0 | 2 |
| 35 | 5 | B | 7 | 4 | 0 | 6 | 1 | 5 | 2 | 40 | 0 | 4 | 2 | 6 |
| 36 | 3 | B | 9 | 7 | 1 | 3 | 2 | 3 | 1 | 30 | 1 | 3 | 2 | 5 |
| 37 | 1 | B | 8 | 7 | 1 | 5 | 1 | 7 | 2 | 36 | 1 | 5 | 1 | 3 |
| 38 | 4 | B | 3 | 8 | 0 | 5 | 2 | 7 | 2 | 38 | 1 | 2 | 2 | 4 |
| 39 | 5 | B | 8 | 5 | 0 | 3 | 1 | 2 | 2 | 37 | 1 | 5 | 2 | 4 |
| 40 | 5 | B | 3 | 7 | 1 | 6 | 1 | 6 | 2 | 24 | 0 | 5 | 0 | 3 |
| 41 | 5 | B | 6 | 5 | 0 | 5 | 2 | 4 | 1 | 34 | 0 | 6 | 2 | 4 |
| 42 | 1 | B | 4 | 6 | 1 | 5 | 1 | 2 | 2 | 32 | 1 | 3 | 1 | 5 |
Step 1
| Step # 1 | Mean | UCL | LCL |
| 3 | 7.0238095238 | 15.0432762573 | 0 |
| 7 | 7.0238095238 | 15.0432762573 | 0 |
| 6 | 7.0238095238 | 15.0432762573 | 0 |
| 12 | 7.0238095238 | 15.0432762573 | 0 |
| 9 | 7.0238095238 | 15.0432762573 | 0 |
| 5 | 7.0238095238 | 15.0432762573 | 0 |
| 6 | 7.0238095238 | 15.0432762573 | 0 |
| 9 | 7.0238095238 | 15.0432762573 | 0 |
| 3 | 7.0238095238 | 15.0432762573 | 0 |
| 9 | 7.0238095238 | 15.0432762573 | 0 |
| 8 | 7.0238095238 | 15.0432762573 | 0 |
| 2 | 7.0238095238 | 15.0432762573 | 0 |
| 5 | 7.0238095238 | 15.0432762573 | 0 |
| 11 | 7.0238095238 | 15.0432762573 | 0 |
| 9 | 7.0238095238 | 15.0432762573 | 0 |
| 8 | 7.0238095238 | 15.0432762573 | 0 |
| 10 | 7.0238095238 | 15.0432762573 | 0 |
| 6 | 7.0238095238 | 15.0432762573 | 0 |
| 2 | 7.0238095238 | 15.0432762573 | 0 |
| 6 | 7.0238095238 | 15.0432762573 | 0 |
| 7 | 7.0238095238 | 15.0432762573 | 0 |
| 8 | 7.0238095238 | 15.0432762573 | 0 |
| 9 | 7.0238095238 | 15.0432762573 | 0 |
| 3 | 7.0238095238 | 15.0432762573 | 0 |
| 6 | 7.0238095238 | 15.0432762573 | 0 |
| 5 | 7.0238095238 | 15.0432762573 | 0 |
| 10 | 7.0238095238 | 15.0432762573 | 0 |
| 7 | 7.0238095238 | 15.0432762573 | 0 |
| 12 | 7.0238095238 | 15.0432762573 | 0 |
| 10 | 7.0238095238 | 15.0432762573 | 0 |
| 7 | 7.0238095238 | 15.0432762573 | 0 |
| 8 | 7.0238095238 | 15.0432762573 | 0 |
| 10 | 7.0238095238 | 15.0432762573 | 0 |
| 9 | 7.0238095238 | 15.0432762573 | 0 |
| 7 | 7.0238095238 | 15.0432762573 | 0 |
| 9 | 7.0238095238 | 15.0432762573 | 0 |
| 8 | 7.0238095238 | 15.0432762573 | 0 |
| 3 | 7.0238095238 | 15.0432762573 | 0 |
| 8 | 7.0238095238 | 15.0432762573 | 0 |
| 3 | 7.0238095238 | 15.0432762573 | 0 |
| 6 | 7.0238095238 | 15.0432762573 | 0 |
| 4 | 7.0238095238 | 15.0432762573 | 0 |
| Mean | Std. Deviation | ||
| 7.0238095238 | 2.6731555778 |
Step 1 Control Chart
Step # 1 3 7 6 12 9 5 6 9 3 9 8 2 5 11 9 8 10 6 2 6 7 8 9 3 6 5 10 7 12 10 7 8 10 9 7 9 8 3 8 3 6 4 Mean 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 7.0238095238095237 UCL 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 15.043276257320889 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Hours
Step 2
| Step # 2 | Mean | UCL | LCL |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 4 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 6 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 6 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 4 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 5 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 6 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 6 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 3 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 5 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 6 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 4 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 8 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 5 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 7 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 5 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| 6 | 5.8333333333 | 11.4912653868 | 0.1754012798 |
| Mean | Std. Deviation | ||
| 5.8333333333 | 1.8859773512 |
Step 2 Control Chart
Step # 2 8 8 8 8 7 3 3 3 4 3 7 8 7 6 6 4 3 7 3 5 3 8 6 7 6 8 3 7 8 3 5 7 8 6 4 7 7 8 5 7 5 6 Mean 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333 333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 5.833333333333333 UCL 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 11.491265386827013 LCL 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359 0.17540127983965359
Days
Rework Step 2
| Rework Step #2 | Mean | UCL(6) | LCL(6) |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 0 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| 1 | 0.4047619048 | 1.895149222 | -1.0856254125 |
| Mean | Std. Deviation | ||
| 0.4047619048 | 0.4967957724 |
Step 3 Control Chart
Step # 3 6 3 3 6 6 5 6 5 3 6 3 3 4 5 6 5 4 5 3 3 3 6 3 3 3 6 6 3 5 6 3 5 3 6 6 3 5 5 3 6 5 5 Mean 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 UCL 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 LCL 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497
Hours
Step 3
| Step # 3 | Mean | UCL | LCL |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 4 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 4 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 3 | 4.5 | 8.3777036202 | 0.6222963798 |
| 6 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| 5 | 4.5 | 8.3777036202 | 0.6222963798 |
| Mean | Std. Deviation | ||
| 4.5 | 1.2925678734 |
Step 3 Control Chart
Step # 3 6 3 3 6 6 5 6 5 3 6 3 3 4 5 6 5 4 5 3 3 3 6 3 3 3 6 6 3 5 6 3 5 3 6 6 3 5 5 3 6 5 5 Mean 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 UCL 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 8.377703620166665 LCL 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497 0.62229637983333497
Hours
Step 4a
| Step # 4a | Mean | UCL | LCL | ||||
| 3 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 4 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 5 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 4 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 5 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 2 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 4 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 5 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 4 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 3 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 4 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 2 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 5 | 4.6666666667 | 9.9118735379 | 0 | Step 2 | |||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 2 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 5 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 4 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 3 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 5 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 2 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 2 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 3 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 5 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 3 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 7 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 2 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 6 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 4 | 4.6666666667 | 9.9118735379 | 0 | ||||
| 2 | 4.6666666667 | 9.9118735379 | 0 | ||||
| Mean | Std. Deviation | ||||||
| 4.6666666667 | 1.7484022904 |
Step 4a Control Chart
Step # 4a 3 4 5 7 6 4 5 6 2 4 5 4 3 6 4 7 2 6 6 5 7 6 2 6 7 7 7 5 4 3 5 2 2 3 5 3 7 7 2 6 4 2 Mean 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4. 666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 4.666666666666667 UCL 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.91187353 78921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 9.9118735378921698 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Hours
Step 4b
| Step # 4b | Mean | UCL | LCL | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | Step 2 | |||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 1 | 1.5 | 3.018182482 | -0.018182482 | ||||
| 2 | 1.5 | 3.018182482 | -0.018182482 | ||||
| Mean | Std. Deviation | ||||||
| 1.5 | 0.5060608273 |
Step 4b Control Chart
Step # 4b 2 2 2 2 1 2 1 1 1 1 1 1 2 1 1 2 2 1 1 2 2 1 2 1 1 1 2 2 2 1 1 1 2 1 2 1 2 2 2 2 1 2 Mean 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 UCL 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 3.0181824820424219 LCL -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2 -1.8182482042421899E-2
Hours
Step 5
| Step # 5 | Mean | UCL | LCL | ||||
| 28 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 36 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 28 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 29 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 40 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 34 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 27 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 28 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 34 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 26 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 21 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 26 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 20 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 26 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 23 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 25 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 25 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 34 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 24 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 39 | 29.2142857143 | 46.8263955013 | 11.6021759273 | Step 2 | |||
| 28 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 23 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 25 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 31 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 23 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 26 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 37 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 38 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 23 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 26 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 20 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 24 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 33 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 26 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 40 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 30 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 36 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 38 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 37 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 24 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 34 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| 32 | 29.2142857143 | 46.8263955013 | 11.6021759273 | ||||
| Mean | Std. Deviation | ||||||
| 29.2142857143 | 5.8707032623 |
Step 5 Control Chart
Step # 5 28 36 28 29 40 34 27 28 34 26 21 26 20 26 23 25 25 34 24 39 28 23 25 31 23 26 37 38 23 26 20 24 33 26 40 30 36 38 37 24 34 32 Mean 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 29.214285714285715 UCL 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 46.826395501299466 LCL 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965 11.602175927271965
Minuets
Step 5 Rework
| Rework Step #2 | Mean | UCL(6) | LCL(6) |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 0 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| 1 | 0.4523809524 | 1.9636625692 | -1.0589006645 |
| Mean | Std. Deviation | ||
| 0.4523809524 | 0.503760539 |
Step 6
| Step # 6 (Days) | Mean | UCL | LCL | ||||
| 2 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 2 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 2 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 2 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 3 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 4 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 4 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 4 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 3 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 4 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 3 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | Step 2 | |||
| 2 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 3 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 2 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 3 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 4 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 3 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 2 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 5 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 6 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| 3 | 4.3571428571 | 8.842310049 | -0.1280243347 | ||||
| Mean | Std. Deviation | ||||||
| 4.3571428571 | 1.4950557306 |
Step 6 Control Chart
Step # 6 (Days) 2 2 2 6 6 2 5 6 3 6 4 4 4 5 3 4 6 5 3 6 2 3 6 2 5 5 5 5 6 6 6 3 6 6 4 3 5 2 5 5 6 3 Mean 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 4.3571428571428568 UCL 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 8.8423100489737188 LCL -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0. 12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611 -0.12802433468800611
Days
Step 6 Delay
| Step # 6 Delay | Mean | UCL | LCL | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | Step 2 | |||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 3 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 0 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 2 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| 1 | 1.5476190476 | 4.6696995654 | -1.5744614702 | ||||
| Mean | Std. Deviation | ||||||
| 1.5476190476 | 1.0406935059 |
Step 6 Delay Control Chart
Step # 6 Delay 2 2 1 2 3 3 0 0 1 2 1 3 1 2 0 3 1 1 3 2 1 0 2 0 3 2 2 2 0 2 0 3 3 0 2 2 1 2 2 0 2 1 Mean 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 1.5476190476190477 UCL 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 4.6696995654119311 LCL -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173 836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836 -1.574461470173836
Days
Step 7
| Step # 7 | Mean | UCL | LCL | ||||
| 6 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 6 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 3 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | Step 2 | |||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 6 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 3 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 6 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 2 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 6 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 3 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 3 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 4 | 3.7857142857 | 8.1070816651 | 0 | ||||
| 5 | 3.7857142857 | 8.1070816651 | 0 | ||||
| Mean | Std. Deviation | ||||||
| 3.7857142857 | 1.4404557931 |
Step 7 Control Chart
Step # 7 6 2 5 4 6 5 5 5 2 5 2 2 4 5 3 2 2 2 2 5 4 2 5 5 6 3 6 4 4 2 4 2 2 2 6 5 3 4 4 3 4 5 Mean 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 3.7857142857142856 UCL 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 8.1070816651295736 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Hours
Historical Data - M6A13
| Historical Data (since phone manufacturing began) | Historical Phone Orders* | * # orders = # sales | |||||||||||||||
| Order Year (Calendar) | Average Step # 1 [hours] | Average Step # 2 [Days] | Average Step # 3 [Hours] | Average Step #4a [Hours] | Average Step #4b [Hours] | Average Step #5 [minutes] | Average Step#6 [Days] | Average Delay Time at Step # 6 [days] | Average Step #7 [Hours] | # Orders (Annual) | # Orders Phone A | # Orders Phone B | # Orders Phone C | # Orders Phone D | |||
| Year -7 | 2008 | 2 | 8 | 5 | 3 | 1 | 32 | 5 | 2 | 6 | 84 | 50 | 17 | 13 | 4 | ||
| Year -6 | 2009 | 5 | 7 | 3 | 3 | 1 | 36 | 2 | 2 | 4 | 126 | 76 | 25 | 19 | 6 | ||
| Year -5 | 2010 | 3 | 8 | 6 | 3 | 1 | 28 | 2 | 2 | 4 | 250 | 150 | 50 | 38 | 13 | ||
| Year -4 | 2011 | 6 | 6 | 22 | 4 | 2 | 27 | 3 | 1 | 4 | 275 | 138 | 69 | 55 | 14 | ||
| Year -3 | 2012 | 4 | 8 | 3 | 4 | 2 | 36 | 2 | 2 | 2 | 320 | 160 | 80 | 64 | 16 | ||
| Year -2 | 2013 | 2 | 7 | 6 | 7 | 2 | 27 | 2 | 3 | 3 | 335 | 134 | 117 | 67 | 17 | ||
| Year -1 | 2014 | 4 | 8 | 6 | 4 | 2 | 40 | 2 | 1 | 4 | 282 | 85 | 141 | 28 | 28 | ||
| Year 0 | 2015 | 3 | 5 | 6 | 3 | 3 | 29 | 3 | 2 | 4 | 246 | 25 | 25 | 148 | 49 | ||
| Mean | 3.625 | 7.125 | 7.125 | 3.875 | 1.75 | 31.875 | 2.625 | 1.875 | 3.875 | * # orders = # sales | |||||||
| Std.Deviation | 0.498 | 0.398 | 2.175 | 0.479 | 0.250 | 1.747 | 0.375 | 0.227 | 0.398 | ||||||||
| UCL | 5.118 | 8.319 | 13.650 | 5.313 | 2.500 | 37.115 | 3.750 | 2.555 | 5.069 | ||||||||
| LCL | 2.132 | 5.931 | 0.600 | 2.437 | 1.000 | 26.635 | 1.500 | 1.195 | 2.681 |
