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

Gage r r

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

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

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

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