Excel Formulas:
F3 =AVERAGE(B3:E3) copy to F3:F11
I3 =AVERAGE(B3:E11)
I4 =STDEV(B3:E11)
I5 =I4/4^0.5
I7 =I3+2*I5
I8 =I3-2*I5
1. Value of UCL = 10.266
2. Value of LCL = 9.908
3. The process is in statistical control, as all the values of X? are within the control limits.
4. Given that mean of sample # 10 is 11, which is outside the UCL . Therefore, the process would not be in statistical control.
Where X-7nand z#2 Item Sample # 1 2 3 4 1 10.20 9.97 10.17 9.91 2...
A cereal manufacturer weighs cereal boxes using an automatic scale. The target weight is to put 10 ounces of cereal in each box. Fifteen samples of three boxes each have been weighed for quality control purposes. The fill weight for each box is shown below: Sample 1 2 3 1 10.01 9.90 10.03 2 9.87 10.20 10.15 3 10.08 9.89 9.76 4 10.17 10.01 9.83 5 10.21 10.13 10.04 6 0.16 10.02 ...
Sampling Hour Shift Sample 1 Sample 2 Sample 3 Sample 4 6:00 AM 1 10.94 10.74 11.06 10.66 7:00 AM 1 10.66 10.6 10.8 10.68 8:00 AM 1 10.68 10.6 10.54 10.36 9:00 AM 1 10.03 10.72 10.74 10.7 10:00 AM 1 10.7 10.62 11.04 10.58 11:00 AM 1 10.38 10.42 10.66 10.4 12:00 PM 1 10.46 10.6 10.26 10.02 1:00 PM 1 10.66 10.6 10.22 10.68 2:00 PM 2 10.5 10.78 10.68 10.58 3:00 PM 2 10.58 10.48 10.58...