Cpk relation to Reliability

D

d.conroy

Hi, Im a little confused can anyone help.

If I need to maintain a 95% reliability on parts dose that mean I need to maintain a true 0.66Cpk.

I'm thinking on a normal distribution curve 2 sigma away from the mean will contain 95% of values.

So then as long as my Cpk is greater than 0.66 (2 sigma away from the limit) the process will meet the 95% reliability requirement.

I know there are confidence intervals on the Cpk also, so the indicated Cpk from a sample will need to be greater than 0.66 to have any confidence of meeting the reliability.

Am I correct?

Bev D

Heretical Statistician
Staff member
Super Moderator
the term reliability has several different meanings...which meaning are you using?

my assumption at this point is that you must prove a 95% conformance (1-defect rate) with XX% confidence. If your usage is different then our answer will be different....

Last edited:
D

Darius

Hi, Im a little confused can anyone help.

If I need to maintain a 95% reliability on parts dose that mean I need to maintain a true 0.66Cpk.
You are really confused, I think what you want is the lower limit of the Cpk estimation to be 0.66 at 95% of confidence.
note added: when you obtain the value of Cpk from a data set, the value is just an estimate for such sample, and there are some formulas to determine the range in wich the real value (for such sample) must lay, so it's a minimum and a maximum value for such interval where the real value must be, such interval is calculated in function with the %confidence specified for such calculus.

To answer this question, sample size is needed, and you didn't provide such information, so I will give you the way to do it, but you will need to add VBA code in Excel. It will give the value of Cpk needed to obtain a minimum value at 95% of 0.66

HTML:
``````Function CpkNotLessThan(Cpk_Min As Single, Conf100 As Byte, Sample_Size) As Single
Dim N As Long, BIG as boolean, Cpk_Obj as Single, Delta as Single
Cpk_Obj = Cpk_Min: Delta = 0.5: BIG = False
Do
DIF = Cpk_Min - (Cpk_Obj - Application.WorksheetFunction.NormSInv((1 - (1 - Conf100 / 100) / 2)) * (1 / (9 * Sample_Size) + (Cpk_Obj) ^ 2 / (2 * Sample_Size - 2)) ^ 0.5)
If Abs(DIF) < 0.0001 Then GoTo 1
If DIF > 0 Then
If BIG Then Delta = Delta / 2
BIG = False
Cpk_Obj = Cpk_Obj + Delta
Else
If Not (BIG) Then Delta = Delta / 2
BIG = True
Cpk_Obj = Cpk_Obj - Delta
End If
Loop Until False
1: CpkNotLessThan = Cpk_Obj
End Function``````
after writing the code and enabling VBA Macros, in an Excel Sheet, you will need to write =CpkNotLessThan(0.66,95,50), for sample size of 50.

Last edited by a moderator:
D

Darius

Well, I think maybe my point was not clear enought, but you can read it in Size Matters by Mark L. Crossley, an excellent article.

I must add that in my previous post, I wrote the formula:

DIF = Cpk_Min - (Cpk_Obj - Application.WorksheetFunction.NormSInv((1 - (1 - Conf100 / 100) / 2)) * (1 / (9 * Sample_Size) + (Cpk_Obj) ^ 2 / (2 * Sample_Size - 2)) ^ 0.5)

And must be (because we only care about the lower bound)

DIF = Cpk_Min - (Cpk_Obj - Application.WorksheetFunction.NormSInv(Conf100 / 100) * (1 / (9 * Sample_Size) + (Cpk_Obj) ^ 2 / (2 * Sample_Size - 2)) ^ 0.5)

That macro obtain the puntual Cpk if you specify the "not less than ..." value, my appologies if I was not clear.

Attachments

• 55 KB Views: 264
D

d.conroy

Thank you very much Darius.

Your answer was the same as what I was thinking (A little easier to understand though)
The Excel sheet works well too, this gave results to that agreed with the calculator I created.

Regards

