I have been working on a spread sheet on quality control for telecommunican technicians.
I am stumped on one or two things. I am trying to get a % of failure according to the work that has successfully completed according to what was QC'd and what failed. Is there such a way? Or formula? And would it be fair to evaluate them on such a equation?

Example:
Joe completes 25 jobs successfully. Quality control evaluates 32% of that work. Joe fails 5 of that 32%.. What can I base his failure % on?


I have attached the spread sheet to help in the matter... The column I need help with is P (QC failure % by Tech)

I have a feeling I can't do it based on the information provided.

Thanks in advanced

Sorry I forgot the attachment

Quote:

---

Originally Posted by Berk21

I have been working on a spread sheet on quality control for telecommunican technicians.
I am stumped on one or two things. I am trying to get a % of failure according to the work that has successfully completed according to what was QC'd and what failed. Is there such a way? or formula? And would it be fair to evaluate them on such a equation?

Example:
Joe completes 25 jobs successfully. Quality control evaluates 32% of that work. Joe fails 5 of that 32%..What can I base his failure % on??


I have attached the spread sheet to help in the matter...The column I need help with is P (QC failure % by Tech)

I have a feeling I can't do it based on the information provided.

Thanks in advanced

---

Having problems uploading excel file.

Do you mean:

1) Joe completes 25 jobs successfully.
2) QC evaluates 8 of the jobs
3) Joe fails in 5 of the 8 jobs
?

Because then I would look at things such as mean and variance to judge if this sample of 8 has 5 failures by chance or if Joe generally fails over half of his jobs.