Statistical Process Control (SPC) Using Microsoft Excel
What you'll learn
- Statistical Process Control
- Pareto Analysis
- Control Charting
- Process Capability Analysis
- Regression Analysis
- Quality Engineering Statistics
- Analytical problem solving methods
- How SPC is a key component in the product design and manufacturing processes
- Manufacturing background is helpful
- Microsoft Excel experience is helpful
Statistical Process Control (SPC) Using Microsoft Excel is the one course you need to learn how to harness, analyze and report your manufacturing process data in a way that drives improvement within your organization. This course is divided into 4 major sections:
Basic Statistical Concepts: Don't worry if you've never studied statistics or are a novice using Excel. This course starts at the beginning. In this section, I explain fundamental concepts that you will use throughout this course and your career including Measures of Central Tendency, Measures of Dispersion and the different types and scales of data. Not only do I explain these concepts "on paper", but I'll take you into Excel and show you how to QUICKLY calculate the statistics you need.
Pareto Analysis: Most people do not realize the power of the Pareto Distribution. In this section, I will show you how to apply the so called "80/20 Rule" in remarkably expedient and innovative ways. I will also introduce you to Excel's Pivot Tables, which when combined with Pareto Analysis, form a powerful decision making tool for allocating your organization's capital, people and improvement effort.
Control Charting: Often considered the backbone of statistical process control, control charting allows you to graphically depict and then analyze your process and quality data. Control charting calculates the normal limits for any process, then makes obvious the trends and nuances in your process. Not only will I explain the "nut and bolts" of 7 different control charts for both variable and attribute data, but I will also walk you through the secrets of interpreting their results. You will also receive excellent reference tools and Excel reports you can use in your own improvement projects.