Calculating an AQL given a sample size, accept/reject numbers, and lot size

S

seve00

#1
How do I calculate AQL given a sample size, accept/reject numbers, and lot size?

The company I work for manufactures suspension assemblies for hard drives. We employ a 0.10 AQL sample plan for lot sizes 3201 - 10,000 for critical attribute defects (c = 0, n = 125) and, for cosmetic defects, the acceptance number is 2 (using the same 125 pc sample). This is not a standardized AQL based on the ANSI Z-1.4 standard and I would like to convert the plan used for cosmetic defects into an AQL. Any suggestions on how I can do this?
 
Elsmar Forum Sponsor

Tim Folkerts

Super Moderator
#2
Re: Calculating an AQL

You could use the the binomial distribution to "work backwards" to see what sort of defect rates would create such a sampling plan. (I posted a spreadsheet here: Sampling Spreadsheet to help determine the sample size for sampling plans that can help with the calculations).

Playing around with the numbers, I found that if you take a typical definition that AQL = "lots with this defect rate will be accepted 95% of the time", then for:

  • c=0 for 125 pieces ==> AQL = 0.04
  • c=2 for 125 pieces ==> AQL = 0.6
I should point out the the standard tables do no specifically try to meet the "will be accepted 95% of the time". It can be well below or well above 95% in the actual plans. So there is no way to definitive way to say what the AQL is if the plan is not on the tables.

Tim F
 
M

meongroup

#3
It would benefit you to actually plot the Operating Characteristic (OC) for a few sampling plans if you really are unfamiliar with the mechanism for determining AQL from a given sampling plan. All you need is a set of probability tables and some graph paper - and maybe a calculator if you are not to good at basic arithmetic. Doing this for yourself is more informative than simply looking at the curves an a textbook, or perhaps in documents similar to Mil Std 105

The comparison between curve shapes for differing values is also very informative.

Regarding the earlier comparison of C=0 and C= 2; Plotting the curve for each of these plans, on the same sheet, provides a view of the remote end of the curve, what happens when the product quality is actually way off the projected AQL.

Regarding the comment
 
Last edited by a moderator:
Thread starter Similar threads Forum Replies Date
I AQL Formula in Excel - Calculating Sample Size based on an AQL Chart AQL - Acceptable Quality Level 8
N Calculating Sample Size for very low AQL AQL - Acceptable Quality Level 13
P Calculating Confidence Level and AQL with Increased Sample Size Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
M Lean: Conducting Capacity Study, calculating Cycle times on laser cutting machines Lean in Manufacturing and Service Industries 2
A Calculating Carbon Footprint in the Organization Miscellaneous Environmental Standards and EMS Related Discussions 2
C Calculating your KPIs ISO 13485:2016 - Medical Device Quality Management Systems 7
K Calculating Heat Dissipation Manufacturing and Related Processes 1
Q Calculating Defect Rates ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
S Formula for Calculating NoGo Major Diameter for UN gages Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
P Calculating a weight for a machine for the CE label CE Marking (Conformité Européene) / CB Scheme 0
R Remote Support - Calculating Number of Employees IATF 16949 - Automotive Quality Systems Standard 2
G Calculating Tolerance of a Panel Meter with a 2 degrees of an Arc General Measurement Device and Calibration Topics 0
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
V Product Development - When to start calculating Process Capability Capability, Accuracy and Stability - Processes, Machines, etc. 3
J Calculating Reliability for Subsystems in Series Reliability Analysis - Predictions, Testing and Standards 15
Stijloor Calculating (3rd Party) Audit Days for Company with Seasonal Employees General Auditing Discussions 3
T Formulas for Calculating Coefficients for RTD / PRTD Calibration According to ITS-90 General Measurement Device and Calibration Topics 5
J Calculating part variation from historic data for GRR study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
P Purpose of calculating Ta, Tb & R Square in Linearity Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
P Purpose of calculating Uncertainty value in calibration study Measurement Uncertainty (MU) 5
M Calculating MTBF for plug-in PCI cards Reliability Analysis - Predictions, Testing and Standards 2
J Calculating impact force, expressed in lbs, of a 5 lb weight dropped 48 inches Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
M Calculating Cpk when sample size equals to 1 Capability, Accuracy and Stability - Processes, Machines, etc. 12
D Calculating Cpk on Non-Normal Data Distribution Capability, Accuracy and Stability - Processes, Machines, etc. 10
K Calculating Capability of a process when data is skewed in the upper range Capability, Accuracy and Stability - Processes, Machines, etc. 4
A Calculating Accuracy for a Multimeter General Measurement Device and Calibration Topics 1
M Calculating Coefficients for an RTD (Resistance Temperature Detector) Probe General Measurement Device and Calibration Topics 3
T Calculating Plating/Coating Weight for IMDS RoHS, REACH, ELV, IMDS and Restricted Substances 3
D Calculating Lower and Upper 3 Sigma Control Limits Statistical Analysis Tools, Techniques and SPC 2
M Calculating Adequate Receiving Inspection Sample Size Statistical Analysis Tools, Techniques and SPC 2
M Calculating Capability of Delivery Performance Capability, Accuracy and Stability - Processes, Machines, etc. 5
K Advice on Calculating Control Chart Control Limits Statistical Analysis Tools, Techniques and SPC 13
B Calculating Combined DPMO and Sigma Level for Two or More Different Work Areas Six Sigma 3
G Calculating the Fraction Defective Confidence Interval for a Lot Statistical Analysis Tools, Techniques and SPC 2
A Calculating Combined Measurement Uncertainty - VDA 5 Measurement Uncertainty (MU) 1
B Calculating Precision to Tolerance Ratio Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
D DPPM - Calculating the Defect Rate of a Software Test Statistical Analysis Tools, Techniques and SPC 9
L FMEA - Calculating RPN = S*O*D FMEA and Control Plans 3
I Shewhart Constants vs Central Limit Theorem in calculating Control Limits Statistical Analysis Tools, Techniques and SPC 18
B Please share a template for calculating Cp Cpk Document Control Systems, Procedures, Forms and Templates 3
S Is a Stable Process (within Control Limits) required for Calculating Pp, Ppk? Capability, Accuracy and Stability - Processes, Machines, etc. 6
M Calculating the IATF TS 16949 Recertification Audit Man Days - Clarification ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
J IEC60825 - Laser Safety - Calculating Maximum Permissible Exposure Correctly Other ISO and International Standards and European Regulations 1
P Calculating Process Capability from Data of attached spreadsheet Statistical Analysis Tools, Techniques and SPC 4
D Formula for Calculating Warp Measurement of Corrugated Boxes General Measurement Device and Calibration Topics 1
S Need Help Calculating and Implementing Cs - Wright's Index Statistical Analysis Tools, Techniques and SPC 11
S Calculating an Uncertainty Budget for an Optical Comparator General Measurement Device and Calibration Topics 4
D One-Two-Three Sigma Control Limits - Calculating Control Limits for X-bar Charts Statistical Analysis Tools, Techniques and SPC 3
K Calculating (Approximate) Parallelism Inspection, Prints (Drawings), Testing, Sampling and Related Topics 10
S Calculating MTBF (Mean Time Between Failures) for the whole Production Unit Reliability Analysis - Predictions, Testing and Standards 2

Similar threads

Top Bottom