Quality Management – Statistical Process Control in Excel

Statistical process control and control charts are an important part of operations management.  For years, these tools have been used in all kinds of industries including healthcare, manufacturing, software development finance and Human Resources. With the increasing accessibility and the increasing demand for data analysis and data-based decision making, control charting is an important tool to be able to create, understand and apply.

This course will walk through the fundamentals of what control charts are, what insights can be gathered from them and how different control charts can be used to answered different strategic and operational questions.

Each module features several lectures, downloadable lecture files and a quiz to test your learning.

Additionally, The course features an entire module tackling specific real-world cases for using control charts and statistical process control.

Topics covered include:

Module 1:

The history of statistical process control (SPC) and control charting

Parts of a control chart

Advantages of using control charts

Types of control charts (I chart, U chart, P chart, etc.)

Module 2:

Key assumptions

Change in mean signals

External influence signals

Change in process stability/capability signals

Module 3:

Exercises for building individual range charts

Exercises for building moving range charts

Exercises for building P charts

Exercises for building U charts

Module 4:

Applying control charts to hospital wait times

Applying control charts to manufacturing process control

Applying control charts to A/B testing in software development

Applying control charts to an inspection process

Module 5:

Control Chart Case Examples