Learn how to use Claude AI to perform a full Statistical Process Control (SPC) and Process Capability analysis — from raw data to a formatted Excel report — in a single conversation.
In this 9-minute tutorial, we work through a real PCB (Printed Circuit Board) thickness dataset and cover every step of a professional SPC study.
WHAT YOU’LL LEARN
- How to load and understand measurement data in Claude
- Building X-bar and Range (R) control charts from scratch
- Calculating control limits using SPC constants (A2, D3, D4, d2)
- Identifying out-of-control points on both charts
- Iterative removal of OOC subgroups with recalculated limits at each step
- Computing process capability indices — Cp, Cpu, Cpl, and Cpk
- Interpreting Cpk results against specification limits
- Exporting everything to a professional Excel workbook with embedded charts
Related videos: (1) Statistical Process Control (2) Process Capability Analysis
Leave a Reply