Measurement System Analysis/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

Variance Components 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: