quality tools

profileRami55
factors.xls
Home>Business & Finance homework help>Operations Management homework help>quality tools

Sheet1

X-bar X-Bar Chart X-Bar Chart X-bar s Chart s Chart s chart s chart Cp R chart R chart R chart R chart
Revise From R From s Revise LCL UCL Revise Revise Cp ? Revise Revise LCL UCL
n A A2 A3 c4 B3 B4 B5 B6 d2 d3 D1 D2 D3 D4
2 2.121 1.880 2.659 0.7979 0.000 3.267 0.000 2.606 1.128 0.853 0.000 3.686 0.000 3.267
3 1.732 1.023 1.954 0.8862 0.000 2.568 0.000 2.276 1.693 0.888 0.000 4.358 0.000 2.575
4 1.500 0.729 1.628 0.9213 0.000 2.266 0.000 2.088 2.059 0.880 0.000 4.698 0.000 2.282
5 1.342 0.577 1.427 0.9400 0.000 2.089 0.000 1.964 2.326 0.864 0.000 4.918 0.000 2.114
6 1.225 0.483 1.287 0.9515 0.030 1.970 0.029 1.874 2.534 0.848 0.000 5.079 0.000 2.004
7 1.134 0.419 1.182 0.9594 0.118 1.882 0.113 1.806 2.704 0.833 0.205 5.204 0.076 1.924
8 1.061 0.373 1.099 0.9650 0.185 1.815 0.179 1.751 2.847 0.820 0.388 5.307 0.136 1.864
9 1.000 0.337 1.032 0.9693 0.239 1.761 0.232 1.707 2.970 0.808 0.547 5.394 0.184 1.816
10 0.949 0.308 0.975 0.9727 0.284 1.716 0.276 1.669 3.078 0.797 0.686 5.469 0.223 1.777
11 0.905 0.285 0.927 0.9754 0.321 1.679 0.313 1.637 3.173 0.787 0.811 5.535 0.256 1.744
12 0.866 0.266 0.886 0.9776 0.354 1.646 0.346 1.610 3.258 0.778 0.923 5.594 0.283 1.717
13 0.832 0.249 0.850 0.9794 0.382 1.618 0.374 1.585 3.336 0.770 1.025 5.647 0.307 1.693
14 0.802 0.235 0.817 0.9810 0.406 1.594 0.399 1.563 3.407 0.763 1.118 5.696 0.328 1.672
15 0.775 0.223 0.789 0.9823 0.428 1.572 0.421 1.544 3.472 0.756 1.203 5.740 0.347 1.653
16 0.750 0.212 0.763 0.9835 0.448 1.552 0.440 1.526 3.532 0.750 1.282 5.782 0.363 1.637
17 0.728 0.203 0.739 0.9845 0.466 1.534 0.458 1.511 3.588 0.744 1.356 5.820 0.378 1.622
18 0.707 0.194 0.718 0.9854 0.482 1.518 0.475 1.496 3.640 0.739 1.424 5.856 0.391 1.609
19 0.688 0.187 0.698 0.9862 0.497 1.503 0.490 1.483 3.689 0.733 1.489 5.889 0.404 1.596
20 0.671 0.180 0.680 0.9869 0.510 1.490 0.504 1.470 3.735 0.729 1.549 5.921 0.415 1.585
21 0.655 0.173 0.663 0.9876 0.523 1.477 0.516 1.459 3.778 0.724 1.606 5.951 0.425 1.575
22 0.640 0.167 0.647 0.9882 0.534 1.466 0.528 1.448 3.819 0.720 1.660 5.979 0.435 1.565
23 0.626 0.162 0.633 0.9887 0.545 1.455 0.539 1.438 3.858 0.716 1.711 6.006 0.443 1.557
24 0.612 0.157 0.619 0.9892 0.555 1.445 0.549 1.429 3.895 0.712 1.759 6.032 0.452 1.548
25 0.600 0.153 0.606 0.9896 0.565 1.435 0.559 1.420 3.931 0.708 1.805 6.056 0.459 1.541

Sheet2

Sheet3