Calculating part variation from historic data for GRR study

J

joonasan

#1
We made a GRR study for measuring gear outside diameter. We had too little information about GRR so the study failed. The part variation was bad, only 13,4%. That means we got very bad results for %GRR (GRR/TV).

I understand now that with better PV we will get more acceptable results. We could continue the study with more samples but I was thinking if we could use our history measurement database to calculate part variation, instead of using the GRR study's PV? I'm a little confused how and if this can be done.

However %GRR based on the tolerance(0,063 mm) is still too bad, so we need to do something in any case.
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
Using historical Process Variation is the best approach as you have discovered.

If you use Minitab, there is an option to enter the Historical standard deviation under the Options tab. This will add a % Process metric that you use instead of the % Study Variation metric.

If you do not use Minitab, you can use my Excel based MSA file found in my blog. If you enter your historical process variation in cell T59 of the GRR Report tab, it will calculate the % Process Variation metric, which is what you are seeking.
 
Thread starter Similar threads Forum Replies Date
P Calculating Gage R&R with Part Tolerance instead of Total Variation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
R What is the correct formula for calculating part variation (PV)? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
D Need Help on the method of calculating tube wall Within Part Variation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
C Calculating your KPIs ISO 13485:2016 - Medical Device Quality Management Systems 7
K Calculating Heat Dissipation Manufacturing and Related Processes 1
Q Calculating Defect Rates ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
S Formula for Calculating NoGo Major Diameter for UN gages Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
P Calculating a weight for a machine for the CE label CE Marking (Conformité Européene) / CB Scheme 0
R Remote Support - Calculating Number of Employees IATF 16949 - Automotive Quality Systems Standard 2
G Calculating Tolerance of a Panel Meter with a 2 degrees of an Arc General Measurement Device and Calibration Topics 0
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
V Product Development - When to start calculating Process Capability Capability, Accuracy and Stability - Processes, Machines, etc. 3
J Calculating Reliability for Subsystems in Series Reliability Analysis - Predictions, Testing and Standards 15
Stijloor Calculating (3rd Party) Audit Days for Company with Seasonal Employees General Auditing Discussions 3
T Formulas for Calculating Coefficients for RTD / PRTD Calibration According to ITS-90 General Measurement Device and Calibration Topics 5
P Purpose of calculating Ta, Tb & R Square in Linearity Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
P Purpose of calculating Uncertainty value in calibration study Measurement Uncertainty (MU) 5
M Calculating MTBF for plug-in PCI cards Reliability Analysis - Predictions, Testing and Standards 2
J Calculating impact force, expressed in lbs, of a 5 lb weight dropped 48 inches Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
M Calculating Cpk when sample size equals to 1 Capability, Accuracy and Stability - Processes, Machines, etc. 12
D Calculating Cpk on Non-Normal Data Distribution Capability, Accuracy and Stability - Processes, Machines, etc. 10
K Calculating Capability of a process when data is skewed in the upper range Capability, Accuracy and Stability - Processes, Machines, etc. 4
A Calculating Accuracy for a Multimeter General Measurement Device and Calibration Topics 1
M Calculating Coefficients for an RTD (Resistance Temperature Detector) Probe General Measurement Device and Calibration Topics 3
T Calculating Plating/Coating Weight for IMDS RoHS, REACH, ELV, IMDS and Restricted Substances 3
D Calculating Lower and Upper 3 Sigma Control Limits Statistical Analysis Tools, Techniques and SPC 2
M Calculating Adequate Receiving Inspection Sample Size Statistical Analysis Tools, Techniques and SPC 2
M Calculating Capability of Delivery Performance Capability, Accuracy and Stability - Processes, Machines, etc. 5
K Advice on Calculating Control Chart Control Limits Statistical Analysis Tools, Techniques and SPC 13
B Calculating Combined DPMO and Sigma Level for Two or More Different Work Areas Six Sigma 3
G Calculating the Fraction Defective Confidence Interval for a Lot Statistical Analysis Tools, Techniques and SPC 2
A Calculating Combined Measurement Uncertainty - VDA 5 Measurement Uncertainty (MU) 1
B Calculating Precision to Tolerance Ratio Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
D DPPM - Calculating the Defect Rate of a Software Test Statistical Analysis Tools, Techniques and SPC 9
L FMEA - Calculating RPN = S*O*D FMEA and Control Plans 3
I Shewhart Constants vs Central Limit Theorem in calculating Control Limits Statistical Analysis Tools, Techniques and SPC 18
B Please share a template for calculating Cp Cpk Document Control Systems, Procedures, Forms and Templates 3
S Is a Stable Process (within Control Limits) required for Calculating Pp, Ppk? Capability, Accuracy and Stability - Processes, Machines, etc. 6
M Calculating the IATF TS 16949 Recertification Audit Man Days - Clarification ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
J IEC60825 - Laser Safety - Calculating Maximum Permissible Exposure Correctly Other ISO and International Standards and European Regulations 1
P Calculating Process Capability from Data of attached spreadsheet Statistical Analysis Tools, Techniques and SPC 4
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
S Need Help Calculating and Implementing Cs - Wright's Index Statistical Analysis Tools, Techniques and SPC 11
S Calculating an Uncertainty Budget for an Optical Comparator General Measurement Device and Calibration Topics 4
D One-Two-Three Sigma Control Limits - Calculating Control Limits for X-bar Charts Statistical Analysis Tools, Techniques and SPC 3
K Calculating (Approximate) Parallelism Inspection, Prints (Drawings), Testing, Sampling and Related Topics 10
S Calculating MTBF (Mean Time Between Failures) for the whole Production Unit Reliability Analysis - Predictions, Testing and Standards 2
J Need help calculating actual Ppk - Result of % GR&R=11.8% when conducting MSA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
M Calculating Cp and Cpk - Is my calculation correct? Capability, Accuracy and Stability - Processes, Machines, etc. 7
Similar threads


















































Top Bottom