View Single Post
  #3  
Old June 2nd, 2010, 02:46 PM posted to microsoft.public.excel.worksheet.functions
Meenie
external usenet poster
 
Posts: 270
Default Need a little math help in making a formula

"rant mode
This is the problem with most statistics gathering, the stat's are gathered,
then the math used suits the desired outcome!
/rant mode "

I agree with that, and dislike stats intensely, lol, but ya gotta give 'em
what they ask for, lol.
--
Meenie


"Meenie" wrote:

I have an audit and am looking for a specific item in the audit.
I'm asking a specific question and the answer can be either Yes, No or N/A.
To figure out the compliance to the question as a percentage, I'm taking the
number of "Yes + N/A" answers and dividing it by the total number of items
audited.
Someone else thinks we should first subtract the number of n/a answers from
the total number of items - this number she calls the "applicable total" then
she divides the number of "Yes" answers by the "Applicable total" and gets a
compliance.

Example on one question there are 485 audits, 48 are "no", 69 are "Yes" and
366 are "n/a". By subtracting out the n/a answers then dividing by that
number into the yes answers she gets a 58% compliance.

By just taking the total of 485 and dividing that into the number of yes +
n/a, you get 90%.

I feel she is making the n/a answers count against her, and she shouldn't.
I think you're looking through 485 items and only finding 48 that were "bad".

Which is the correct way??

thanks, Meenie

--