Rapid Check Kiters
Calculation of control limits with initial 20 samples.
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)
20 Process Capability Calculations Six sigma 0.27
4Upper specification 1.21 1.03
DATA 12345678910 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
11.01 1.15 1.08 0.98 1.13 1.06 1.03 1.08 1.13 1.16 1.08 1.11 1.09 1.05 1.07 1.05 1.03 1.01 1.08 1.09
21.03 1.05 1.14 1.08 1.05 1.10 1.04 1.11 1.11 1.06 1.00 1.07 1.13 0.95 1.04 1.07 1.08 1.08 1.07 1.08
31.07 1.08 1.06 0.97 1.14 1.16 1.13 1.14 1.06 1.07 0.99 1.05 1.09 1.15 1.10 1.06 1.04 1.05 1.11 1.02
41.10 1.01 1.10 1.04 1.01 1.02 1.05 1.07 1.05 1.02 1.03 1.05 1.14 1.08 1.06 1.04 1.08 1.04 1.06 1.15
5
6
7
8
9
10
Average 1.05 1.07 1.10 1.02 1.08 1.09 1.06 1.10 1.09 1.08 1.03 1.07 1.11 1.06 1.07 1.06 1.06 1.05 1.08 1.09
LCLx-bar
1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Center 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07
UCLx-bar
LCLrange
UCLrange
1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14
Sample Number
DATA
1 2 3 4 5 6 7 8 9 10
17.95 6.34 8.15 10.12 8.42 9.79 8.47 8.68 10.64 8.99
211.20 7.97 10.60 7.46 7.04 11.62 9.38 8.56 9.38 9.97
38.16 10.68 8.66 10.07 9.83 7.73 6.91 8.28 9.92 10.04
410.04 8.88 9.99 8.07 11.00 11.45 9.00 8.72 9.08 9.77
59.10 11.18 8.86 7.31 8.70 11.56 7.84 7.42 8.88 8.11
11 12 13 14 15 16 17 18 19 20
19.22 8.07 10.69 10.80 9.94 9.52 10.09 8.23 8.86 9.00
29.41 9.34 9.75 7.99 10.63 8.53 7.80 8.42 8.67 9.21
39.19 10.03 10.55 9.06 9.34 9.68 9.28 8.47 10.76 9.04
47.58 8.63 8.36 11.27 9.74 8.13 9.01 9.61 9.33 7.33
57.73 10.27 10.94 8.37 10.27 9.47 11.23 8.76 8.58 9.67
X-bar and R-Chart
Sample size (2 – 10)
Cp
0.98
1.14
1357911 13 15 17 19 21
Sample number
Prob. 8-30A X-bar Chart
Averages
Lower control limit
Upper control limit
Center line
0.20
0.25
Sample number
Prob. 8-30 A R-Chart
Ranges
Lower control limit
Upper control limit
Center line
Rapid Check Kiters From the control chart worksheet:
min 0.95 Bin Frequency
max 1.16 0.90 0 Process Capability Calculations Six sigma 0.27
a) Initial data 0.95 1 Upper specification 1.205 Cp 1.03
Sample Bins 1.00 4 Lower specification 0.925 Cpu 0.99
1 1.01 1.03 1.07 1.10 0.90 1.05 26 Cpl 1.06
2 1.15 1.05 1.08 1.01 0.95 1.10 32 Cpk 0.99
8 1.08 1.11 1.14 1.07
9 1.13 1.11 1.06 1.05
10 1.16 1.06 1.07 1.02
11 1.08 1.00 0.99 1.03
12 1.11 1.07 1.05 1.05
13 1.09 1.13 1.09 1.14
14 1.05 0.95 1.15 1.08
25
30
35
Histogram
Check Kiters, Inc.
Note: Formulas were altered to allow calculation of control limits based on the first 20 samples and plotting of 40 samples. Process capability was also calculated using the first 20 samples.
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)
20 Process Capability Calculations Six sigma 0.273
4Upper specification 1.205 1.026
21.03 1.05 1.14 1.08 1.05 1.10 1.04 1.11 1.11 1.06 1.00 1.07 1.13 0.95 1.04 1.07 1.08 1.08 1.07 1.08 1.06 1.08 1.13 1.07 1.12 1.06 1.09 1.12 1.03 1.05 1.04 1.00 1.12 1.05 1.03 1.01 1.13 1.18 1.05
31.07 1.08 1.06 0.97 1.14 1.16 1.13 1.14 1.06 1.07 0.99 1.05 1.09 1.15 1.10 1.06 1.04 1.05 1.11 1.02 1.17 1.09 1.12 1.03 1.10 1.00 1.04 1.08 1.02 1.06 1.07 1.05 1.08 0.98 1.01 1.03 1.04 1.18 1.14
41.10 1.01 1.10 1.04 1.01 1.02 1.05 1.07 1.05 1.02 1.03 1.05 1.14 1.08 1.06 1.04 1.08 1.04 1.06 1.15 1.09 1.00 1.03 1.09 1.05 1.10 1.08 1.02 0.95 1.08 1.00 1.02 1.09 1.11 1.10 1.05 1.04 1.04 1.17
5
6
7
8
9
10
Average 1.05 1.07 1.10 1.02 1.08 1.09 1.06 1.10 1.09 1.08 1.03 1.07 1.11 1.06 1.07 1.06 1.06 1.05 1.08 1.09 1.11 1.09 1.10 1.08 1.09 1.06 1.08 1.08 1.05 1.06 1.04 1.04 1.09 1.04 1.06 1.05 1.07 1.11 1.09
LCLx-bar 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Center 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07
UCLx-bar 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14
Center 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09
Sample Number
DATA 12345678
1 1.01 1.15 1.08 0.98 1.13 1.06 1.03 1.08
2 1.03 1.05 1.14 1.08 1.05 1.10 1.04 1.11
3 1.07 1.08 1.06 0.97 1.14 1.16 1.13 1.14
4 1.10 1.01 1.10 1.04 1.01 1.02 1.05 1.07
910 11 12 13 14 15 16
1 1.13 1.16 1.08 1.11 1.09 1.05 1.07 1.05
2 1.11 1.06 1.00 1.07 1.13 0.95 1.04 1.07
3 1.06 1.07 0.99 1.05 1.09 1.15 1.10 1.06
4 1.05 1.02 1.03 1.05 1.14 1.08 1.06 1.04
37 38 39 40
1 1.07 1.04 1.01 1.05
2 1.13 1.18 1.05 1.02
3 1.04 1.18 1.14 1.08
4 1.04 1.04 1.17 1.06
X-bar and R-Chart
Sample size (2 – 10)
Cp
Grand Average A2 D3 D4 1.058
11.01 1.15 1.08 0.98 1.13 1.06 1.03 1.08 1.13 1.16 1.08 1.11 1.09 1.05 1.07 1.05 1.03 1.01 1.08 1.09 1.11 1.17 1.11 1.12 1.09 1.09 1.09 1.08 1.19 1.05 1.05 1.10 1.08 1.03 1.09 1.12 1.07 1.04 1.01
0.98
1
1.02
1.12
1.14
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41
Sample Number
Prob. 8-30c X-bar Chart
Averages
Lower control limit
Upper control limit
Center line
0.15
0.2
0.25
0.3
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41
Sample number
Prob. 8-30c R-Chart
Ranges
Lower control limit
Upper control limit
Center line