Discuss the following:
StatPro [or other excel statsitics program] generates new sheets for each problem and deletes previous sheets with the same name. If you want to keep a sheet for your solution, then rename it immediately by prefixing the problem number. You may need suffix numbers to keep the names unique.
FACTS:
It consist of 25 subsamples of 6 observations each on the fill weights of cans of paint. The ideal weight of these paint cans is 20 pounds.
Q: (a) Using Excel - Generate and interpret ¯X and R charts for the given data. (i) Which control limits do you believe are most appropriate? Explain. (ii) Does this filing process appear to be in control now? (iii) Does this filing process appear to be in control now?
(b) Are there any other indications that the given process may be out of control now? If so, explain.
(c) What advise would you give to the operators of the filing process based on your analysis of the latest sample information?
| Fill Weights of Randomly Selected Cans of Paint (in pounds) |
|
|
|
|
|
|
|
|
|
| Subsample |
Value1 |
Value2 |
Value3 |
Value4 |
Value5 |
Value6 |
| 1 |
19.9930 |
20.0113 |
20.0144 |
20.0240 |
20.0010 |
19.9917 |
| 2 |
20.0445 |
19.9907 |
19.9946 |
19.9903 |
19.9999 |
19.9751 |
| 3 |
20.0360 |
19.9431 |
20.0394 |
19.9828 |
19.9923 |
20.0110 |
| 4 |
20.0097 |
19.9749 |
20.0071 |
19.9950 |
20.0105 |
19.9978 |
| 5 |
19.9916 |
20.0184 |
19.9947 |
20.0037 |
20.0302 |
20.0153 |
| 6 |
20.0394 |
19.9907 |
19.9713 |
19.9861 |
20.0005 |
19.9780 |
| 7 |
20.0144 |
19.9925 |
19.9930 |
19.9892 |
20.0247 |
20.0318 |
| 8 |
19.9970 |
19.9877 |
20.0016 |
19.9976 |
20.0013 |
19.9985 |
| 9 |
20.0238 |
20.0170 |
20.0109 |
20.0020 |
19.9866 |
20.0027 |
| 10 |
19.9829 |
20.0296 |
20.0288 |
19.9610 |
20.0220 |
20.0178 |
| 11 |
20.0299 |
20.0523 |
20.0649 |
20.0499 |
20.0313 |
20.0308 |
| 12 |
20.0873 |
20.0467 |
20.0693 |
20.0788 |
20.0573 |
20.0242 |
| 13 |
20.0628 |
20.0048 |
20.0639 |
20.0340 |
20.0790 |
20.0587 |
| 14 |
20.0519 |
20.0629 |
20.0523 |
20.0540 |
20.0358 |
20.0531 |
| 15 |
20.0599 |
20.0381 |
20.0610 |
20.0755 |
20.0624 |
20.0071 |
| 16 |
20.0372 |
20.0775 |
20.0285 |
20.0816 |
20.0563 |
20.0456 |
| 17 |
20.0537 |
20.0456 |
20.0548 |
20.0528 |
20.0431 |
20.0822 |
| 18 |
20.0773 |
20.0785 |
20.0498 |
20.0473 |
20.0780 |
20.0732 |
| 19 |
20.1107 |
20.1152 |
20.0567 |
20.0811 |
20.0334 |
20.0803 |
| 20 |
20.0933 |
20.0501 |
20.0859 |
20.1114 |
20.1109 |
20.0363 |
| 21 |
20.1062 |
20.0490 |
20.0855 |
20.0891 |
20.0772 |
20.0667 |
| 22 |
20.0870 |
20.0607 |
20.0290 |
20.0957 |
20.0992 |
20.0865 |
| 23 |
20.0854 |
20.0289 |
20.0313 |
20.0632 |
20.0889 |
20.0853 |
| 24 |
20.0957 |
20.0590 |
20.0683 |
20.0859 |
20.1142 |
20.0732 |
| 25 |
20.1108 |
20.0543 |
20.0766 |
20.0711 |
20.0616 |
20.0562 |