# How to Calculate and Generate a Cpk Chart

C

#### Charlie Tee

Hi,

Any expert can help me out?
I just generate x bar - r chart in excel
I wish can add in the cpk chart into this worksheet...
I need somebody help...no idea at all... I attached my x bar - r chart.xlx someone can help me to modified to add on cpk or not? #### Attachments

• 44 KB Views: 386
B

#### Barbara B

Re: How to Calculation and Generate a Cpk Chart

I wish can add in the cpk chart into this worksheet...
For the Cpk calculation you have to provide tolerance limits (at least 1), but I don't understand your idea of adding a Cpk into the chart, as the values of the Cpk lie (presumably) outside your parameter range (3.80,4.20) D

#### Darius

Another way to understand Chart is a report with Charts (not a specific Chart), so Charlie want to put Cpk on the report but don't know how to calculate.

Charlie, in your report, I can't see your specification limits, without them is not possible to calculate. Cpk = min (X_Average-LSL, USL-X_Average)/(3Sigma)

As you didn't ask for Cp, looks like your process may have only one spec limit, so use the only one if it is the case.

3Sigma = 0.58*R_Average.

C

#### Charlie Tee

Dear,

The limit spec only have "Minimum Spec", means >3.8 kgf is acceptable...
The CPK　ｉｓ　ｒｅｑｕｉｒｅｄ　ｂｙ　ｍｙ　Ｍａｎａｇｅｒ．　Ｉ　ａｌｓｏ　don't know what purpose he want the cpk chart...T.T

Thanks,
Charlie

#### bobdoering

Trusted Information Resource
I added a Cpk chart based on the calculated standard deviation of each sample set of data. It uses only one specification, and really is a horrible statistic. Cpk is designed to determine if your mean is in the middle of a specification. By using only a unilateral specification, you are kind of just reporting a distance from the specification. It does not directly relate to the original concept of centering your mean within the specification. It appears to be a rubber stamp of Cpk with no real justification of its use.

The CPK　ｉｓ　ｒｅｑｕｉｒｅｄ　ｂｙ　ｍｙ　Ｍａｎａｇｅｒ．　Ｉ　ａｌｓｏ　don't know what purpose he want the cpk chart
Neither do I - so don't feel bad!

#### Attachments

• 30.7 KB Views: 1,032
Last edited:
How to calculate sample size and sample frequency Statistical Analysis Tools, Techniques and SPC 2
Calculate FPY for Audit Results AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
How to calculate the A4 constants in Median/Range control charts? Statistical Analysis Tools, Techniques and SPC 2
How to calculate Effective Number of People for ISO 13485 Certification? General Auditing Discussions 2
Need to calculate tolerance Intervals with a set of non-normal data and 3-Parameter Weibull distribution Using Minitab Software 0
Calculate acceptance of equipment reading after calibration General Measurement Device and Calibration Topics 2
Calculate acceptance of calibration reading Measurement Uncertainty (MU) 1
How would you calculate this? Capability, Accuracy and Stability - Processes, Machines, etc. 4
Bend allowance formula to calculate per degree per radii Manufacturing and Related Processes 2
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
Calculate number of people in processes, considering cycle time/takt time = quantity of people Lean in Manufacturing and Service Industries 9
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
Methods to Calculate Available Production Rate ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0
Why calculate LCL in P-chart? Statistical Analysis Tools, Techniques and SPC 4
How to calculate CPK with n = 1 Manufacturing and Related Processes 2
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
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
When do I need to calculate Process OEE? Manufacturing and Related Processes 12
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 8
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
A Simple 125 piece part Capabilty Excel .xls sheet to calculate Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 3
R How to calculate MMC when is placed after datum Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
S Which one is better to calculate, Cpk or Ppk? Statistical Analysis Tools, Techniques and SPC 11
C How to calculate P value on Probability Plot Statistical Analysis Tools, Techniques and SPC 1
S Supplier Disruption Score and how to calculate it Quality Tools, Improvement and Analysis 4
IAQG OASIS - New tool to calculate Audit Time AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
M How to calculate dimensions of trapezoid ? Quality Tools, Improvement and Analysis 3
How to calculate Surveillance Audit Days in Corporate Audit Scheme IATF 16949 - Automotive Quality Systems Standard 4
S How to calculate Supplier PPM at Receiving Inspection Document Control Systems, Procedures, Forms and Templates 2
How to Calculate Sample Size at 95% Confidence Interval on Surface Roughness Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1