Figuring out a failure rate

Berk21 · #1 Jan 26, 2009, 05:11 PM

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

Berk21 · Jan 26, 2009, 05:12 PM

sorry I forgot the attachment

Berk21 · Jan 26, 2009, 05:17 PM

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.