Re: OC curve for multiple sampling plan in Excel

Hallo David,

Thank you for answer!
I want to ask about OC curve, which is used in quality control. The OC
curve is different, depending on the sampling plan (single/double/
multiple).
Maybe, i have to ask in misc.industry.quality group.

Best Regards
tony


On May 30, 11:11 am, dkw <dwinsem...@xxxxxxxxxxx> wrote:
On May 29, 4:47 pm, tony <ang...@xxxxxxx> wrote:

Hallo,

I have to createOCcurvefor multiple sampling plan in Excel, but i
dont know how.
I know, that I have to use the BINOMDIST function, but I dont know how
to calculate theOCcurvefor second, third, fourth and fifth sampling.
(The multiple sampling plan has 5 steps)

I did not know what you meant by anOCcurvebecause I am more
familiar with the acronym ROC. (It also is a bit mysterious what you
are doing with "second, third, fourth and fifth samplings". That might
need more detail to get a substantive reply.)

I found several worked examples with a web search on "ROCcurve" +
excel. As an example: <http://www.anaesthetist.com/mnm/stats/roc/
Findex.htm> If you are unenlightened after examining further results
of such a search, you could explain the source of your dissatisfaction
here or in a group whose users are more likely to be using Excel, such
as microsoft.public.excel.misc.

--
David Winsemius


.