What is the formula I need to calculate Pp and Ppk?

A

akiton

#1
Due to this our customer requesting us to come up with Pp, Ppk figures.
With the data given below can anyone help to figure out the pp,ppk value?

Spec: 107 ± 3 microns
Code:
Sample               1      2      3      4     5      6    
1) Part A    -      108    107    105    108    106    106 
2) Part B    -      106    107    105    105    104    106
I need to know the formula (not with those code) but the numerical formula using the example above so that in future I can calculate myself.

Please advice. Thanks
 
Elsmar Forum Sponsor
A

akiton

#3
I've gone thru that site already and it doesn't have any numerical example shown there.

Anyone here please use the example posted to show me the formula. Thanks.
 

Tim Folkerts

Super Moderator
#4
Attached is the results of a Minitab analysis of the data - numbers & graphs pasted into a word document. Hopefully that points you in the right direction. If you have questions about specific numbers, I should be able to provide a little guidance.

Tim F
 

Attachments

A

akiton

#5
Tim Folkerts said:
Attached is the results of a Minitab analysis of the data - numbers & graphs pasted into a word document. Hopefully that points you in the right direction. If you have questions about specific numbers, I should be able to provide a little guidance.

Tim F
Thanks for your reply. I need to know the numerical formula to get the result.

Please advice. Thanks
 
A

Arvind

#6
Capability calculations need 30 to 100 samples for acceptable confidence band

You can calculate capability using a scientific calculator.

1) Find mean and standard deviation from the data.
2) Multiply std dev by 6.
3) In your case, tolerance band is +/- 3 or total 6
4) Divide 3) by 2) to get Pp

5) Find smaller of the two absolute values (UCL-Mean) and (LCL-Mean). Use only smaller value.
6) Multiply std dev by 3
7) Ratio of 5) by 6) will give Ppk.

Confidence band using such low sample size is unacceptably wide therefore your calculated values may not mean anything useful in real life. Even with 30 samples, capabilities have tolerance value of +/- 25 %.
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#8
Due to this our customer requesting us to come up with Pp, Ppk figures.
With the data given below can anyone help to figure out the pp,ppk value?

Spec: 107 ± 3 microns
Code:
Sample               1      2      3      4     5      6    
1) Part A    -      108    107    105    108    106    106 
2) Part B    -      106    107    105    105    104    106
I need to know the formula (not with those code) but the numerical formula using the example above so that in future I can calculate myself.

Please advice. Thanks
There is not enough information here to calculate Pp or Ppk. What is the process. and what does the data represent? The capability analyses that have been provided from dumping this data into a number cruncher may only indicate that the variation you see is from measurement error and perhaps gage error (since a six micron tolerance should be measured with something with a resolution of 600 nanometers at a minimum - and more likely 100 nanometers - not 1 micron resolution), which tends to be normal, and tends to nicely mask the actual process variation. If this was a part from precision machining (the 6 micron tolerance makes me suspicious that it might be), and you both controlled and measured the part correctly, then the capability is (USL-LSL)/UCL-LCL) - not any of the citations listed previously.

See Statistical process control for precision machining for more information, if it applies.
 

smryan

Perspective.
#9
Re: Capability calculations need 30 to 100 samples for acceptable confidence band

You can calculate capability using a scientific calculator.

1) Find mean and standard deviation from the data.
2) Multiply std dev by 6.
3) In your case, tolerance band is +/- 3 or total 6
4) Divide 3) by 2) to get Pp

5) Find smaller of the two absolute values (UCL-Mean) and (LCL-Mean). Use only smaller value.
6) Multiply std dev by 3
7) Ratio of 5) by 6) will give Ppk.
I'm trying to sort out Cpk and Ppk too. So... if I am understanding this correctly, the calculations for Cpk and Ppk are identical.... just use a different sigma.

But that doesn't match my basic understanding ...Cpk is how well curve fits between the control limits and Ppk is how well the curve and limits line up with the specifications. How can the same calculation give two different things. :confused:
 
R

Rebecca Bowes - 2010

#10
You can't go wrong in using minitab. I don't work for minitab, just think it is the greatest tool ever!!! Well worth the time to learn it and use it...my opinion, just sharing the joy!
 
