Excel: Statistical Process Control

Excel: Statistical Process Control

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 14m | 150 MB

Learn how to analyze the accuracy and alignment of manufacturing processes using statistical tools. Veteran Excel trainer Curt Frye covers the three types of charts-P charts, C charts, and X-bar R charts-that are used to summarize the most common process metrics: proportion of defective output, number of defects, and variability of process outputs. He shows how to perform the analysis, plot the data, and interpret the results of each technique. He also how to examine processes from the customer’s perspective using process capability analysis. Business analysts and support staff who help prepare documents, as well as executives and senior managers who might not have a statistical background, will use the skills in this course to analyze their organizations’ processes and output.

Topics include:

  • Performing statistical analysis
  • Analyzing with P charts
  • Creating a modified P chart
  • Analyzing defects with C charts
  • Analyzing variables with X-bar R charts
  • Performing process capability analysis
Table of Contents

Introduction
1 Welcome
2 What you should know
3 Welcome
4 What you should know

Performing Statistical Analysis
5 Statistical process control
6 The normal distribution
7 Calculate means and standard deviations
8 The normal distribution

Analyzing Defective Output Using P Charts
9 When to use a P chart
10 Calculate the mean and standard deviation of proportion data
11 Plot and interpret trial data using a P chart
12 Create a modified P chart

Analyzing Defects Using C Charts
13 When to use a C chart
14 Calculate the mean and standard deviation of defect count data
15 Plot and interpret trial data using a C chart

Analyzing Variables Using X-Bar R Charts
16 When to use an X-bar R chart
17 Calculate averages and ranges for X-bar R charts
18 Plot and interpret trial data using an X-bar R chart

Performing Process Capability Analysis
19 Process capability analysis
20 Calculate the process capability ratio
21 Calculate the process capability index

Conclusion
22 Further resources