# Statistical Process Control SPC Bootcamp Excel Minitab

4 Courses in 1 : Statistics Foundation | Control Charts Using Minitab | Using Excel | Process Capability – IATF 16949

4.6/5

## Statistical Process Control SPC Bootcamp Excel Minitab

### What you’ll learn

Basic statistics concepts including probability distributions (Normal, Binomial and Poisson)
Statistical Process Control (SPC): Control Charts + Process Capability Analysis using Excel and Minitab
Most commonly used Control Charts such as I-MR, Xbar-R, Xbar-S, np, p, c, and u chart with a detailed explanation of theory behind these plots
Less commonly used Control Charts such as Pre Control Chart, Short Run Control Chart, Moving Average Control Chart, EWMA and CUSUM Charts are also covered.
Process Capability Analysis – Calculate Cp, Cpk, Pp, Ppk using Excel or Minitab. Non-Normal Distribution is also covered.

### Requirements

This course is from basics to advanced course. Before teaching Control Charts and Process Capability, in this course you will first learn the basics.
Some basic industrial experience will be helpful to fully appreciate the learnings.

### Description

Note: Students who complete this course have an option to apply for the certification exam by Quality Gurus Inc. and can achieve the Verified Certification from Quality Gurus Inc. It is optional and there is no separate fee for that.Statistical Process Control (SPC) is one of the core IATF 16949 tools.To confirm if the process is in statistical control, we use Control Charts.To check if the process is capable of producing output that meets specifications, we perform Process Capability Studies.This course covers both aspects of the Statistical Process Control (SPC): Control charts and Process Capability Studies. This is the basics-to-advanced course on Statistical Process Control (SPC).In fact, this is a 4-in-1 course.Course 1: Statistics Foundation: To understand Control Charts and Process Capability, you need to have a basic understanding of statistical concepts including the probability distributions. Section B of this covers all that you need to understand SPC better.Course 2: Control Charts/Process Capability Using Minitab: Minitab is the most advanced tool used by professionals to plot Control Charts and perform the Process Capability Analysis. Course 3: Control Charts/Process Capability Using Excel: In addition to Minitab, you will understand how to perform all these calculations using Microsoft Excel. Minitab is costly and not everyone might have access to Minitab. Microsoft Excel is widely accessible. In addition, when you perform calculations using Excel, you get a much better understanding of what is happening under the hood.Course 4: Process Capability Analysis: Control Charts just tell if the process is in control or not. To check if the process is capable or not, you need to perform the Process Capability Analysis. This course covers all the calculations using Excel and Minitab.

### Overview

Section 1: Section A: Basics of SPC

Lecture 1 A1 Section and Course Introduction

Lecture 2 A2 What is Quality

Lecture 3 A3 Understanding a Process

Lecture 4 A4 Variation Part 1

Lecture 5 A4 Variation Part 2

Lecture 6 A6 Process Control vs Process Capability

Section 2: Section B – Basics of Statistics

Lecture 8 B1 Basics of Statistics Section Intro

Lecture 9 B2 Data Types

Lecture 10 B3 Central Tendency

Lecture 11 B4 Measurement of Dispersion

Lecture 12 B5 Excel for Data Summary

Lecture 13 B6 Standard Deviation Alternate Approaches

Lecture 14 B7 Plotting Data

Lecture 15 B8 Probability Distributions

Lecture 16 B9 Binomial Theory

Lecture 17 B10 Binomial Calculations

Lecture 18 B11 Poisson Theory

Lecture 19 B12 Poisson Calculations

Lecture 20 B13 Normal Theory

Lecture 21 B14 Normal Tables

Lecture 22 B15 Normal Calculations

Lecture 23 B16 Central Limit Theorem

Lecture 24 B17 Subgroup Size

Lecture 25 B18 Types of Errors

Section 3: Section C: Control Charts

Lecture 26 C1 Control Charts Section Introduction

Lecture 27 C2 Control Limit vs Specification Limit

Lecture 28 C3 Two Phases of Control Charts

Lecture 29 C4 Selecting a Control Chart

Lecture 30 C5 np Chart Theory

Lecture 31 C6 np Chart Using Excel and Minitab

Lecture 32 C7 p Chart Theory

Lecture 33 C8 p Chart Using Excel and Minitab

Lecture 34 C9 c Chart Theory

Lecture 35 C10 c Chart Using Excel and Minitab

Lecture 36 C11 u Chart Theory

Lecture 37 C12 u Chart Using Excel and Minitab

Lecture 38 C13 Xbar R Chart Theory

Lecture 39 C14 Xbar R Chart Using Excel Minitab

Lecture 40 C15 Xbar S Chart Theory

Lecture 41 C16 Xbar S Chart Using Excel Minitab

Lecture 42 C17 I MR Chart Theory

Lecture 43 C18 I-MR Chart Using Excel Minitab

Lecture 44 C19 Nelson Rules Part 1

Lecture 45 C20 Nelson Rules Part 2

Lecture 46 C21 Nelson Rules Part 3

Lecture 47 C22 Pre Control Charts

Lecture 48 C23 Short Run Charts Theory

Lecture 49 C24 Short Run Charts Using Excel Minitab

Lecture 50 C25 EWMA Chart Theory

Lecture 51 C26 EWMA Charts Using Excel Minitab

Lecture 52 C27 CUSUM Theory

Lecture 53 C28 CUSUM Chart Using Excel Minitab

Section 4: Section D: Process Capability Analysis

Lecture 54 D1 Process Capability Section Introduction

Lecture 55 D2 Control Charts and Process Capability

Lecture 56 D3 Control Charts and Histogram

Lecture 57 D4 Process Capability Indices Introduction

Lecture 58 D5 Calculate Cp Using Minitab

Lecture 59 D6 Sigma Within and Overall

Lecture 60 D7 Calculate Cp Using Excel

Lecture 61 D8 The problem with Cp

Lecture 62 D9 Calculating Cpk

Lecture 63 D10 Process Performance Pp Ppk

Lecture 64 D11 Checking Normality

Lecture 65 D12 Normality Test – Excel and Minitab

Lecture 66 D13 Non-Normal Data – Example Part 1

Lecture 67 D14 Non-Normal Data – Example Part 2

Section 5: BONUS

Lecture 68 BONUS LECTURE

Six Sigma Professionals (Green and Black Belts),Quality Engineers,Quality Managers,Quality Technicians,Industrial Engineers

#### Course Information:

Udemy | English | 7h 0m | 2.98 GB
Created by: Sandeep Kumar, ­ Quality Gurus Inc.

You Can See More Courses in the Business >> Greetings from CourseDown.com

Scroll to Top