# MSA/Gage R&R Options in SPC for Excel

There are numerous features and options in the Measurement Systems Analysis/Gage R&R techniques in SPC for Excel to help you determine how “good” your measurement system is. The ten techniques included in the software are:

• EMP Studies: Consistency Study, Short EMP study, Basic EMP Study
• Gage R&R studies: ANOVA Gage R&R, Average/Range Method, Nested Gage R&R, Type 1 Gage Study and Attribute Gage R&R
• Equivalency of Instruments
• Linearity and Bias Study

See how easy it is to use the software from an example of ANOVA Gage R&R in the video below.

See how to setup the data entry and how to run the analysis to generate a detailed or summary report that includes the ANOVA tables, the operator-part charts, the components of variance chart as well as charts for operator bias and repeatability.  To see the detailed reports with an explanation of each section in the report, select the link(s) below.

EMP Studies

There are three EMP studies included in the software:

• Consistency Study: one operator measuring one part multiple times with the primary purpose of determining the measurement system error
• Short EMP Study: one operator measuring multiple parts multiple times with the primary purpose of determining the measurement system error and how it compares to the total variation in the process
• Basic EMP Study: multiple operators measuring multiple parts multiple times with the primary purpose of determine the repeatability and reproducibility of the measurement system

There are options to allow you to gain many more insights into the measurement system from the EMP studies.  These include adding a historical standard deviation and specifications.  The output can contain the following items:

• Control Charts
• Control chart analysis
• Bias analysis against a standard
• Check to determine if data are chunky
• Degrees of freedom check to ensure there is enough data
• Main effects chart for operator bias
• Mean range chart for operator repeatability
• Calculate test-retest error
• Calculate probable error
• Determine if measurement increment is adequate
• Calculate watershed specifications
• Calculate precision to tolerance ratio
• Calculate overall and product variances
• Calculate Interclass Correlation Coefficient
• Determine the Type of Class Monitor
• Option for detailed report (with or without data table) or summary report

ANOVA Method for Crossed Gage R&R Designs

Designed for multiple operators measuring multiple parts multiple times with the primary purpose of determine the repeatability and reproducibility of the measurement system; output includes:

• ANOVA table with interaction
• ANOVA table without interaction
• % contribution based on variance, standard deviation, tolerance or process standard deviation
• Number of distinct categories
• Variance components chart
• Operator-parts control charts
• ANOM charts for bias and repeatability
• Option to change sigma multiplier
• Option to change p value to remove interaction
• Options to include the following charts:
• Run chart by part
• Run chart by operator
• Scatter plots
• Error charts
• Whiskers charts
• X-Y plots
• Option for detailed report (with or without data table) or summary report

Average/Range Method for Crossed Gage R&R Designs

Designed for multiple operators measuring multiple parts multiple times with the primary purpose of determine the repeatability and reproducibility of the measurement system; output includes:

• % contribution based on variance, standard deviation, tolerance or process standard deviation
• Number of distinct categories
• Variance components chart
• Operator-parts control charts
• ANOM charts for bias and repeatability
• Options to include the following charts:
• Run chart by part
• Run chart by operator
• Scatter plots
• Error charts
• Whiskers charts
• X-Y plots
• Option for detailed report (with or without data table) or summary report

ANOVA Method for Nested Gage R&R Designs

Designed for multiple operators measuring multiple parts multiple times with the primary purpose of determine the repeatability and reproducibility of destructive tests; output includes:

• ANOVA table
• % contribution based on variance, standard deviation, tolerance or process standard deviation
• Number of distinct categories
• Variance components chart
• Operator-parts control charts
• ANOM charts for bias and repeatability
• Option to change sigma multiplier
• Options to include the following charts:
• Run chart by batch(operator)
• Run chart by operator
• Option for detailed report (with or without data table) or summary report

Type 1 Study Method

Designed for a calibrated reference part that  is measured many times within a short period of time to determine the bias and repeatability of a measurement system; output includes:

• Measurement statistics
• Run chart of measurement variation vs tolerance range
• Bias
• Capability Assessment
• Option for data table in report

Attribute Gage R&R Method

Designed for multiple operators measuring multiple parts multiple times with the primary purpose of determine how good a measurement system is for yes/no attribute data; output includes:

• Effectiveness table (attribute Gage R&R report)
• Cross-tabulations
• Kappa values

Equivalency of Instruments

Designed to compare the bias and repeatability of multiple instruments; output includes:

• X-mR charts for each instrument to check consistency
• Mean moving range chart to check for differences in measurement error
• ANOM chart to check for bias
• Bias calculations to recenter the limits
• ANOM chart with limits recentered
• Bias calculations with known standard
• ANOM chart for instrument bias with known standard
• Option to change alpha for the ANOM critical values

Linearity and Bias Study

Designed to determine if a measurement system is linearly across a range of values and if bias exists in the measurement system; output includes:

• Linearity Chart
• Linearity Results
• Bias Results
• Option to add data table in report