How Do I Create U-Charts in Excel Using SigmaXL?

img

U-Charts

  1. Open Attribute Data U Chart Defects.xlsx. U Charts (for Defects) can have fixed or varying subgroup sizes.
  2. Select SigmaXL > Control Charts > Attribute Charts> U. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
  3. Select Defects, click Numeric Data Variable (Y) >>. Select N, click Subgroup Column or Size >>. Check Tests for Special Causes.
  4. img
  5. Click OK. The resulting U-Chart is shown:
  6. img

    This is a stable process, with no tests for special causes flagged.

Define, Measure, Analyze, Improve, Control

img

Simulate, Optimize, Realize

img