Basic Statistical Process Control in Excel

Download PDF 99

Can't find a scheduled time that works for you? Submit an event request and we will keep you updated when new times become available.

Submit Event Request

Description

Event Details

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. 

Appropriate For

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.

You Will Learn

Objectives:

  • 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
NIST

Purdue Manufacturing Extension Partnership, 8626 E. 116th Street, Suite 200, Fishers, IN 46038-2815, (317) 275-6810

© 2017 Purdue University | An equal access/equal opportunity university | Copyright Complaints | Maintained by Manufacturing Extension Partnership

Trouble with this page? Disability-related accessibility issue? Please contact Manufacturing Extension Partnership at tapmep@purdue.edu.