Calculating Sample Size for very low AQL

N

nate_9

#1
Hi,

This is my first time posting in the cove. I have a unique situation where my AQL is 0.002% and I am trying to calculate a sampling size from a lot which is above 500,000 cups. My Ac and Re will be 0 and 1, respectively (since these numbers cannot go below anymore). I do not want to do 100% inspection and the Mil-Std-105E's chart does not go below 0.01% on AQL.

Any suggestion on my options? Is Mil-Std-105E the best option?

Thanks
Nate
 
Elsmar Forum Sponsor

apestate

Quite Involved in Discussions
#2
Who set the AQL at .002%?

Also, are you inspecting all features or certain critical ones? Are there variables data or is it all attributes?

Is there anyone demanding that you do acceptance sampling instead of other tools that maybe don't rely on inspection to provide quality?
 

Bev D

Heretical Statistician
Staff member
Super Moderator
#3
well your sample size is pretty large (~2560, but I dont' have my all my spreadsheets so I could be wrong) however it wil lbe pretty large.

20 ppm is really small for categorical data plans. will your customer accept other approaches such as continuous data sampling coupled with SPC or perhaps mistake proofing? inspecting for this quality level is not a good approach.
 

Statistical Steven

Statistician
Staff member
Super Moderator
#4
Bev...2543 to be exact :)

I am also weary of such large sample sizes since attribute sampling plans are not very effective (i.e. inspector fatigue, etc.). Reducing the sample size to 500 still gives you an AQL of 0.01%
 
N

nate_9

#5
Thanks for all the suggestions so far.

The situation is like this:-

We are planning to modify our product to contain more volume of liquid. However by doing this, we may jeopardize the seal integrity of the package, potentially inviting more consumer complaints relating to leaking product. A trial has already been ran with a lot size of 500,000 containers, but waiting on sampling and testing.

Our current product (control) has a historical leaking defect rate of 0.002% (1 defect per 50,000 containers), which I am considering as the AQL for the above product. My approach to this situation is to compare the new product with the existing and measure pass / fail by attribute sampling. I do not know if this is the best approach.

Bev / Steve, how did you calculate '2543' as the sample size? Talking about inspector fatigue and other issue with testing this sample size, I do not think will be an issue since our containers are small enough that we can test ~200 cups in 2 minutes under a vacuum chamber.

More clarification / suggestions are appreciated.
 

Statistical Steven

Statistician
Staff member
Super Moderator
#6
Thanks for all the suggestions so far.

Our current product (control) has a historical leaking defect rate of 0.002% (1 defect per 50,000 containers), which I am considering as the AQL for the above product. My approach to this situation is to compare the new product with the existing and measure pass / fail by attribute sampling. I do not know if this is the best approach.
The AQL does not always equal the defect rate of the "control" product. You have to ask what is the maximum defective that the customer finds acceptable.

Bev / Steve, how did you calculate '2543' as the sample size? Talking about inspector fatigue and other issue with testing this sample size, I do not think will be an issue since our containers are small enough that we can test ~200 cups in 2 minutes under a vacuum chamber.

More clarification / suggestions are appreciated.
Solve the binomial equation for n setting alpha equal to 0.05 and p=0.00002 (0.002%) with c=0.
 

Bev D

Heretical Statistician
Staff member
Super Moderator
#7
a clarification question: are you looking for the sample size for qulaifyign that the new process is no more defective than the old process? (a one time event)

or are you looking for the proper sample size for release testing of the new process (an ongoing, lot to lot process)

these are two different things and will yield two different answers...


Steven - that goodness I can still math in my head!
 
N

nate_9

#8
Bev,

I am looking for the sample size for qualifying that the new process is no more defective than the old process.

Thanks
Nate
 

Bev D

Heretical Statistician
Staff member
Super Moderator
#9
OK now that's a different question!

first you don't use an AQL for this.

If the current process has a defect rate of .002% you have a major issue with sample size.
I can run some numbers tomorrow for you but I'd like to know what difference you'd like to accept as NOT OK. (and it can't be >0, the math won't work)
 
N

nate_9

#10
Bev,

I was thinking on the same line that AQL may not be the right approach to take for this situation.

I would like to keep my Not OK number to be >1. Let me know if this works. Appreciate your help on this.
 
Thread starter Similar threads Forum Replies Date
M Calculating Cpk when sample size equals to 1 Capability, Accuracy and Stability - Processes, Machines, etc. 12
M Calculating Adequate Receiving Inspection Sample Size Statistical Analysis Tools, Techniques and SPC 2
I AQL Formula in Excel - Calculating Sample Size based on an AQL Chart AQL - Acceptable Quality Level 8
P Calculating Confidence Level and AQL with Increased Sample Size Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
S Calculating an AQL given a sample size, accept/reject numbers, and lot size AQL - Acceptable Quality Level 2
S Calculating Standard Error for a percentage (binary question) from a sample survey Statistical Analysis Tools, Techniques and SPC 1
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
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 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

Similar threads

Top Bottom