Measurement System Analysis (Msa) Using Microsoft Excel

Understanding the Size and Sources of Variation Within Your Measurement System

What you'll learn

Key MSA Concepts and Terminology

Gage Repeatability and Reproducibility (Gage R&R) Studies

Testing for Linearity

Testing for Measurement Bias

Testing for Stability Over Time

Properties of the Measurement System

Number of Distinct Categories (NDC)

Testing for Variation in Width

The Range Method

The Average and Range Method

The ANOVA Method

Attribute Measurement System Analysis

Complete Set of Downloadable Microsoft Excel Templates

Requirements

Basic understanding of statistics and measurement systems

Description

Measurement System Analysis (MSA) Using Microsoft Excel offers you the comprehensive look at MSA and Gage R&R you need to succeed as a quality professional. Following the guidance of the Automotive Industry Action Group's (AIAG) book by the same title, this course covers all the major topics within the field of measurement systems analysis including:Key Concepts and TerminologyTesting for StabilityTesting for BiasTesting for LinearityGage Repeatability and Reproducibility (GR&R) StudiesThe Range Method, Average & Range Method, and ANOVA Method of Performing GR&R'sNumber of Distinct Categories (NDC)How Hypothesis Testing is Used within MSAMeasurement Error Types and their Effect on Process CapabilityAttribute Measurement StudiesAnd MUCH MORE!!!Not only do we cover every major MSA topics needed by today's quality professional, but we do it within the context of Microsoft Excel. We show you theories and formulas, explain and illustrate all the concepts, and then build our studies within Excel. We've also include the Excel templates as part of this class so you can download them and use them on the measurement problems at your workplace. So if you are looking to master that next technical skills within the quality profession, then this is the class for you!! Taught by manufacturing and quality professionals, this is far more than an "academic" look at the topic. Instead, everything taught in this class can be immediately applied in the workplace without a lot of excess "fluff".Now it's time to sign up and start learning your next career skill!!

Overview

Section 1: Introduction

Lecture 1 Introduction to the MSA Course

Lecture 2 Introduction to MSA

Lecture 3 Understanding Hypothesis Testing

Lecture 4 Using Judgement

Lecture 5 Detailed Class Agenda

Lecture 6 Key MSA Concepts and Terminology, Pt 1

Lecture 7 Key MSA Concepts and Terminology, Pt 2

Lecture 8 Number of Distinct Categories (NDC)

Lecture 9 Effects of Measurement System Discrimination

Lecture 10 Properties of a Measurement System

Lecture 11 Effects of Measurement System Variability

Lecture 12 Measurement System Philosophy and Errors

Lecture 13 Measurement Error and Cp

Lecture 14 Testing for Stability

Lecture 15 Testing for Bias

Lecture 16 Testing for Linearity

Lecture 17 Testing for Variation in Width

Lecture 18 The Range Method

Lecture 19 The Average and Range Method

Lecture 20 The ANOVA Method

Lecture 21 Attribute Measurement Systems

Lecture 22 MSA Microsoft Excel Templates

Lecture 23 Closing Comments and References

Lecture 24 Conclusion to the MSA Course

Lecture 25 Bonus Lecture

Quality Engineers,Quality Technicians,Quality Managers,Process Engineers and Process Technicians,Manufacturing Professionals