# Cpk & Ppk and Differences between Minitab and an Excel Spreadsheet Results

R

#### rotorsan

I have some measurements from the production data's and analyse it on minitab and on an excel spreadsheet which calculates the Cpk.

As seen on the attachments, Cpk is calculated as 0,99 in excel with formulas but on minitab it is calculated as 1,16 but Ppk is 0,99 - as same as excel sheet-

My collagues in the company uses minitab for their porojects and they choose minitab and calculate Cpk as 1,16. But I put the excel sheet to production and mine is 0,99.

As I am new in statistical controls, can someone help me ?

#### Attachments

• 133 KB Views: 1,491
• 93.5 KB Views: 1,743
S

#### silvestri

Hi Rotorsan,
as you can see in the sheet "alternativefigure" I have just added in your Excel file, i calculated it again by hand made formulas and the results are the same. In my my opinion, the spreadsheet you are using is correct.

And, by the graph, you can see you probably would better not validate that process...

Hope this helps. Bye
Gianfranco

#### Attachments

• 104 KB Views: 1,251
S

#### Sturmkind

Please find the attached. Excel uses formulae for standard deviation that does not use the C4 constant in the denominator to mitigate the bias of the standard deviation estimate. I have attached a screenshot from the Minitab help screen to help assist.

The difference between 0.99 and 1.16 though is pretty small as Cpk follows a Chi-square distribution and these both fit comfortably with standard confidence interval of the mean estimate of Cpk.

#### Attachments

• 54.5 KB Views: 1,362

#### Bev D

##### Heretical Statistician
Super Moderator
Excel uses formulae for standard deviation that does not use the C4 constant in the denominator to mitigate the bias of the standard deviation estimate.
Exactly and rightly so.
EXCEL's STDEV function simply calculates the sample standard deviation using n-1 in the denominator. EXCEL can't know what you will do with the standard deviation and they are quite clear on which formula is used for the sample standard deviation.

Of course Sturmkind is also correct in that the difference of a Cpk of .99 or 1.16 isn't enough to get excited about.

D

#### debyang

I have some measurements from the production data's and analyse it on minitab and on an excel spreadsheet which calculates the Cpk.

As seen on the attachments, Cpk is calculated as 0,99 in excel with formulas but on minitab it is calculated as 1,16 but Ppk is 0,99 - as same as excel sheet-

My collagues in the company uses minitab for their porojects and they choose minitab and calculate Cpk as 1,16. But I put the excel sheet to production and mine is 0,99.

As I am new in statistical controls, can someone help me ?

Althought Cpk is 0.99 or 1.16 may not be that different, but the calculations in Minitab are correct according to the definitions of Ppk and Cpk defined in AIAG's SPC manual. Because the sigma you used in the spreadsheet is calculated from STDEV function not from Rbar/d2 or Sbar/c4, all the process index you got will be Ppk(unstable process performance index) not Cpk(stable process index).
Minitab graphs tell that the process seems to be stable, but it is possible still some special causes exist leading the overall performance is poor than 1.16, only 0.99.

