Skip to content

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

Required Only

Only the Units and Defects columns are required. When you don't select an Opportunities column, it defaults to 1 per unit (making DPO equal to DPU). When you don't select a Name column, rows are labeled with numbers (1, 2, 3...).

Goal

Create a capability scorecard with minimal data: just units inspected and defects found.

Sample Data

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

Units Defects
200 15
350 8
150 22
400 5
275 12

Each row represents one batch or process. Only the number of units inspected and defects found are provided.

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:B6 (the header row plus all 5 data rows).

  4. Configure the analysis

    In the Capability Scorecard dialog:

    • Number of Units: Select "Units"
    • Number of Defects: Select "Defects"
    • Number of Opportunities: Leave unselected
    • Name: Leave unselected

    Click Finish to generate the scorecard.

Result

Quantum XL creates a capability scorecard where:

  • The Name column shows row numbers (1, 2, 3, 4, 5) since no Name column was selected
  • Number of Opportunities defaults to 1 for every row, so Total Opportunities equals the number of units
  • DPO equals DPU for every row because there is only 1 opportunity per unit

The two Pareto charts still appear, ranking the rows by DPU and DPMO. Row 3 (150 units, 22 defects) has the highest defect rate.