Statistical Analysis 10 08 06

This workbook will check a process statistically and with specified limits.

The Set-Up sheet is used to: Select the desired statistical parameters from the drop down boxes. Insert the appropriate chart and column headings. Enter the known specified limits. The Report sheet is used to: Document all aspects of the test. The Data sheet is used to: Enter up to fifty samples of collected measurements for each of the five columns. The appropriate "K" factor will be located and used in the statistical calculations. The chart sheets: Automatically generate charts from the entered data. If desired, you can manually scale the chart axis. The Cp Cpk Cpm sheet: This will be calculated when specified limits are entered on the Set-Up sheet.

Statistical Analysis Workbook Set-Up Select Number Of Standard Deviations

Select One or Two Sided

Select % Confidence / % Population

Company Name: From: Date: Test Title: BLUE text can be altered and the change will be reflected on the appropriate chart or column. Measurement 1

Measurement 2

Measurement 3

Measurement 4

Measurement 5

USL Target LSL Enter the desired labels and headings for the charts below. Heading for Chart 1 Chart 1 Y

Chart 3 Y

Chart 5 Y

Chart 1

Chart 2 Y

Chart 2

Chart 1 X

Chart 2 X

Heading for Chart 3

Heading for Chart 4

Chart 3

Chart 4 Y

Chart 4

Chart 3 X

Chart 4 X

Heading for Chart 5

Comparison Chart Heading

Chart 5

Comparison Y Comparison Chart

Chart 5 X

File Name: 5540569.xls

Heading for Chart 2

Comparison X

Sheet Name: Set_Up

Printed on: 09/04/2008 at 17:13:41

Statistical Analysis Report

To: From: Date: Subject:

PURPOSE:

MATERIALS/EQUIPMENT:

TEST PARAMETERS:

Page 3 of 15

PROCEDURE:

RESULTS:

Page 4 of 15

CONCLUSION/DISCUSSION:

Page 5 of 15

File Name: 5540569.xls

Sample # 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 38 40 41 42 43 44 45 46 47 48 49 50

Measurement 1

Measurement 2

Measurement 3

Measurement 4

Measurement 5

Comments

COUNT UCL LCL

MEAN MAX MEDIAN MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

Sheet Name: Data

UCL = Statistical Upper Control Limit LCL = Statistical Lower Control Limit STDEV = Standard Deviation CV = Coefficient of Variation

Printed on: 09/04/2008 at 17:13:42

Heading for Chart 1 2.5 0 -2.5

Chart 1 Y

-5 -7.5 -10 -12.5 -15 -17.5 -20 Row 1 Chart 1 X Column A

✘ DATA 1 ✘ MEAN 1 ✘ UCL 1 ✘ LCL 1 A checked box above indicates the information that will be included on the chart.

Measurement 1 COUNT UCL 1 LCL 1 MEAN 1 MEDIAN MAX MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

File Name: 5540569.xls

Sheet Name: Chart 1

Printed on: 09/04/2008 at 17:13:42

Heading for Chart 2 2.5 0 -2.5

Chart 2 Y

-5 -7.5 -10 -12.5 -15 -17.5 -20 Row 1 Chart 2 X Column A

✘ DATA 2 ✘ UCL 2 ✘ MEAN 2 ✘ LCL 2 A checked box above indicates the information that will be included on the chart.

Measurement 2 COUNT UCL 2 LCL 2 MEAN 2 MEDIAN MAX MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

File Name: 5540569.xls

Sheet Name: Chart 2

Printed on: 09/04/2008 at 17:13:43

Heading for Chart 3 2.5 0 -2.5

Chart 3 Y

-5 -7.5 -10 -12.5 -15 -17.5 -20 Row 1 Chart 3 X Column A

✘ DATA 3 ✘ MEAN 3 ✘ LCL 3 ✘ UCL 3 A checked box above indicates the information that will be included on the chart.

Measurement 3 COUNT UCL 3 LCL 3 MEAN 3 MEDIAN MAX MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

File Name: 5540569.xls

Sheet Name: Chart 3

Printed on: 09/04/2008 at 17:13:44

Heading for Chart 4 2.5 0 -2.5

Chart 4 Y

-5 -7.5 -10 -12.5 -15 -17.5 -20 Row 1 Chart 4 X Column A

✘ DATA 4 ✘ UCL 4 ✘ MEAN 4 ✘ LCL 4 A checked box above indicates the information that will be included on the chart.

Measurement 4 COUNT UCL 4 LCL 4 MEAN 4 MEDIAN MAX MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

File Name: 5540569.xls

Sheet Name: Chart 4

Printed on: 09/04/2008 at 17:13:45

Heading for Chart 5 2.5 0 -2.5

Chart 5 Y

-5 -7.5 -10 -12.5 -15 -17.5 -20 Row 1 Chart 5 X Column A

✘

DATA 5

✘

UCL 5

✘

MEAN 5

✘

LCL 5

A checked box above indicates the information that will be included on the chart. Measurement 5 COUNT UCL 5 LCL 5 MEAN 5 MEDIAN MAX MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

