El Grande Toro Restaurante
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) 40 Process Capability Calculations Six sigma 1.883
5Upper specification 3.00 1.59
Lower specification 0.00 1.62
6
7
8
9
10
Average 1.49 1.36 1.70 1.36 1.33 1.49 1.30 1.54 1.42 1.20 1.54 1.71 1.48 1.41 1.36 1.76 1.53 1.51 1.40 1.44 1.76 1.46 1.47 1.47 1.72 1.19 1.54 1.33 1.81 1.63 1.24 1.47 1.61 1.25 1.37 1.47 1.62 1.75 1.38 1.19 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
LCLx-bar
1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09
Center 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48 1.48
UCLx-bar
1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87 1.87
X-bar and s-Chart
Sample size (2 – 10)
Cp
Cpu
Cpk