Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"<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 :) -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a simple math formula | New Users to Excel | |||
Math formula | Excel Discussion (Misc queries) | |||
Math Formula | Excel Discussion (Misc queries) | |||
simple math formula | Excel Discussion (Misc queries) | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions |