NP Charts

img

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


NP-Charts


  1. Open Attribute Data NP Chart Defectives.xlsx. The subgroup size is constant at 50. NP Charts (for Defectives) require a fixed subgroup size.

  2. Select SigmaXL > Control Charts > Attribute Charts> NP. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.

  3. Select Defectives, click Numeric Data Variable (Y) >>; enter 50 for Enter Subgroup Size. Check Tests for Special Causes.


    SigmaXL nP-Chart Options



  4. Click OK. The resulting NP-Chart is shown:

  5. nP-Chart in Excel

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

Define, Measure, Analyze, Improve, Control

img

Simulate, Optimize, Realize

img