Fujiyama Electronics
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 (some rescaling may be needed). Specification limits may be entered in cells N7 and N8 for process capability.
Number of samples (<= 50) 30 Process Capability Calculations Six sigma 2.9
4Upper specification
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
14.92 4.65 5.77 6.25 5.27 5.22 5.47 5.71 5.24 4.42 5.14 4.92 5.79 4.92 5.68 5.43 4.79 5.03 4.30 6.07 5.11 4.50 4.91 4.65 4.70 5.87 4.41 4.92 5.68 5.43
5
6
7
8
9
10
Average 4.60 5.15 5.15 5.31 5.40 5.09 4.85 4.82 5.24 4.78 4.90 5.32 4.68 5.01 5.32 5.12 5.12 4.85 4.60 5.39 5.14 4.74 5.12 4.87 5.14 5.51 4.81 5.03 5.03 4.85 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
LCLx-bar 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27 4.27
Center 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03 5.03
UCLx-bar
5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79 5.79
DO NOT MODIFY THIS TABLE
nA2 D3 D4 d2 A3 B3 B4
21.880 0.000 3.267 1.128 2.659 0.000 3.267
31.023 0.000 2.574 1.693 1.954 0.000 2.568
40.729 0.000 2.282 2.059 1.628 0.000 2.266
X-bar and s-Chart
Sample size (2 – 10)
Cp
Control Chart Factors
4.00
5.80
6.00
1357911 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49
Sample number
Prob. 8-34 X-bar Chart
Averages
Lower control limit
Upper control limit
Center line
1.00
1.20
Sample number
Prob. 8-34 s-Chart
Standard Deviations
Lower control limit
Upper control limit
Center line