Overview
-
Learn statistical process control techniques for Microsoft Excel. Learn how to build P charts, C charts, and X-bar R charts to measure the quality of manufacturing processes.
Syllabus
-
Introduction
- Welcome
- What you should know
- Statistical process control
- The normal distribution
- Calculate means and standard deviations
- When to use a P chart
- Calculate the mean and standard deviation of proportion data
- Plot and interpret trial data using a P chart
- Create a modified P chart
- When to use a C chart
- Calculate the mean and standard deviation of defect count data
- Plot and interpret trial data using a C chart
- When to use an X-bar R chart
- Calculate averages and ranges for X-bar R charts
- Plot and interpret trial data using an X-bar R chart
- Process capability analysis
- Calculate the process capability ratio
- Calculate the process capability index
- Further resources
