Gauge R&R Study Workshop by Using Excel

Course Objectives

This course mainly focused on the conducting of the gauge R&R study on variables and attributes data by using Excel. These studies based on simulated variables data using Excel, and appropriately select data for an attribute study, then analyze furtherly by using a variable study.

  • Understand the probabilities and statistics concepts that are used in Gauge R&R studies.

  • Understand the X̅ and R, and ANOVA methods are based on range and standard deviation approach respectively, and appropriate application for these methods.

  • Plan and conduct the gauge R&R studies for attributes and variables data.

  • Understand the measurement variations for a measurement system.

  • Learn how to estimate the variance components for a gauge R&R study.

  • Understand the attribute study is to ensure the effectiveness of the inspection system.

  • Decide on the acceptance or suitability of a measurement system.

  • Determine which measuring devices can be made more effectively.

  • Avoid any significant measurement error on product acceptance and on control charts and/or process capability studies that will provide validity for statistical control.

  • Apply and interpret the results are obtained from the gauge R&R studies by manually calculation or using Excel program worksheets (Formulas and functions).

  • Use Excel programs worksheets for the gauge R&R studies (easy to validate and understand flow and calculation for the formulas and functions used in the studies).

  • Evaluate deficient gages as opposed to incapable/out-of-control processes (False alarm – Risk of unnecessary action taken on In-control process).

  • Improve equipment maintenance, selection, calibration, and use.

  • Improve the observer’s training and skill (as necessary).

  • Handle the situation during measuring and auditing that related to the measurement system.

Target Audience

The person works related to the measurement system that included the gauges, instruments, and operators in a measurement process. It can serve as a refresher for experienced technicians; or it can be used in orientation for new hires. The persons who have experience and knowledge in GR&R study are encouraged to attend.


Training slides, Programed Excel Worksheets (Based on the formulas and functions) for the Gauge R&R Studies, Review Questions, Exercises, Case Studies, Data Simulation, Q&A and Test Before Training & After Training (This training requires Microsoft Excel Software).

Course Modules

  • Module 1 : Basic Descriptive and Inferential Statistics
  • Module 2 : Probability Distributions Used in Gauge R&R Study
  • Module 3 : Introduction to Gauge R&R Study
  • Module 4 : The Results of Gauge R&R Study
  • Module 5 : Variable X̅ & R Method Study
  • Module 6 : Variable ANOVA (Crossed) Method Study
  • Module 7 : Attribute Study
  • Module 8 : Conducting GR&R Studies by Using Excel (Case Studies)
  • Module 9 : Evaluating the Results from Excel of the Case Studies
  • Module 10 : Review Questions
  • Module 11 : Appendix
  • Module 12 : References

Get To Know The Trainer

Trainer Ng


Dr Ng is a qualified trainer registered with PSMB. He has been in Metrology career since 1991, he is a PhD holder in Business (Sunway University), doing research by using Applied Statistics, Master of Science in Statistics (UM), BSc in Chemistry (UM) and also holds his EC Part II in Electrical and Electronic (UK), having Professional Certification from America Society for Quality for: Certified Quality Engineer (CQE), Certified Quality Auditor (CQA), Certified Quality Inspector (CQI), Certified Quality Improvement Associate (CQIA), Certified Calibration Technician (CCT) and Certified Six Sigma Green Belt (CSSGB). His multi-disciplinary educational background enabled him to create the essence of the company’s core technologies.

Chat with us LIVE to get a






RRP RM3,060/DAY   SAVE RM920

*T&C Applies


No review yet.

Courses you may like


Kindly sign-up or log-in to get access.


Login with your social account


Don’t have an account with us?


Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account


By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?