Last edited by a moderator:
R Ppk vs Cpk: Big Differences - What conclusion can I reach about my process? Six Sigma 3
Cpk and Ppk Differences and Questions Capability, Accuracy and Stability - Processes, Machines, etc. 5
Ford CSR Cpk/Ppk Requirements Statistical Analysis Tools, Techniques and SPC 8
Capability in sewing processes CP,CPk,PP,PPk Capability, Accuracy and Stability - Processes, Machines, etc. 10
LTPD, AQL, Ppk and Cpk validation sampling plan table Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
Interpretation with regards to Ppk > Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 14
SPC Production - Getting Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 8
V When to use Cp Cpk and Pp Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 4
S Value of Ppk or Cpk when targeting thinner material Statistical Analysis Tools, Techniques and SPC 4
Cpk vs Ppk to look at the Capability by Fixture Capability, Accuracy and Stability - Processes, Machines, etc. 4
V Customer requires CpK 2 and PpK 1.5 Capability, Accuracy and Stability - Processes, Machines, etc. 2
R Which of the following indicators is important for Operations - Ppk, Cpk, or Cpm? Statistical Analysis Tools, Techniques and SPC 15
U Cpk and Ppk for different Countries/Standards Capability, Accuracy and Stability - Processes, Machines, etc. 7
B Understanding why my CpK and PpK are low, and LCL Statistical Analysis Tools, Techniques and SPC 20
S Which one is better to calculate, Cpk or Ppk? Statistical Analysis Tools, Techniques and SPC 11
A How to calculate Cpk & Ppk if the tolerance changes during the period? Capability, Accuracy and Stability - Processes, Machines, etc. 5
B Formula Data Validation Set for Cp, Cpk, Pp & Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 4
F Please share an MS Excel sheet to calculate Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 1
A How to interpret Minitab Results? What is difference in Cpk and Ppk values? Using Minitab Software 2
J Cpk & Ppk - Reviewing a PPAP Package - Some questions Statistical Analysis Tools, Techniques and SPC 8
S Ppk & Cpk - Within Subgroup Variation is always smaller than Total Variation Capability, Accuracy and Stability - Processes, Machines, etc. 18
CNC Process Validation Cpk Ppk & In-Process Inspection Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
S Pp/Ppk & Cp/Cpk - Which is appropriate for Long/Short Term Study? Statistical Analysis Tools, Techniques and SPC 20
S How is Cpk /Ppk value calculated in Minitab since I have subgroup size of 1 Capability, Accuracy and Stability - Processes, Machines, etc. 1
Q When to use Cpk or Ppk for a Process Capability Study? Capability, Accuracy and Stability - Processes, Machines, etc. 14
A Deciding on when to go for Cp & Cpk or Pp & Ppk Study? Statistical Analysis Tools, Techniques and SPC 3
C Understanding the relationship of Pp, Ppk, Cp, Cpk Six Sigma 4
E Cpk and Ppk template wanted Capability, Accuracy and Stability - Processes, Machines, etc. 3
Q ASQ CSSBB Question on Cpk and PPk , can you solve it ? Capability, Accuracy and Stability - Processes, Machines, etc. 15
Calculation of Cpk and Ppk for an unstable process Statistical Analysis Tools, Techniques and SPC 7
Q PPK, CPK of >= 1.67 Automotive Requirement and Auditing IATF 16949 - Automotive Quality Systems Standard 1
P Individual & MR chart - Ppk or Cpk? Capability, Accuracy and Stability - Processes, Machines, etc. 9
K Normality of distribution prior to Cpk and PpK Statistical Analysis Tools, Techniques and SPC 4
Can Ppk value be greater than Cpk and if yes, under what conditions? Statistical Analysis Tools, Techniques and SPC 10
C Is it possible to get Pp,Ppk more than the within subgroup (Cp,Cpk's) indices? Statistical Analysis Tools, Techniques and SPC 7
Are Pp and Ppk more useful than Cp and Cpk as a benchmark for further studies? Statistical Analysis Tools, Techniques and SPC 1
J Using Pin Gages as a Measurement Tool for Ppk/Cpk studies Capability, Accuracy and Stability - Processes, Machines, etc. 11
B Difference between Ppk (Preliminary), Cpk, Performance Capability Statistical Analysis Tools, Techniques and SPC 2
D Real life example of the difference between Cpk and Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 0
N Cpk vs Ppk - Which should you use and How to Calculate Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 25
V Quality Control Index - We thought that Cpk or Ppk would be good choices Capability, Accuracy and Stability - Processes, Machines, etc. 6
Interpreting the common capability indices: Cp, Cpk, Pk, and Ppk. The Reading Room 5
J Machine issue in Cpk/Ppk and Control Plan - PPAP Submissions APQP and PPAP 5
D Use of an outlier in calculating Cpk/Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 8
N Analysis of non-normal stratified data for cpk/ppk? Rupture test Capability, Accuracy and Stability - Processes, Machines, etc. 6
F Ppk/Cpk value with 1-sided specification - Only given a lower specification Statistical Analysis Tools, Techniques and SPC 1
Ppk/Cpk for geometrical true position of hole with MMC Capability, Accuracy and Stability - Processes, Machines, etc. 17
Validation of Cpk and Ppk calculations - Sheet to check Cpk and Ppk values Statistical Analysis Tools, Techniques and SPC 4
S What is the meaning of "k" in Cpk and Ppk? And Cpk vs. Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 15
A Capability Indexes for ISO/TS16949 - Cpk & Ppk after PPAP Statistical Analysis Tools, Techniques and SPC 6