View Full Version : Tolerancing based on Cpk Data - Spreadsheet Attached
gianni 1st December 2003, 03:21 PM Can anyone please tell me if there is a way to determine what tolerance is required on a specific dimension to acheive a 1.33 Cpk? Is there a cut and dry method to say, for example: P1 = 4.5 Newtons; to hold 1.33 you will need a tolerance of ____? Or, based on the Cpk result of 0.684 you need x amount more tolerance to achieve Cpk 1.33, based on the sample data. Is there a quick calculation to determine this?
EX. P1 = 4.5 Newtons ± .4 Newtons
What will I have to hold to maintain a 1.33 Cpk?
Proud Liberal 1st December 2003, 04:53 PM Tolerance = ± 4 sigma
Darius 1st December 2003, 05:08 PM if USL - Mean < Mean - LSL
Cpk = (USL - Mean)/(3*Sigma) => USL = Mean - Cpk *3*Sigma
and if Cpk=1.33 then USL = Mean - 4 * Sigma
if USL - Mean > Mean - LSL
Cpk = (Mean - LSL)/(3*Sigma) => LSL = Mean + Cpk *3*Sigma
and if Cpk=1.33 then LSL = Mean + 4 * Sigma
So (Mean - Cpk *3*Sigma, Mean + Cpk *3*Sigma)
But still, Cpk depends on the sample size so the calculus get harder and depends on wich estiamate do you like: the maximum or the minimum or not less than a fixed Cpk value and the current Cpk.
:ko:
D.Scott 2nd December 2003, 08:28 AM Here is a simple Cpk worksheet that calculates the Cpk and gives you the estimated tolerance needed to meet a given Cpk.
I hope it will help.
Dave
Darius 2nd December 2003, 10:39 AM Dave, nice worksheet, but the calculus of the standard deviation is total variation estimate, desto ppk not Cpk.
:caution:
M Greenaway 2nd December 2003, 04:45 PM I thought Cpk was based on the tolerance anyway, hence you need a tolerance to determine Cpk as it is the ratio of the 3 sigma spread to the mean - USL/LSL spread.
However the point about designers actually considering process capability when they dream up a tolerance is absolutely vital. I often think that if they just considered this many of us would be out of work. So much 'poor' quality is designed in through unknown process capability.
gianni 2nd December 2003, 06:19 PM Here is a simple Cpk worksheet that calculates the Cpk and gives you the estimated tolerance needed to meet a given Cpk.
I hope it will help.
Dave
Thanks for the spreadsheet. This will help me very much.
D.Scott 3rd December 2003, 08:56 AM I thought Cpk was based on the tolerance anyway, hence you need a tolerance to determine Cpk as it is the ratio of the 3 sigma spread to the mean - USL/LSL spread.
:bigwave: How have you been M?
You are right as usual of course but what we are talking about here is a "reverse capability" used to estimate the tolerance needed to meet a given Cpk in production. The method used is only an estimate and does no more than give you a "ballpark" for quoting a job. I guess you could say this is one of those "tools" we often use that is not strictly accurate. The "Gurus" would frown and the "experts" would lower their eyes but it really works wonders when sales or the customer asks "well, what DO you need?"
Nice to see you again.
Dave
Sam 3rd December 2003, 10:08 AM :bigwave: How have you been M?
You are right as usual of course but what we are talking about here is a "reverse capability" used to estimate the tolerance needed to meet a given Cpk in production. The method used is only an estimate and does no more than give you a "ballpark" for quoting a job. I guess you could say this is one of those "tools" we often use that is not strictly accurate. The "Gurus" would frown and the "experts" would lower their eyes but it really works wonders when sales or the customer asks "well, what DO you need?"
Nice to see you again.
Dave
Absolutly. Very good "common sense" tool.
The Taz! 3rd December 2003, 04:28 PM Hey gang. . .
Am I missing something here?? :confused:
Why are you talking about Cpk for setting a tolerance when Cp is the real measure of the processes capability irregardless of the centering. Centering is an adjustment. You can also look at Cr which is the inverse of Cp.
Cp = (Blue Print Tol. / 6-Sigma), The higher the better.
Cr = (6 Sigma / Blue Print Tol.) = % of Blue Print tolerance, The lower the better.
IMHO, I think you would be better off looking at Cp as the basis. If you want to look at it another way, take your 6-sigma spread (From your process capability study), and multiply it by 1.33. Now you will be challenged to hold the process on target to maintain it. Shoot for 1.67. Ford didn't pick it by chance. That will give you room for natural variation and process movement over the long haul.
Darius 3rd December 2003, 05:01 PM FYI
At 95% Confidence with a minimum Cpk of 1.33 means Cpk(50 sample)= 1.67363
At 95% Confidence with a maximum Cpk of 1.33 means Cpk(50 Sample)=1.09463
At 95% Confidence the not less than Cpk of 1.33 means Cpk(50 Sample) =1.60779
At 90% Confidence with a minimum Cpk of 1.33 means Cpk(50 Sample) =1.60779
At 90% Confidence with a maximum Cpk of 1.33 means Cpk(50 Sample) =1.12801
At 90% Confidence the not less than Cpk of 1.33 means Cpk(50 Sample)= 1.53799
:smokin:
Bill Ryan 4th December 2003, 08:54 AM FYI
At 95% Confidence with a minimum Cpk of 1.33 means Cpk(50 sample)= 1.67363
At 95% Confidence with a maximum Cpk of 1.33 means Cpk(50 Sample)=1.09463
At 95% Confidence the not less than Cpk of 1.33 means Cpk(50 Sample) =1.60779
At 90% Confidence with a minimum Cpk of 1.33 means Cpk(50 Sample) =1.60779
At 90% Confidence with a maximum Cpk of 1.33 means Cpk(50 Sample) =1.12801
At 90% Confidence the not less than Cpk of 1.33 means Cpk(50 Sample)= 1.53799
:smokin:
Could you explain please. I'm not that statistically literate, but I don't understand this at all :confused:
Bill
Darius 4th December 2003, 10:54 AM :caution: Size does matter, a sample size of 50 means a lot of possible variation on the capability index.
A value of Cpk of 1.33 obtained with 50 points at a degree of confidence (ie. 95%) could be 1.096 to 1.564 at the next 50 points and still be the same (no change in the Cpk).
Ár skal rísa / sá er annars vill fé etha fior hafa; sialdan liggiandi úlfr / laer um getr, né sofandi mathr sigr.
|