1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Dismiss Notice
You must be a registered member in order to post messages and view/download attached files in this forum.
Click here to register.

Sampling Plan for AQL less than 0.01%

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

  1. Pongsakorn

    Pongsakorn Active Member

    Joined:
    Aug 10, 2015
    Messages:
    72
    Likes Received:
    16
    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.
     
    Pongsakorn, Sep 11, 2018
    #1
  2. hogheavenfarm

    hogheavenfarm Well-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 -
     
    hogheavenfarm, Sep 12, 2018
    #2
    Pongsakorn likes this.
  3. Pongsakorn

    Pongsakorn Active Member

    Joined:
    Aug 10, 2015
    Messages:
    72
    Likes Received:
    16
    Trophy Points:
    7
    Thanks, I will.
     
    Pongsakorn, Sep 13, 2018
    #3
  4. Bev D

    Bev D Moderator Staff Member

    Joined:
    Jul 30, 2015
    Messages:
    606
    Likes Received:
    664
    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
     
    Bev D, Sep 13, 2018
    #4
    ncwalker and Atul Khandekar like this.