SBS - The Best Value in QMS software

Formula Data Validation Set for Cp, Cpk, Pp & Ppk

B

Barahir

#1
Help me out folks, my Google-fu is failing me this morning.

I have inherited a spreadsheet that we use to calculate Cp, Cpk, Pp & Ppk. I want to make sure that everything is kosher and thought I remembered somewhere a set of sample dataset that had both data and what the correct results should be that one could use to validate the method they were using for calculation.

Maybe I imagined it? If not, could someone point me in the right direction?:thanx:
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
Re: formula data validation set

See the Ford SW Validation dataset file attached to this thread. Don't be put off by the references to MSA. The file contains three tabs. The second tab is validation data for MSA and the third tab is validation data for calculating Cpk and Ppk. The expected results are provided.
 
Thread starter Similar threads Forum Replies Date
T MSA Manual revision 3 Attribute Data - Signal Detection Formula Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
R Cost per test tool/formula Oil and Gas Industry Standards and Regulations 1
R Cost per test tool/formula Oil and Gas Industry Standards and Regulations 1
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
A Cpk Formula seems off, need help!? Capability, Accuracy and Stability - Processes, Machines, etc. 11
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 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
N Usability Formula to Predict Use Error Reduction IEC 62366 - Medical Device Usability Engineering 6

Similar threads

Top Bottom