Management Chapter 8 Homework Enter The Number Samples Cell And The

Unlock access to all the studying documents.

View Full Document

Problem 8-09B

Babbage Chips

Note: Formulas were altered to allow calculation of control limits

based on the first 30 samples and plotting of 50 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) 30 Process Capability Calculations Six sigma 6.58

5Upper specification

Lower specification

Grand Average A2 D3 D4 d2

Average Range 0.577 0 2.114 2.326

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

17.95 6.34 8.15 10.12 8.42 9.79 8.47 8.68 10.64 8.99 9.22 8.07 10.69 10.80 9.94 9.52 10.09 8.23 8.86 9.00 9.73 6.91 9.05 8.41 8.71 10.17 9.91 9.82 9.18 7.08 8.76 8.75 9.24 9.55 9.28 8.24 7.69 8.07 8.90 10.40 9.74 9.80 8.85 9.21 10.14 7.32 8.46 7.96 8.60 7.71

Average 9.29 9.01 9.25 8.61 9.00 10.43 8.32 8.33 9.58 9.37 8.62 9.27 10.06 9.50 9.98 9.07 9.48 8.70 9.24 8.85 9.23 8.66 8.31 9.70 8.93 9.62 9.55 9.31 9.74 8.06 8.35 8.09 8.87 8.26 9.43 8.53 9.17 8.18 8.59 8.99 9.13 9.44 8.56 9.02 9.97 8.92 8.66 9.16 8.78 9.12

LCLx-bar 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70 7.70

Center 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17 9.17

UCLx-bar 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64 10.64

Sample Number

DATA 1 2 3 4 5 6 7 8 9 10

1 7.95 6.34 8.15 10.12 8.42 9.79 8.47 8.68 10.64 8.99

2 11.20 7.97 10.60 7.46 7.04 11.62 9.38 8.56 9.38 9.97

3 8.16 10.68 8.66 10.07 9.83 7.73 6.91 8.28 9.92 10.04

4 10.04 8.88 9.99 8.07 11.00 11.45 9.00 8.72 9.08 9.77

5 9.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

1 9.22 8.07 10.69 10.80 9.94 9.52 10.09 8.23 8.86 9.00

2 9.41 9.34 9.75 7.99 10.63 8.53 7.80 8.42 8.67 9.21

3 9.19 10.03 10.55 9.06 9.34 9.68 9.28 8.47 10.76 9.04

4 7.58 8.63 8.36 11.27 9.74 8.13 9.01 9.61 9.33 7.33

5 7.73 10.27 10.94 8.37 10.27 9.47 11.23 8.76 8.58 9.67

Cpu

Cpl

Cpk

X-bar and R-Chart

Sample size (2 – 10)

9.170

2.543

6.00

6.50

7.00

10.00

10.50

11.00

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 51

Sample number

Prob. 8-09B X-bar Chart Averages

Lower control limit

Upper control limit

Center line

4.00

5.00