Statistical process control (SPC) involves using statistics - numbers and data - to measure and control the quality of a process. In this workshop, which includes numerous hands-on activities, you'll learn how to use Excel to perform basic SPC calculations and create histograms, run charts, control charts, and Pareto charts.
Intended audience: Individuals in manufacturing and quality roles who have existing knowledge of mathematics for manufacturing, quality tools, including histograms, control charts, and Pareto charts, and quality concepts. Participants should also be comfortable working in Excel and know how to do the following in Excel: navigate the interface, create formulas and use built-in functions to perform calculations, and organize and format data.
NOTE: This course requires a computer with Excel 2016 for each participant.
You Will Learn
- Calculate measures of central tendency and variability in Excel
- Create a histogram in Excel
- Create a run chart in Excel
- Create an Xbar & R chart in Excel
- Create a Pareto chart in Excel