GRR Study | Gauge R&R | Explained with Excel Template

What is GRR Study (Gauge R&R)?

→ GRR Study (Gage R&R) is a methodology used to determine the amount of variation in the measurement data due to the measurement system.
→ The full name of the GRR is Gauge Repeatability and Reproducibility that is a very important part of Measurement System Analysis.

➨ Five Parameters of GRR (Gauge R&R) Study:

  1. Equipment Variation (EV)
  2. Appraiser Variation (AV)
  3. Gauge Repeatability & Reproducibility (Gauge R&R)
  4. Part Variation (PV)
  5. Total Variation (TV)


[1] Equipment Variation (EV):

→ This is the variance within the appraiser.
→ EV measures the variance of an appraiser when measuring the same part (and the same characteristic) using the same instrument more than one time.
→ Calculation of EV
Equipment Variation (EV)
➨ Where K1 is a constant that depends on the number of trials.
     ⇢ For 2 trials, K1 is 0.8862.
     ⇢ For 3 trials, K1 is 0.5908.

[2] Appraiser Variation (AV):

→ AV is the variance between the different appraisers when measuring the same characteristic on the same part with the same instrument more than one time.
→ Calculation of AV:
Appraiser Variation (AV)
➨ Where K2 is a constant that depends on the number of appraisers.
     ⇢ For 2 appraisers, K2 is 0.7071
     ⇢ For 3 appraisers, K2 is 0.5231



[3] Gauge Repeatability & Reproducibility:

→ It is the combination of AV and EV or we can say that the vector sum of EV and AV, the calculation is given below.
GRR Calculation Gauge Repeatability & Reproducibility

[4] Part Variation (PV):

→ The PV is calculated by multiplying the range of the part averages (Rp) by a constant K3.
→ K3 depends on the number of parts.
→ The PV is then given by:
Part Variation (PV)
➨ Some other values of K3:
Part vs K3 value

[5] Total Variation (TV):

→ This is the total variance of data recorded. We can calculate the TV by doing a vector sum of  PV and GRR. It is determined by the following equation:
Total Variation (TV)



Six Steps for GRR Study (Gauge R&R) with Excel:

  1. Determine the number of parts, appraisers, and trials
  2. Select the part & measuring instrument for the study
  3. Label the parts from 1 to n and designate the appraisers A, B, etc.
  4. Conduct the Measurements & put data into the Excel Template
  5. Analyzing the Results
  6. Interpreting the results
👉 Download Excel Template for GRR Study

Step 1: Determine the no. of parts, appraisers, and trials:

→ The number of parts (n) must be greater than or equal to 5.
→ The appraisers (k) must be greater than 2.
→ The number of trials (r) must be greater than or equal to two.
→ In addition, the n*k should be greater than 15.
→ This gives more confidence in the results.

Step 2: Select the parts & measuring instrument:

→ The next step is selecting the parts to include in the study.
→ The parts should be selected to reflect the range of variation in the process. They should be selected in the proper method that they cover all possible variants of the manufacturing process.
→ In other words, don't just take 10 parts off the line right in a row.
→ If appropriate, calibrate the instrument or verify that the last calibration date is valid.

Step 3: Label the parts & designate appraisers A, B, etc.

→ Now we have to designate the appraisers and A, B, C, etc. and label the parts from 1 to n, but we have to take care of one thing that the appraisers must not aware of these things otherwise we can not get a proper result



Step 4: Conduct the Measurements & Put data into Excel:

→ The parts must be run in random order.
→ All appraisers measures the reading each part 3 times.
→ Example trial1 – first in order, trial2 - second in reverse order, trial3 - third random).
→ Start with appraiser A - measures the parts in random order.
→ The results are recorded.
→ This process continues for each appraiser.
→ This cycle is continued until you have completed all trials.
→ Be sure that an appraiser cannot see his/her results from previous trials.
→ Open the above mentioned Excel worksheet to record data then enter the data related to your process.
→ Enter the number of operators, trials, samples and specification limits

 Step 5: Analyzing the Results

→ Analyze data in the Gauge R&R worksheet.
→ In this analysis, we have selected three appraisers (A, B, and C) and five parts that represent typical variation in the length output.
→ All appraiser measures the reading each part 3 times.
→ The Calculation is mentioned in the below picture.

Data collection with 3 appraiser and 5 parts

→ We use the above results for further calculation.
→ We start by determining the following:
→ The average for each trial for each appraiser
→  Average & Range of each part with each appraiser.
→ The average range for the part
➨ These calculations are shown in the table below.



Calculation of recorded data

➨ Determine the average range for the three appraisers

Determine the average range for the three appraisers

➨ Then, calculate the difference between the maximum and minimum of appraiser average.

determine the difference

→ The appraiser A has the maximum average (3.157) and appraiser C has a minimum average (2.695).
→ Thus, the difference is (3.157) - (2.695) = 0.462
➨ Next, we will calculate the range of the part averages (Rp).

determine the range of the part averages (Rp)

→ Here we subtract the largest average value minus the smallest average value.
→ So, Rp = (4.10) - (1.94) = 2.16
➨ Putting up these values into five parameters of Gauge R&R Study:

Five Parameter of GRR Study



Step 6: Interpreting the results:

→ You must have variance in the parts and in the appraisers to calculate the above numbers.
→ We have to check TV to decide that our measurement system is applicable or not?

Calculation of Total Variation

→ The number that most people focus on first is the % GRR.
→ The following guidelines can be used to determine if the measurement system is acceptable, conditionally acceptable or not acceptable.

Green: GRR % < 10% of TV (Measurement system is acceptable)
Yellow: GRR % = 10-30% of TV (Conditionally acceptable based on the application)
Red: GRR % > 30% of TV (Measurement system needs improvement)   

→ In this example, the measurement system needs improvement since the value is greater than 30%.
→ Sometimes you can look at the %AV and %EV to get insights into where to start improving the measurement system.
→ But the study indicates that the measurement system must be improved.

NDC value in Gauge R&R Study:

➨ Also, we will check the number of distinct categories (ndc) in Gauge R&R Study.
→ This is a measure of the number of distinct categories that can be distinguished by the measurement system.
→ It is similar to looking at how many possible values there are on a Range Control Chart.
→ The calculation is:
     NDC = 1.41(PV/GRR) = 1.41(0.872/0.319) = 3.8
→ The integer value of NDC should be greater than or equal to 5.
→ In this case, it is 3.
→ Again, this is an indication that the measurement system needs improvement.



Correction Criteria of Measurement System Analysis:

➨ If Repeatability is large compared to Reproducibility, then the reasons may be:
     ⇢ The instrument needs maintenance;
     ⇢ Other reason may be the instrument should be redesigned to be more rigid;
     ⇢ The clamping or location for gauging needs to be improved;
     ⇢ There is excessive part variance.

➨ If reproducibility is large compared to repeatability, then possible causes may be:
     ⇢ The appraiser needs to be better trained in how to use and read the instrument.
     ⇢ Calibrations on the instrument is not clear
     ⇢ A fixture may require to use the Gauge/Instrument in an appropriate manner.

Improvement points in Gauge R&R study in MSA

→ Brainstorm with the team for improvement solutions.
→ Determine the best “practical solution” (may require some experimentation).
→ Pilot the best solution
→ Implement the best solution – train employees.
→ Again conduct the study to verify the Improvement.

👉 Also Read:



👉 For a regular update :   
Join us (Telegram Group)
Join us (WhatsApp Group)

👉 See Also: