Cpk Formula seems off, need help!?

A

Aleforge

#1
This is driving me nuts. I have not completed many CPKs before and previously I have used a template to calculate each data set. It was setup for only 30pc inspections, but the new customer needs a 35pc. So I attempted to modify my excel sheet to incorporate the extra parts. However I am getting weird CPK results.

For instance I have one sample that only deviates .002 from the nominal (tol is +/- .005). However my CPK number is coming out as .8468. That does not seem right to me? As I mentioned I am fairly new to CPKs in general and relied solely on a template that I did not create.

(ugh site won't allow me to link drop box file)

I was under the impression that "good" CPKs should hover around the 1.5 mark.

Thank you VERY much!

If anyone WILL take a look at the file please let me know and I will PM it.
 
Elsmar Forum Sponsor

Bev D

Heretical Statistician
Staff member
Super Moderator
#2
without seeing the data I would venture a guess that the example you have given is due to chunky data. chunky data is data that has very few possible results compared to the range of the variation. (for example if the range of variation goes from .001 to .005 and the resolution of the gage is in .001 you will have chunky data) Chunky data results in an overstated standard deviation which would then result a smaller Cpk.
 
A

Aleforge

#3
OK, so I just edited the results and spread them around more. And the Cpk dropped down to a .3937.... All of the measurements still are inside the tolerance, but tilting towards both ends. Each time I changed one the Cpk dropped.

On my second set of measurements I have a Stdev of only .0009 , the above mentioned is a .0020 now. The .0009 Stdev one is giving me a Cpk of 1.7363

/sigh

Thank you for helping. I wish I could link the file in here. This is driving me insane, and I have a customer breathing down my back (and starting to look like an idiot). =(
 

howste

Thaumaturge
Super Moderator
#5
Your data in the first column are all on the low side of the tolerance. The Cp value looks good, but the process average needs to be shifted to get a good Cpk.

If the process is centered on the nominal, the Cpk would equal the Cp.
 
Last edited:
A

Aleforge

#7
OK, so I shifted all of them between .279 to .281 and now my CPK is 2.429 and CP 2.608 as you said it would.

I suppose I am confused on how this works and had some misconceptions. For instance I assumed as long as your in tolerance you would have a higher CPK.

Which leads me to guess in order to get a good Cpk you need to have the part dimensions balanced out (like a see-saw)? Although the farther they are spread, the lower Cpk you end up with correct?

SO... was the first number I came up right, considering they were tilted all one way?


One thing I noticed is I have one Cpk coming in around 5.578. I suppose it's right but that leads me to wonder how high a Cpk can go up? (too lazy to change all my numbers dead on to see).

I really appreciate the help, it makes a lot of sense now. I finally feel I can move forward with some confidence.
 

howste

Thaumaturge
Super Moderator
#8
If you look at the bell-shaped normal curve on Miner's post, you can see that part of the distribution is under the lower specification limit. The calculations you made are based on a sample from the total population of parts, which are estimates of the population. If you measured and plotted, for example, 1000 part readings from the same process without adjustment (assuming that it's normal) it should look like the normal curve and you would actually find that some parts are below the lower specification limit.

Statistically speaking, a Cpk of 1.0 would show up if your process center is 3 standard deviations from the closest of an upper or lower spec limit. A Cpk of 1.33 would be 4 standard deviations away, and a Cpk of 1.67 would be 5 standard deviations away. The farther you are from the spec limits, the higher the probability is that you will have no bad parts.
 
A

Aleforge

#9
Thank you Howste, I finally have a grip on how it works. I appreciate your help as well as everyone else's. =)
 
Thread starter Similar threads Forum Replies Date
Barahir Formula Data Validation Set for Cp, Cpk, Pp & Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 1
C I need help verifying formula's in a database for LCL UCL Cp Cpk PPk Statistical Analysis Tools, Techniques and SPC 14
A Cpk Formula: Am I using it correctly? Excel .xls Spreadsheet form Excel .xls Spreadsheet Templates and Tools 14
L What is the Formula for Cpk in Excel? Excel .xls Spreadsheet Templates and Tools 41
Q Capability - CPk comparison values Capability, Accuracy and Stability - Processes, Machines, etc. 12
D Tolerance definition based on expected Cp/cpk Reliability Analysis - Predictions, Testing and Standards 14
K Analysis variation among the lots during cpk calculation. Design and Development of Products and Processes 1
S Recommendation for user friendly Gaga R&R and Cpk software Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
A How to set up Continuous CpK monitoring of an injection mold process Reliability Analysis - Predictions, Testing and Standards 7
A Interpretation with regards to Ppk > Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 14
U Cpk Calculation - I analyse a double seam cans Manufacturing and Related Processes 15
Proud Liberal Cp / Cpk on position using multiple MMC bonuses Capability, Accuracy and Stability - Processes, Machines, etc. 2
I Can we use pin gauges to measure an accurate Cpk ? Capability, Accuracy and Stability - Processes, Machines, etc. 9
T Final process capability results - What I am supposed to present? Cp and CpK? APQP and PPAP 11
F CpK on a manufactured assembly? Reliability Analysis - Predictions, Testing and Standards 7
M 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
B 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
A Short Term vs. Long Term SPC Study - Where is Cp and Cpk Defined Statistical Analysis Tools, Techniques and SPC 8
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
Hami812 Cpk Setting Tolerance - Cart before the Horse? (Wifi Routers) Capability, Accuracy and Stability - Processes, Machines, etc. 3
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
Proud Liberal Cpk on Position w/ MMC on Location and Size Capability, Accuracy and Stability - Processes, Machines, etc. 3
E 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
alonFAI Cpk for Solder Paste Height Statistical Analysis Tools, Techniques and SPC 5
I 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
S CpK in Minitab when 0.0 is the lower spec limit Statistical Analysis Tools, Techniques and SPC 7
I 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
G 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
Sean Kelley 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
D Cpk relation to Reliability Capability, Accuracy and Stability - Processes, Machines, etc. 4
B Process Capability - Changing Limits to Improve Cpk or find Root Causes? Capability, Accuracy and Stability - Processes, Machines, etc. 6
B Cpk vs Ppk to look at the Capability by Fixture Capability, Accuracy and Stability - Processes, Machines, etc. 4
R 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

Similar threads

Top Bottom