Morelia Mortgage Co. – with additional data
NOTE THE MODIFICATIONS TO CELLS C12 AND C13 AS EXPLAINED IN THE TEXT SIDEBAR
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) 28 Process Capability Calculations Six sigma 21.02
5Upper specification 20.5 0.476
Lower specification 10.5 0.473
Grand Average A2 D3 D4 d2 0.479
Average Range 0.577 0 2.114 2.326 0.473
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
117.81 11.91 16.15 17.37 11.18 13.01 14.02 15.74 16.60 12.41 13.88 12.90 17.68 21.29 17.64 20.90 17.43 23.59 15.58 19.17 17.26 14.27 13.55 15.35 13.82 17.19 14.01 12.32 16.60 12.29 17.88 19.17 17.41 12.41 19.76 19.91 13.31 14.02 17.91 15.86 19.00 16.51 10.40 21.90 14.04 17.05 19.26 15.93
219.93 15.86 13.53 9.42 18.04 11.87 14.51 18.08 12.29 19.76 16.76 11.94 12.39 13.86 22.39 14.04 16.91 14.26 13.54 16.20 15.56 13.83 18.32 6.81 10.71 16.96 24.70 15.52 12.41 19.76 19.91 13.31 21.96 13.88 16.76 15.53 14.49 14.51 16.15 13.53 12.87 14.37 14.16 22.43 16.91 17.51 6.04 10.11
319.12 19.00 12.87 14.74 14.96 15.55 15.50 13.73 17.88 19.91 15.53 16.27 14.13 16.56 14.10 17.05 14.51 14.47 11.25 13.45 13.62 23.52 18.64 9.95 13.12 22.56 18.58 16.11 13.88 16.76 15.53 14.49 18.42 12.90 11.94 16.27 13.41 15.50 17.37 9.42 14.74 20.53 18.80 23.59 14.26 14.47 19.10 13.88
415.39 16.51 14.37 20.53 19.42 13.09 14.14 21.82 19.17 13.31 14.49 13.41 14.00 20.93 15.08 19.26 6.04 19.10 13.71 18.18 10.83 10.23 12.83 14.09 15.33 11.53 19.12 17.93 12.90 11.94 16.27 13.41 20.79 17.68 12.39 14.13 14.00 14.14 15.18 18.04 14.96 19.42 15.69 19.58 13.54 16.25 13.71 17.33
59.34 10.40 14.16 18.80 15.69 18.26 15.24 12.13 17.41 21.96 18.42 20.79 5.62 20.19 16.28 15.93 10.11 13.88 17.33 15.62 11.09 14.99 12.81 14.40 17.30 17.64 10.64 15.49 17.68 12.39 14.13 14.00 5.62 21.29 13.86 16.56 20.93 15.24 16.01 11.87 15.55 13.09 18.26 18.56 14.10 17.05 14.51 14.47
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
5 0.577 0 2.114 2.326 1.427 0 2.089
X-bar and R-Chart
Sample size (2 – 10)
15.532
8.147
Cp
Cpu
Cpl
Cpk
Control Chart Factors
18
20
22
Sample number
X-bar Chart with additional data
Averages
Lower control limit
Upper control limit
Center line
0
10
12
14
16
18
20
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49
Sample number
R-Chart with additional data
Ranges
Lower control limit
Upper control limit
Center line