Double-sided (USL, LSL) Variables sampling plan Z1.9 - Use in Excel spreadsheet?

tdickson · Jun 5, 2009

I would like to implement a double-sided (USL, LSL) sampling plan where variation is unknown (also willing to use a plan where variation is known, either way). (n=15, Code G...) I would like to use Excel to calculate the estimate of lot percent over LSL and under LSL so that we don't have to use a lookup table or statistics software. Can anybody show me how this can be done? Thanks!

brahmaiah · Jun 6, 2009

Re: Variable sampling plan Z1.9 - Use in Excel spreadsheet?

tdickson said:
I would like to implement a double-sided (USL, LSL) sampling plan where variation is unknown (also willing to use a plan where variation is known, either way). (n=15, Code G...) I would like to use Excel to calculate the estimate of lot percent over LSL and under LSL so that we don't have to use a lookup table or statistics software. Can anybody show me how this can be done? Thanks!

My advice is donot do any short cut with sampling tables. It may not be acceptable by auditors unless the short cut method is approved in procedures.
v.j.brahmaiah :agree:

tdickson · Jun 7, 2009

Re: Variable sampling plan Z1.9 - Use in Excel spreadsheet?

We will be sure to implement this in an auditor-friendly way if we do at all. The choice of sample size n is per the standard, etc. It would be convenient to be able to have our spreadsheet spit out the Lot percent defective above USL and below LSL. We would certainly validate correct operation before implementation.

Double-sided (USL, LSL) Variables sampling plan Z1.9 - Use in Excel spreadsheet?

tdickson

brahmaiah

tdickson

Similar threads