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
Lecture 7 Download Course Slides
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