Thread starter Similar threads Forum Replies Date
A Cpk Formula seems off, need help!? Capability, Accuracy and Stability - Processes, Machines, etc. 11
D Need some help with a formula in Excel Please! Excel .xls Spreadsheet Templates and Tools 11
J 2 Reliability Problems - Have Answers, Need Formula Reliability Analysis - Predictions, Testing and Standards 7
C I need help verifying formula's in a database for LCL UCL Cp Cpk PPk Statistical Analysis Tools, Techniques and SPC 14
S Bend allowance formula to calculate per degree per radii Manufacturing and Related Processes 2
J Unbiasing Constant "d4" formula Statistical Analysis Tools, Techniques and SPC 4
S Formula for Calculating NoGo Major Diameter for UN gages Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
J CMM Accuracy Formula General Measurement Device and Calibration Topics 3
I Formula in the Annex of IEC 61000-4-3 - How is k=7 determined? IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
Z Inspection Form With Pass/Fail Formula Excel .xls Spreadsheet Templates and Tools 11
S used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart Statistical Analysis Tools, Techniques and SPC 0
L Signal-to-Noise (S/N) Ratio formula check Design and Development of Products and Processes 2
S Scrap % Calculation Formula Manufacturing and Related Processes 10
P IF formula - Excel 2003 Excel .xls Spreadsheet Templates and Tools 4
J Bias formula in MSA 4th Edition vs 3rd Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
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
R Formula to tie together - Confidence/Reliability Level AQL? LTPD? Reliability Analysis - Predictions, Testing and Standards 3
F How to Calculate the unbiased Standard Deviation in Excel using Minitab Formula Capability, Accuracy and Stability - Processes, Machines, etc. 6
M Dimension Report Formula .xlsx Editable Spreadsheet Form Excel .xls Spreadsheet Templates and Tools 24
M Should I use binomial or Poisson distribution formula? Statistical Analysis Tools, Techniques and SPC 6
F Excel I want to use the count I get in another formula Excel .xls Spreadsheet Templates and Tools 13
M Formula for Bell Shape in Excel Using Minitab Software 1
M What is the formula to create a bell curve? Excel .xls Spreadsheet Templates and Tools 8
P Does anyone have the GRR Formula? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
M Standard Deviation Estimation Formula - Student Question Statistical Analysis Tools, Techniques and SPC 4
B Formula Data Validation Set for Cp, Cpk, Pp & Ppk Capability, Accuracy and Stability - Processes, Machines, etc. 1
B Attrition Rate and the formula to calculate Attrition Rate Quality Manager and Management Related Issues 1
D Demonstration Reliability Test Formula with allowance for 'x' Failures Reliability Analysis - Predictions, Testing and Standards 6
N Is there a formula to link words in Excel sheet to a graph? Excel .xls Spreadsheet Templates and Tools 5
N Linear Regression Formula with Four Variables to a Power Regression Formula Using Minitab Software 2
M MSA - According to the formula cg how much tolerance should be put in place? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
F SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 components Capability, Accuracy and Stability - Processes, Machines, etc. 8
A Bias Linearity Stability MSA Excel File with Formula Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
J Repeatability Standard Deviation Formula in MSA 4th Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
M Formula for Prioritizing Engineering Change Requests (ECR)? Document Control Systems, Procedures, Forms and Templates 1
I AQL Formula in Excel - Calculating Sample Size based on an AQL Chart AQL - Acceptable Quality Level 8
D Formula for Calculating Warp Measurement of Corrugated Boxes General Measurement Device and Calibration Topics 1
Z KPI Formula Issue - "Change Requests Managed" = Changed/Total ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
O Which role plays Inverse cdf of a Standard Normal Distribution in Formula for Z-Bench Using Minitab Software 8
D Route Delivery Efficiency Formula - Miles driven, number of deliveries, and time(hrs) Benchmarking 3
S Formula used in Minitab 16 - "Pooled Standard Deviation" Statistical Analysis Tools, Techniques and SPC 2
X Microsoft Excel 2003 Formula Restrictions Excel .xls Spreadsheet Templates and Tools 9
T Gage R&R Sheet Formula error?! NDC less than 4 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
C Sample Size Calculation Formula for Process Capability Statistical Analysis Tools, Techniques and SPC 25
Q Accuracy: Is there a specific formula to compute Measurement Device Accuracy? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Rameshwar25 Manual Formula for p-value Calculation for MSA Analysis Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
D Ring Gauges P.D Formula using "Ball Rounded Teeth" General Measurement Device and Calibration Topics 13
R Formula for calculating Money Value equivalent to 1% FPY (First Pass Yield) Six Sigma 5
B Problem with Reliability and Availability Formula Reliability Analysis - Predictions, Testing and Standards 8

Similar threads

Top Bottom