Home / Statistical Tools / Analysis Tools / Capability Scorecard / Examples / 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

Download CapabilityScorecard_RequiredOnly.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.

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

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

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

2. Select your data

   Select cells A1:B6 (the header row plus all 5 data rows).

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