Can I calculate Cpk from Cp and Cr?

D

dragonmaster

#1
Not being real good with math, I would like to know if I can calculate CPK form just having CP and CR available.
 
Elsmar Forum Sponsor
M

Martin

#2
If you send me your e-mail address I can send you an excel file of a capability study. This calculates your Cp and Cpk value in a sec. You just fill in the values (X) and the program calculates the Cp, Cpk, if it's capable and a lot more.

Greetings,
Martin
 
D

Don Winton

#3
Capability Ratio = Tolerance Width/process capability; however i can't make it work out right.

I thought capability ration was Cr = 100/Cp?

Regards,

dWizard
 
J

James Cupello

#4
I would like to respond to dragonmasters original question.

As Don Winton notes: Cp is just the inverse of Cr. Cp is known as process capability. It is simply the ratio of two numbers: A and B.

The numerator in the ratio (number A) is simply the difference between the upper spec and lower spec limits. Obviously I am assuming a two-sided spec limit.

Referring to Sam's post, a +/- spec limit of 0.005 is equivalent to
0.005 - (- 0.005)

or a value of 0.01 for the numerator, not "0."

The denominator (number B) is 6 times the short term estimate of sigma. Lets not get into long-term and short-term estimates of sigma, even though the difference is important. For dragonmasters simple question lets keep it simple.

So we have A/B = 0.01/(6*sigma)= Cp.

Cr = (6*sigma)/0.01

In either case, the answer is not zero.

Cpk is another matter. Cp is a capability index since it measures a processes potential for performance. It is the best one could expect if the process were centered directly between the upper and lower spec limits.

Cpk assumes the process is not centered. In such a case you must calculate two values for Cpk, and use the lesser of the two resulting values.

First we measure Cpk relative to the upper spec limit (USL). Then we measure Cpk relative to the lower spec limit (LSL). The smaller of the two values is the Cpk for the process. The two equations are:

Cpk = (USL - Xbar)/ 3*sigma

Cpk = (Xbar - LSL)/ 3*sigma

Pick the smaller.

If you want to read everything there is to know about measuring process capability suggest Davis R. Bothe's MEASURING PROCESS CAPABILITY, McGraw-Hill, ISBN 0070066523. It runs about $100, so I hope you really want to know this stuff.

Cheers.



------------------
 
S
#5
I found this little "quicky" formula in Juran's hdbk.
Capability Ratio = Tolerance Width/process capability; however i can't make it work out right.
I don't understand the Cp - Cr concept;most tolerances I work with are bilateral,such as +/- 0.005, in which case the Cp always comes out "0", unless I'm using the wrong formula.
 
S
#6
Don, you are correct, but Juran also has the other equation listed in his book.

James, you sre correct. After seeing your response I realized my error; my thoughts were fixated on tolerance rather than USL and LSL. he equation states in the Numerator "USL - LSL", when using tolerance it should be the algebraic sum.
 