K Could anyone tell me what is relation / difference in Cpk and Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 4
E Cpk - Relation between measurements and resulting tolerances - Trimming resistors Capability, Accuracy and Stability - Processes, Machines, etc. 4
LTPD, AQL, Ppk and Cpk validation sampling plan table Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
Cp and Cpk for straightness and parallelism Capability, Accuracy and Stability - Processes, Machines, etc. 8
Capability - CPk comparison values Capability, Accuracy and Stability - Processes, Machines, etc. 12
Tolerance definition based on expected Cp/cpk Reliability Analysis - Predictions, Testing and Standards 14
Analysis variation among the lots during cpk calculation. Design and Development of Products and Processes 1
Recommendation for user friendly Gaga R&R and Cpk software Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
How to set up Continuous CpK monitoring of an injection mold process Reliability Analysis - Predictions, Testing and Standards 7
Interpretation with regards to Ppk > Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 14
Cpk Calculation - I analyse a double seam cans Manufacturing and Related Processes 15
Cp / Cpk on position using multiple MMC bonuses Capability, Accuracy and Stability - Processes, Machines, etc. 2
Can we use pin gauges to measure an accurate Cpk ? Capability, Accuracy and Stability - Processes, Machines, etc. 9
Final process capability results - What I am supposed to present? Cp and CpK? APQP and PPAP 11
CpK on a manufactured assembly? Reliability Analysis - Predictions, Testing and Standards 7
How is the Cmk and Cpk calculated? Statistical Analysis Tools, Techniques and SPC 0
O Cpk for Unilateral Tolerance Capability, Accuracy and Stability - Processes, Machines, etc. 9
How to calculate CPK with n = 1 Manufacturing and Related Processes 2
O CPK with a P value less than 0.005 Manufacturing and Related Processes 8
Short Term vs. Long Term SPC Study - Where is Cp and Cpk Defined Statistical Analysis Tools, Techniques and SPC 8
A Cpk Formula seems off, need help!? Capability, Accuracy and Stability - Processes, Machines, etc. 11
D Cp/Cpk on Gages for MSA (vs. Cg/Cgk) Capability, Accuracy and Stability - Processes, Machines, etc. 21
E Questions regarding Cpk Calculation - Should we be using LSL/USL or LCL/UCL? Capability, Accuracy and Stability - Processes, Machines, etc. 5
B Maximum Material Condition with Bonus - Determine Cpk for this one kpc Measurement Uncertainty (MU) 2
Cpk Setting Tolerance - Cart before the Horse? (Wifi Routers) Capability, Accuracy and Stability - Processes, Machines, etc. 3
Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
Cpk on Position w/ MMC on Location and Size Capability, Accuracy and Stability - Processes, Machines, etc. 3
SPC Production - Getting Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 8
S Track Cpk trend Statistical Analysis Tools, Techniques and SPC 5
M Cp & Cpk about a diameter measured with min.,max. and average values. Capability, Accuracy and Stability - Processes, Machines, etc. 13
P Non-normal Data Cpk Statistical Analysis Tools, Techniques and SPC 5
Cpk for Solder Paste Height Statistical Analysis Tools, Techniques and SPC 5
As a part of validation, should i include the acceptance criteria of CPk index >1.33? Qualification and Validation (including 21 CFR Part 11) 4
T Cpk for 0 as Ideal Value Statistical Analysis Tools, Techniques and SPC 1
P Profile Tolerance and CPK Manufacturing and Related Processes 3
V When to use Cp Cpk and Pp Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 4
M Calculating Cpk when sample size equals to 1 Capability, Accuracy and Stability - Processes, Machines, etc. 12
CpK in Minitab when 0.0 is the lower spec limit Statistical Analysis Tools, Techniques and SPC 7
Best way to Chart an On-Going CPK Requirement Capability, Accuracy and Stability - Processes, Machines, etc. 4
U Cpk for Contaminant Mass - Washing Parts Capability, Accuracy and Stability - Processes, Machines, etc. 6
Help with Cpk procedure Capability, Accuracy and Stability - Processes, Machines, etc. 3
J Calculation of σ within subgroups for Cpk in Minitab Using Minitab Software 1
S Value of Ppk or Cpk when targeting thinner material Statistical Analysis Tools, Techniques and SPC 4
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
D Calculating Cpk on Non-Normal Data Distribution Capability, Accuracy and Stability - Processes, Machines, etc. 10
B Process Capability - Changing Limits to Improve Cpk or find Root Causes? Capability, Accuracy and Stability - Processes, Machines, etc. 6
Cpk vs Ppk to look at the Capability by Fixture Capability, Accuracy and Stability - Processes, Machines, etc. 4
Convincing Management Cpk without Stability is Meaningless Capability, Accuracy and Stability - Processes, Machines, etc. 7
C Hardness Testing - Low Cpk's using Minitab Misc. Quality Assurance and Business Systems Related Topics 10
L Cpk after Data Transformation - How to Transform LCL /UCL to get Capability Report Capability, Accuracy and Stability - Processes, Machines, etc. 8