Skip to content

Home / Statistical Tools / Analysis Tools / Capability Scorecard / Examples / Examples

Examples

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

Download CapabilityScorecard_QuickStart.xlsx

Excel Protected View

When you open downloaded files, Excel displays a Protected View warning. You must click Enable Editing before you can use Quantum XL with the file.

Excel Protected View warning

Alternatively, you can copy the sample data from the table below and paste it directly into a new Excel workbook.

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. Launch the analysis

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

  2. Select your data

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

  3. 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