Excel: Statistical Process Control

Learn statistical process control techniques for Microsoft Excel. Learn how to build P charts, C charts, and X-bar R charts to measure the quality of manufacturing processes.

Introduction

• Welcome
• What you should know

1. Performing Statistical Analysis

• Statistical process control
• The normal distribution
• Calculate means and standard deviations

2. Analyzing Defective Output Using P Charts

• When to use a P chart
• Calculate the mean and standard deviation of proportion data
• Plot and interpret trial data using a P chart
• Create a modified P chart

3. Analyzing Defects Using C Charts

• When to use a C chart
• Calculate the mean and standard deviation of defect count data
• Plot and interpret trial data using a C chart

4. Analyzing Variables Using X-Bar R Charts

• When to use an X-bar R chart
• Calculate averages and ranges for X-bar R charts
• Plot and interpret trial data using an X-bar R chart

5. Performing Process Capability Analysis

• Process capability analysis
• Calculate the process capability ratio
• Calculate the process capability index

Conclusion

• Further resources