Lead Forensics

Basic Statistical Process Control in Excel

Download PDF June 9, 2017 Staybridge Suites
3252 Cassopolis Street
Elkhart, IN 46514
1:00 PM - 5:00 PM EST 99 Tuesday, June 6 This registration is closed.
If you are interested in future workshop dates, please click the Submit Event Request link below.

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

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. NOTE: This course requires a computer with Excel 2016 for each participant.

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

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.