xbarr_ - X-bar and R-Chart This spreadsheet is designed for...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
X-bar and R-Chart 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) 30 Process Capability Calculations Six sigma 0.6 Sample size (2 - 10) 4 Upper specification Cp Lower specification Cpu Grand Average 0.68 A2 D3 D4 d2 Cpl Average Range 0.2 0.73 0 2.28 2.06 Cpk DATA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 1 4.92 4.26 4.94 4.29 2 4.65 5.54 5 5.42 3 5.77 5.26 4.76 4.79 4 6.25 4.88 5.66 4.44 5 5.27 5.41 6.02 4.91 6 5.22 5.38 5.08 4.65 7 5.47 4.68 4.56 4.7 8 5.71 4.54 4.17 4.87 9 5.24 5.58 4.72 5.41 10 4.42 5.18 4.79 4.73 11 5.14 4.26 4.71 5.48 12 4.92 5.78 5.5 5.05 13 5.79 3.83 4.3 4.78 14 4.92 4.8 4.75 5.59 15 5.68 5.74 4.65 5.2 16 5.43 4.81 5.27 4.96 17 4.79 6.04 4.47 5.18 18 4.43 5.08 3.69 6.43 19 6.35 5.95 6.29 5.89 20 5.03 4.66 5.25 4.46 21 6.32 6.09 5.57 5.91
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

xbarr_ - X-bar and R-Chart This spreadsheet is designed for...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online