# AQL Sampling Tables in Excel

## Acceptable Quality Level | Zero-Based Sampling

**Acceptable Quality Level (AQL)** is the maximum percent defective (or maximum number of defects per 100 units) that can be considered acceptable. AQL is measured in *defects per 100 units*.

To calculate sample size using AQL, you need to know if you are using the standard AQL table or Zero-Based Sampling tables. You will also need to know:

- Lot or Batch Size of incoming or outgoing product
- Acceptable Quality Level (AQL qual to 1 is standard. This means 1 defect per 100 units or 1%.
- Inspection Level (I, II, III - usually level II)

### QI Macros Statistical Software for Excel Contains AQL Sampling Tables

QI Macros * AQL Sampling Table* helps determine acceptance sampling for incoming materials and products.

To access the tables, click on QI Macros menu, select the Calculators drop-down found in the Templates for Lean Six Sigma portion of the software, and then open **Sample Size Calculator**.

Choose from either** AQL Acceptance Table (Single Sampling)** or **AQL Zero-Based Acceptance Table**.

*AQL Acceptance Table*

*AQL Acceptance Table*

QI Macros template has pull down menus for each variable. Just click on each cell in column B to access the menus.

**Step 1 - Select the lot or batch size** by clicking on cell B3 and then the pull-down menu**.**

**
**

**Step 2 - Set the AQL Level **(typically 1, but can vary**)** by clicking on cell B4 and then the pull-down menu.

**Step 3 - Set the Inspection Level** (typically II) in cell B5.

**NOTE:** *ALWAYS use the click-able, pull-down menus when entering your Lot, AQL, and Inspection Level.*

The template will look up the Sample Size (5) and accept/reject levels (0/1) from the AQL Table. The lot size and inspection level give the letter code "C" which gives a sample size of 5 and accept/reject of 0/1. This means take five samples and if one is defective, reject the lot otherwise accept the lot.

Our reference for the AQL Acceptance Table (Single Sampling) is: **MIL-STD-105E**.

*AQL Zero-Based Acceptance Sampling*

*AQL Zero-Based Acceptance Sampling*

Zero-Based Acceptance Sampling requires that you **accept on zero**; reject on 1.

There is no other option. It's a different table than standard AQL Single Sampling table, which might tell you, in some cases, to accept on 2 and reject on 3 defects.

**Step 1 - Select the lot or batch size** by clicking on the pull-down menu in B3**.
**

**Step 2 - Set the AQL Level **(typically 1, but can vary**)** by clicking on the pull-down menu in B4.

The template will then look up the Sample Size (13), using the AQL level, based on: **MIL-STD-1916**.

**Note:** *Zero-based acceptance sampling gives a higher sample size than the AQL Table, but may require fewer samples than AQL sampling.*

### Why Choose QI Macros Statistical Software for Excel?

### Affordable

- Only
**$299 USD**- less with quantity discounts - No annual fees
- Free Technical Support

### Easy to Use

- Works Right in Excel
- Interprets Results for You
- Accurate Results Without Worry

### Proven and Trusted

- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free