# Sampling Plan for AQL less than 0.01%

Discussion in 'Sampling, Standards and Inspection' started by Pongsakorn, Sep 11, 2018.

1. ### PongsakornActive Member

Joined:
Aug 10, 2015
Messages:
66
Likes Received:
15
Trophy Points:
7
I did sampling 2,140 units from 116,000 units for inspection, I know that this sample size is tighter than AQL 0.01% but customer need to know the exact AQL level for this sample size, please advise how to know the exact AQL level for Sample Size 2,140 units from lot size 116,000 units.

Please advise, this is quite urgent. Thanks.

2. ### hogheavenfarmWell-Known Member

Joined:
Jul 30, 2015
Messages:
220
Likes Received:
160
Trophy Points:
42
try elsmar.com Pongsakorn, maybe all the statistical magi are over there -

Pongsakorn likes this.
3. ### PongsakornActive Member

Joined:
Aug 10, 2015
Messages:
66
Likes Received:
15
Trophy Points:
7
Thanks, I will.

4. ### Bev DModeratorStaff Member

Joined:
Jul 30, 2015
Messages:
543
Likes Received:
602
Trophy Points:
92
Location:
Maine
Use EXCEL
P(A) = BINOMDIST(c,n,p,TRUE)
iterate p to get the answer for the Probability level you are using . typically AQL is 95%
c= the accept number
p = defect rate
n = sample size.
the lot size is not relative

when you use c=0, the defect rate for a sample size of 2,140 and a 95% probability of accepting the defect rate you get an AQL (p_AQL) of .000025

ncwalker and Atul Khandekar like this.