Gage R&R (Ranges Method) - Reproducibility standard deviation

M

Martin Kies

#1
I have an XL spreadsheet that someone forwarded me with the following details:

3 Operators
10 samples
3 trials

Operator A average (30 measurements) is 5.481
Operator B average (30 measurements) is 5.471
Operator C average (30 measurements) is 5.507

To get the reproducibility standard deviation, the following is used:

= (5.507 - 5.471) * 0.524

Question: where does the 0.524 come from? :frust: Actually, the full formula in the cell is a nested IF statement (if the operator sample averages were only 2 instead of 3, the constant would be 0.709), but I have shortened this for simplicity.

I have checked the usual SPC table of constants (A2, D4, d2, etc), but could not find where this one came from. I even tried some reciprocals of these constants to no avail.

Any help in where these came from would help, along with a table of this constant.

Thanks to anyone in advance who replies.

Martin
 
Elsmar Forum Sponsor
B

ben sortin

#2
"Spreadsheet that someone forwarded me" is the root cause of your problem. I wouldn't let Euclid forward me a spreadsheet without the algorithm(s).
 

Atul Khandekar

Quite Involved in Discussions
#3
Martin Kies said:
To get the reproducibility standard deviation, the following is used:

= (5.507 - 5.471) * 0.524

Question: where does the 0.524 come from? :frust:
I have checked the usual SPC table of constants (A2, D4, d2, etc), but could not find where this one came from. I even tried some reciprocals of these constants to no avail.

Any help in where these came from would help, along with a table of this constant.
Martin,
First off, Welcome to the Cove!

I would suggest you get hold of the AIAG MSA Manual - third edition, where R&R procedures, formulas and constants are explained. ( http://www.aiag.org )

Appraiser Variation (AV) or reproducibility is calculated by dividing the range of appraiser averages by a constant d2*. K2 is the inverse of d2*. The manual gives the complete table for d2*.

AV = XBar_Diff *K2
K2 = 1 / d2*

For 2 operators: d2*= 1.41421; K2= 0.7071
For 3 operators: d2*= 1.91155; K2= 0.5231

The formula you have given appears incomplete. The reproducibility value obtained as above has to be adjusted to remove the 'contamination' by Equipment Variation (EV), because taking the appraiser averages does not completely isolate AV & EV. The complete formula is:

AV = Sqrt( (XBar_Diff *K2)^2 - (EV^2/nr) ), where
n = No of Samples
r = No of Trials

Hope this helps..

-Atul.
 
C

candy_hy

#4
Sometimes I've use 1 operator in GR&R, But it's difficut to find these factor for 1 operator, m Samples and n Trials.

Please tell me how to get these factors?

Thank you.
 

Atul Khandekar

Quite Involved in Discussions
#5
candy_hy said:
Sometimes I've use 1 operator in GR&R, But it's difficut to find these factor for 1 operator, m Samples and n Trials.

Please tell me how to get these factors?
candy_hy,

Welcome to the Cove Forums.

Reproducibility can be calculated only when you have more than one operator in a GRR study. For one operator, AV=0. So there should be no need to find out the value of K2 factor - its not given in the AIAG manual.

Also see: R&R study with one appraiser

Hope this helps.

- Atul.
 
Thread starter Similar threads Forum Replies Date
B Gage calibration frequency, ISO and IATF - What are the requirements Calibration Frequency (Interval) 3
R Determining Uncertainty from Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
C Correct Calibration Method for Dial Depth Gage General Measurement Device and Calibration Topics 6
C Gage Block Wringing General Measurement Device and Calibration Topics 3
B Gage R&R with NDC=1 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
S Type 1 Gage R&R or something else? Reliability Analysis - Predictions, Testing and Standards 6
G Should I perform Gage R&R only at the beginning of a new project? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
V Thread Plug Gage Pitch GO Diameter out of spec AQL - Acceptable Quality Level 8
G Gage R&R - Where am I going wrong? Part of a FAIR submission (Aerospace) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
K Gage R&R with more than 3 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Anerol C Gage R&R Template AIAG 4th Edition IATF 16949 - Automotive Quality Systems Standard 3
T Attributes SPC study - Attributive control (Go gage) Statistical Analysis Tools, Techniques and SPC 5
S Capability or Gage R&R Study for Leak Tester? Reliability Analysis - Predictions, Testing and Standards 15
N % Tolerance - Type 1 study on the gages, then a gage R&R (ANOVA) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
M Definitive answer on Type 1 vs Type 2 vs Type 3 Gage Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
V Gage Management and Gage R&R Software General Measurement Device and Calibration Topics 1
D Gage R&R Study on Load Cells - Large chemical blending tanks IATF 16949 - Automotive Quality Systems Standard 1
B Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
S Gage R&R on alloy Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
8 Need Help - Runout - Function Gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
L Gage R&R studies for identical Devices - Need to confirm the requirement to perform them Reliability Analysis - Predictions, Testing and Standards 2
G Stab Pin Size For Check Gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
E Functional Gage for TOP applied at RFS Design and Development of Products and Processes 5
F No reproducibility Error in Gage R&R? Reliability Analysis - Predictions, Testing and Standards 4
M Template for Attribute Gage R & R wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
G Warning about Deltronic Gage Pins - The "Certification of Accuracy" document General Measurement Device and Calibration Topics 13
A Gage type 1 study on CMM Capability, Accuracy and Stability - Processes, Machines, etc. 2
Q Gage R&R for Instant Measurement Machine Manufacturing and Related Processes 6
M Gage R&R with large inter part variance - Torque Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
D Do we need normal data for gage r&r studies? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
D Do I need part variation while doing Destructive Variable Gage R&R MSA study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
S Gage R&R Standard Deviations Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
J Informational Gage R&R: Swapping operators Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
S Gage R & R for large amount of inspections IATF 16949 - Automotive Quality Systems Standard 10
S Ring Gage Thermal Expansion General Measurement Device and Calibration Topics 4
L Gage R&R for test precision or uncertainty prediction? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S Minor diameter of threaded ring gage General Measurement Device and Calibration Topics 1
A Does Torque Gage Need Validation? Reliability Analysis - Predictions, Testing and Standards 4
J Ignoring a Failed Gage R&R and upcoming external audit IATF 16949 - Automotive Quality Systems Standard 22
R Scaling a Gage R&R - 2 holding fixtures each with 10 nests Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
B Gage R&R Acceptable (10-30%), deduct Total Variation from Tolerance Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
apestate Inexpensive Gage Blocks for small aerospace startup shop General Measurement Device and Calibration Topics 1
F Position tolerance check gage manufacturing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
B Informational Expanded Gage R&R Analysis using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18
S Interesting Discussion Threaded ring gage calibration and tendonitis in the elbows General Measurement Device and Calibration Topics 8
A Federal 700B-26 Gage Block Comparator is not reading properly General Measurement Device and Calibration Topics 0
O Gage Simulator for a Pilot at RFS Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
J Gage R&R without tolerance Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
B Variable Gage R&R - Two operators instead of three Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4

Similar threads

Top Bottom