Problem 8-08-Instructor Reserve
Metropole Hospital Waiting Room
This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells.
Enter the number of samples in cell E6 and the sample size in cell E7. Then enter your data in the grid below.
Click on sheet tabs for a display of the control charts. Specification limits may be entered in cells N7 and N8 for process capability.
Number of samples (<= 50) 50 Process Capability Calculations Six sigma 5.252
6
Upper specification
Lower specification
Grand Average A2 D3 D4 d2
Average Range 0.483 0 2.004 2.534
DATA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
123.97 22.11 23.32 21.88 23.06 23.53 22.27 20.80 23.00 22.15 23.65 22.33 21.99 23.72 22.17 22.75 23.13 22.48 22.63 22.36 22.22 22.51 23.32 21.44 21.82 22.99 23.05 22.87 22.42 22.54 22.47 23.63 21.67 22.72 23.71 22.07 22.58 22.04 19.90 22.60 23.60 22.86 22.00 23.75 22.94 21.60 22.82 20.57 22.44 23.64
222.41 21.45 23.21 21.19 22.13 23.58 21.47 23.52 21.29 22.80 24.60 23.85 22.97 24.13 21.45 22.55 20.97 22.68 21.96 22.66 23.13 22.00 22.61 23.57 22.34 22.00 22.95 21.85 22.52 23.60 23.07 21.45 22.68 23.07 22.42 22.72 22.13 22.59 23.66 23.39 23.20 21.94 21.91 22.58 22.88 22.34 23.35 21.74 24.31 23.67
322.80 21.63 22.76 23.09 23.63 24.29 20.51 21.89 23.59 21.91 23.17 23.50 21.90 22.02 22.46 22.03 24.19 24.61 21.59 22.75 23.69 23.83 22.19 22.28 23.80 21.63 21.98 21.94 21.68 23.38 22.70 23.84 23.48 23.27 22.34 21.74 22.96 23.18 24.57 22.22 22.15 23.65 22.33 21.99 23.72 22.17 22.75 23.13 22.48 22.63
423.48 24.34 21.04 21.55 21.22 23.67 22.19 23.36 22.02 21.32 22.18 23.16 21.02 22.87 23.60 22.86 22.00 23.75 22.94 21.60 22.82 20.57 22.44 23.64 23.59 22.66 22.50 23.61 21.33 23.05 22.51 21.90 22.70 22.50 21.61 22.10 23.12 22.35 21.85 22.43 22.80 24.60 23.85 22.97 24.13 21.45 22.55 20.97 22.68 21.96
10
Average 22.91 22.42 22.52 21.79 22.51 23.64 21.77 22.22 22.40 22.27 23.04 22.94 22.33 22.92 22.46 22.43 22.35 23.21 22.58 22.27 22.87 22.19 22.82 23.13 22.99 22.28 22.68 22.58 22.21 22.82 22.80 22.90 22.40 22.50 22.62 22.24 22.87 22.90 22.48 22.71 22.52 23.13 22.43 22.65 22.94 22.11 22.87 22.41 23.12 22.63
LCLx-bar 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56 21.56
Center 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61 22.61
UCLx-bar 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67 23.67
DO NOT MODIFY THIS TABLE
nA2 D3 D4 d2 A3 B3 B4
2 1.88 0 3.267 1.128 2.659 0 3.267
3 1.023 0 2.574 1.693 1.954 0 2.568
4 0.729 0 2.282 2.059 1.628 0 2.266
Cp
Cpu
Cpl
Cpk
Control Chart Factors
X-bar and R-Chart
Sample size (2 – 10)
22.615
2.192
23.50
24.00
Sample number
Prob. 8-08 X-bar Chart
Averages
Lower control limit
Upper control limit
Center line
2.50
3.00
3.50
4.00
4.50
5.00
Prob. 8-08 R-Chart
Ranges
Lower control limit
Upper control limit
Center line