Skip to content

Home / Statistical Tools / Analysis Tools / Capability Scorecard / How-To

How-To

Quick Start

Create your first capability scorecard in less than two minutes.

This example shows how to calculate defect rates for a manufacturing process with five steps, using all four column slots: Name, Units, Defects, and Opportunities.

Goal

Calculate DPU, DPO, and DPMO for each process step and identify which step contributes the most defects.

Sample Data

Press Copy for Excel, then paste the table into a blank worksheet.

Process Step Units Defects Opportunities
Cutting 500 12 3
Drilling 500 8 4
Deburring 500 25 2
Assembly 500 5 5
Inspection 500 3 2

Each row represents one process step. Units is the number of parts inspected, Defects is how many defects were found, and Opportunities is the number of ways each unit could be defective at that step.

Steps

  1. Put the data in Excel

    Press Copy for Excel above the table, click cell A1 in a blank worksheet, and press Ctrl+V. The header row lands in row 1 and the 5 data rows in rows 2 through 6.

  2. Launch the analysis

    From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Capability Scorecard.

  3. Select your data

    Select cells A1:D6 (the header row plus all 5 data rows across all four columns).

  4. Configure the analysis

    In the Capability Scorecard dialog:

    • Number of Units: Select "Units"
    • Number of Defects: Select "Defects"
    • Number of Opportunities: Select "Opportunities"
    • Name: Select "Process Step"

    Click Finish to generate the scorecard.

Result

Quantum XL creates a summary table showing each process step's defect metrics:

  • Deburring has the highest DPU (0.050): the most defects per unit
  • DPMO rankings may differ from DPU because they account for the number of opportunities at each step
  • A totals row at the bottom shows the overall defect rates across all steps

Two Pareto charts appear alongside the table (one sorted by DPU and one by DPMO), making it easy to see which steps should be prioritized for improvement.

More Examples

Ready for more? See this variation:

  • Required Only: Minimal setup with just Units and Defects columns
  • GroupBy: A separate scorecard per group, from one run