File Name: 5540569.xls

Sheet Name: Chart 5

Printed on: 09/04/2008 at 17:13:45

Heading for Chart 1

Heading for Chart 2

2.5

2.5

0

0

-2.5

-2.5 -5 Chart 2 Y

Chart 1 Y

-5 -7.5 -10 -12.5

-7.5 -10 -12.5

-15

-15

-17.5

-17.5

-20 Row 1

-20 Row 1 Chart 1 X

Chart 2 X

Column A

✘

DATA 1

✘

UCL 1

✘

MEAN 1

Column A

✘

LCL 1

✘

DATA 2

✘

Heading for Chart 3

✘

✘

LCL 2

✘

LCL 4

2.5

0

0

-2

-2.5

-4

-8 Column A

-10

Chart 4 Y

-5

-6

-7.5 -10 -12.5

-12

-15

-14

-17.5

-16

-20 Row 1

-18 -20 Row 1

Chart 4 X Column A

Chart 3 X

✘

DATA 3

✘

UCL 3

✘

MEAN 3

✘

LCL 3

Heading for Chart 5

✘

DATA 4

✘

UCL 4

✘

MEAN 4

COUNT UCL LCL MEAN MEDIAN MAX MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

2.5 0 -2.5 -5 Chart 5 Y

MEAN 2

Heading for Chart 4

2

Chart 3 Y

UCL 2

-7.5 -10 -12.5 -15 -17.5 -20 Row 1 Chart 5 X Column A

✘

DATA 5

✘

UCL 5

✘

MEAN 5

✘

LCL 5 A checked box above indicates the information that will be included on the chart.

File Name: 5540569.xls

Sheet Name: All Charts

Printed on: 09/04/2008 at 17:13:46

File Name: 5540569.xls

Comparison Chart Heading 2 0 -2 -4 Comparison Y

-6 -8 -10 -12 -14 -16 -18 -20 Row 1 Comparison X Column A ✘

DATA 1

✘

DATA 2

✘

DATA 3

✘

DATA 4

✘

DATA 5

✘

UCL 1

✘

UCL 2

✘

UCL 3

✘

UCL 4

✘

UCL 5

✘

MEAN 1

✘

MEAN 2

✘

MEAN 3

✘

MEAN 4

✘

MEAN 5

✘

✘ LCL 2 ✘ LCL 4 ✘ LCL 3 ✘ LCL 5 LCL 1 A checked box above indicates the information that will be included on the chart.

COUNT UCL LCL MEAN MEDIAN MAX MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

Sheet Name: Comparison Chart

Printed on: 09/04/2008 at 17:13:47

File Name: 5540569.xls

1

1 0.5 0 -0.5 -1 -1.5

0.95

-2 -2.5 -3

0.85

0.9

0.8

-3.5 -4 -4.5

0.75

-5 -5.5 -6 -6.5

0.7 0.65

-7 -7.5 -8

0.6 0.55

-8.5 -9 -9.5 -10

0.5 0.45

-10.5 -11 -11.5

MAX 75th Percentile

0.4

-12 -12.5 -13 -13.5

0.35 0.3

-14 -14.5 -15

0.25

-15.5 -16 -16.5 -17

0.2 0.15

-17.5 -18 -18.5 -19 -19.5 -20 Measurement 1

MEDIAN 25th Percentile MIN

0.1 0.05 Measurement 2

Measurement 1

Measurement 3

Measurement 2

Measurement 4

Measurement 3

0

Measurement 5

Measurement 4

Measurement 5

COUNT UCL LCL MEAN MAX 75th Percentile MEDIAN 25th Percentile MIN RANGE STDEV CV MODE + 3 STDEV - 3 STDEV "K" Factor

Sheet Name: Box Plot Chart

Printed on: 09/04/2008 at 17:13:48

File Name: 5540569.xls

This sheet will display results when Specified Limits are entered on the Set-Up Sheet Measurement 1

Measurement 2

Measurement 3

Measurement 4

Measurement 5

Cp The index simply makes a direct comparison of the process natural tolerance to the engineering requirements. Assuming the process distribution is normal and the process average is exactly centered between the engineering requirements, a CP index of 1 would give a "capable process." However, to allow a bit of room for process drift, the generally accepted minimum value for CP is 1.33. In general, the larger CP is, the better. The CP index has two major shortcomings. First, it can’t be used unless there are both upper and lower specifications. Second, it does not account for process centering. If the process average is not exactly centered relative to the engineering requirements, the CP index will give misleading results. Cpk Since the smallest value represents the nearest specification, the value of CPK tells you if the process is truly capable of meeting requirements. A CPK of at least +1 is required, and +1.33 is preferred. Note that CPK is closely related to CP, and that the difference between CPK and CP represents the potential gain to be had from centering the process. Cpm A CPM of at least 1 is required, and 1.33 is preferred. CPM is closely related to CP. The difference represents the potential gain to be obtained by moving the process mean closer to the target. Unlike CPK, the target need not be the center of the specification range.

Sheet Name: Cp Cpk Cpm

Printed on: 09/04/2008 at 17:13:48