Thread starter Similar threads Forum Replies Date
B How to calculate CPK with n = 1 Manufacturing and Related Processes 2
A Simple 125 piece part Capabilty Excel .xls sheet to calculate Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 3
S Which one is better to calculate, Cpk or Ppk? Statistical Analysis Tools, Techniques and SPC 11
G Should I calculate both Cp and Cpk for a Unilateral Tolerance? Statistical Analysis Tools, Techniques and SPC 8
A How to calculate Cpk & Ppk if the tolerance changes during the period? Capability, Accuracy and Stability - Processes, Machines, etc. 5
F Please share an MS Excel sheet to calculate Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 1
M Cpk - How to calculate when the number of samples is less than 30 pieces? Capability, Accuracy and Stability - Processes, Machines, etc. 7
D Use of Customer Specifications to calculate Cpk IATF 16949 - Automotive Quality Systems Standard 13
B How to calculate Cpk on Perpendicularity (Cyl Tol Zone at MMC) Capability, Accuracy and Stability - Processes, Machines, etc. 32
F How to Calculate Cpk with only a Minimum Tolerance Capability, Accuracy and Stability - Processes, Machines, etc. 11
C How to Calculate and Generate a Cpk Chart Statistical Analysis Tools, Techniques and SPC 4
B If I know x-bar, spec limits, and Cpk, can I calculate the control limits? Capability, Accuracy and Stability - Processes, Machines, etc. 16
J Methods used to calculate Cpk value - Need help for Cpk Calculation Statistical Analysis Tools, Techniques and SPC 8
H How can I calculate Cp & Cpk and make a control chart for maintenance activities? Capability, Accuracy and Stability - Processes, Machines, etc. 3
N Cpk vs Ppk - Which should you use and How to Calculate Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 25
A Sampling Plans and Cpk - Ways to Calculate the Sample Quantity Inspection, Prints (Drawings), Testing, Sampling and Related Topics 15
N Capability study - What Values do I have to input to calculate Cp and Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 9
B How do I calculate Cpk with a single Control Limit? Capability, Accuracy and Stability - Processes, Machines, etc. 15
S Cmk and Cpk - When will we need to calculate Cmk? Machine Capability Capability, Accuracy and Stability - Processes, Machines, etc. 4
J How do I calculate the percentage of errors, when I know min, max, mean, cp and CPK Capability, Accuracy and Stability - Processes, Machines, etc. 3
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
M How to calculate benefits? Moving some developed non controlled software/automation systems Service Industry Specific Topics 2
Q Calculate number of people in processes, considering cycle time/takt time = quantity of people Lean in Manufacturing and Service Industries 9
S How to calculate the maximum allowable hysteresis of a pressure gauge General Measurement Device and Calibration Topics 1
S How to Calculate the producer Risk AQL - Acceptable Quality Level 25
Q Methods to Calculate Available Production Rate ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0
K Why calculate LCL in P-chart? Statistical Analysis Tools, Techniques and SPC 4
A Add-On software for VMC to calculate setting time, Idle Time, OEE etc.. Manufacturing and Related Processes 2
L How to calculate the Probability of Deficiency of the AQL of an Inspection AQL - Acceptable Quality Level 16
V How to Calculate Unbiasing Constant C4 Statistical Analysis Tools, Techniques and SPC 1
J How to Calculate OEE Indicator for a Workshop (15 Machines) Lean in Manufacturing and Service Industries 6
R How to calculate UCL (Upper COntrol Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 5
T I want to calculate reliability at 750 hours Reliability Analysis - Predictions, Testing and Standards 8
R How To Calculate & Print CDF and Lower Bound CDF value for some t(time) with Minitab? Using Minitab Software 1
N How to calculate the Premium Freight charges Service Industry Specific Topics 4
A How to calculate Mean and standard deviation without sample size in Minitab Using Minitab Software 5
R When do I need to calculate Process OEE? Manufacturing and Related Processes 12
kedarg6500 How to calculate Thread Pitch Diameter for non standard TPI like 5/8" 17.75 NF3 Manufacturing and Related Processes 3
C Definition and Way to Calculate some Metrics Lean in Manufacturing and Service Industries 6
M How calculate P value for Linearity and Bias using Excel Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
N Formula that will calculate the NoGo Major Diameter of an M20 x 1.5 6H Thread gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
M How to calculate Cg and Cgk for a 2-Dimensional Area Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
T Calculation Question - Calculate the runner weight for a part Manufacturing and Related Processes 2
M Spreadsheet on How to Calculate SMT Capacity wanted Manufacturing and Related Processes 2
F How to Calculate the unbiased Standard Deviation in Excel using Minitab Formula Capability, Accuracy and Stability - Processes, Machines, etc. 6
S Spreadsheet that will Calculate Audit Duration times based on IAF MD5 and MD11 Excel .xls Spreadsheet Templates and Tools 6
M Calculate PPMs by going back to Date of Production or Date Noticed Quality Tools, Improvement and Analysis 7
M How to calculate MTTF (Mean Time to Failure) Reliability Analysis - Predictions, Testing and Standards 1
H How to calculate the Lot Reject Rate Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
L How calculate the number of samples Statistical Analysis Tools, Techniques and SPC 2
Similar threads


















































Top Bottom