Back to homepage Contact us  
List of training courses View trainer's profile

Course Details

- - Gauge Repeatability and Reproducibility (GR&R)
(Using Microsoft® Excel)
"Today common spreadsheet software allows you to construct SPC charts in a fast & easy manner with just a few clicks of a button on the computer keyboard. It improves accuracy and remove the hassles of re-calculations. So that participants like you can spend more productive time analyzing what your data is telling you about the process/trends in order to take the correct next-step actions. These are some advantages this course has over traditional SPC course."

To improve a business process, the process must be measureable, and the key to that measurement is a reliable and accurate measurement system. Measurement System Analysis (or MSA) is a study that evaluates a measurement system for an improvement project's critical-to-quality characteristic, and Gauge Repeatability and Reproducibility (GR&R) studies is used to quantify the precision of a measurement system.

This training program is a follow-up from SPC level 1 training program. Participants should have taken SPC level 1 course first before taking this course.

Quality professionals know that measuring manufactured products is critical to maintaining the customer specification. They also know that measuring products is necessary for statistical process control systems designed to improve the manufacturing process itself. It should not be forgotten that the data is only worthwhile if the measurement system itself is adequate. A proper GR&R study will tell engineers/managers if the measurement system is accepatble for its intended use. The GR&R study also shows which part of the mesaurement system (e.g. the product itself, the appraiser taking the measurements, and equipment used to perform the measurement) is contributing the most to the variation of the measurements and helps engineers/managers plan improvements to the system.

This is a more advanced Statistical Process Control (SPC) course. It helps engineers/managers to gain an in-depth understanding of their measurement process. This includes common MSA terms like precision, accuracy, bias, linearity and stability, and also the specific steps to take to complete a GR&R study.  This training program is a must for those embarking on LEAN SIX SIGMA initiatives and who are serious about advancing their Measurement System Analysis techniques and skills.


NOTE: Value-add MS Excel working templates will be given to participants in this course. These working templates can save participants hundreds of hours in calculations, constructing charts and building tables. Participants should bring their own laptop (loaded with MS Excel, version 2007 onwards) to the class for hands-on practices.



At the end of the course, participants will be able to:
  • Describe the overall concepts, principles and methods of "Measurement System Analysis (MSA)"
  • Define the different sources of variation present in a measurement system.
  • Define precision, accuracy, bias, linearity, and stability; and describe how the terms are applied
  • Describe how and why GR&R studies are used.
  • Set up data collection plan and perform GR&R studies for Variable Gage using:
    - Average & Range Control Chart method and Tabular method
    - Analysis of Variance (ANOVA) method
  • Set up data collection plan and perform MSA for Attribute Gage using:
    - Tabular (Kappa) method
  • Decide whether a measurement system is capable for it intended use.
  • Take positive actions to improve the measurement process.
  • Use MS Excel templates to conduct GR&R studies using own data from the workplace.


In order to maximize the participants' learning and retention, this course uses the following methods:
  • Real work case studies & Small Group Activities
  • GR&R data tabulation and charting simulations
  • Hands-on data analysis using MS Excel
who should attend:
  • Operation Managers, QA/Process Engineers, Six Sigma & LEAN Project Team Leaders, Technical and Quality Control personnels who have completed SPC-Level1 course.
course contents:

Introduction to MS Excel Statistical Calculations, Data Analysis & Charting Techniques:

  • Using MS Excel to construct tables and control chart fast and accurately.
  • Using MS Excel to compute stastical calculations.

Revision Xbar-R Control Charting (from SPC1 course)

  • Types of Data: Variables & Attributes
  • Types for control charts and how to select the correct chart.
  • How to construct Xbar-R chart fast using MS Excel
  • How to interpret for statistical 'in-control' stability
  • Case study: Process control using Xbar-R charts.

Revision: Concluding Experiments Using Hypothesis Testings Techniques

  • How to run a scientific experiment and conclude an experiment.
  • Statistical inferences for optimization and reduced variability:
    - Fundamental & Setting up Statistical Hypothesis Testing procedure
    - Comparison test (one-sample and two-samples)
    o. Z-test, t-test
    o. F-test
    - Multiple sample comparison: Analysis of Variance (ANOVA)
    o. ANOVA single-factor
    o. ANOVA two-factor

  • Normality test
  • Case study: ANOVA 1-factor & 2-factor experiments

Introduction to Measurement System Analysis (MSA)

  • What is MSA? Why MSA?
  • Concept, Principles and Usage of MSA
  • How to run a MSA experiment?
  • Measurement System Characteristics:
    - Determining Accuracy: Bias and Linearity
    - Determining Stability
    - Determining Precision: Repeatability & Reproducibility
  • Case study: Running Bias and Linearity study

MSA For Variable Data

  • What is Gauge Repeatability and Reproducibility (GR&R) study?
  • Preparing data for variable GR&R study.
  • Tabulation and calculations for Variable Gauges
  • Bias & Linearity study
  • Using AVerage & Range Method
  • Using ANOVA Method
  • Acceptance Criteria and Steps.
  • Case study: Using MS Excel to create and analyze variable MSA numerical and graphical results

MSA for Attribute Data

  • Preparing data for Attribute MSA study.
  • Tabulation and calculations for Attribute Gages
  • Acceptance Criteria and Steps
  • Case study: Using MS Excel to create and analyze Attribute MSA numerical results

Practical Procedures

  • Real work case studies
  • Conducting GR&R study using own data from the workplace
  • Hands-on data analysis using MS Excel templates.


1). Participants should have prior MS Excel spreadsheet skills (e.g. using formula, create tables, edit graphs, etc) & have attended Statistical Process Control - Level 1 (SPC1) course before attending this more advance course..

2). Participants should bring their own laptop (preloaded with MS Excel 2007 or above licensed software) to the training class. Value-Added MS Excel working templates will be provided for participants to practice hands-on.

administrative details :
Duration : 2 days
Time : 9.00am - 5.00pm
Venue : In-house or public program
Language medium : English
Trainer :
Nelson Kok (please click here to see trainer's profile)

Click on the above banner to find out more about other Accelerated Learning Courses
Home | Courses | Trainer Profile | Testimonials | Contact Us
Train for Personal Effectiveness and Organizational Growth
2014, All Rights Reserved.