Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 192
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 :)

--

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
a simple math formula Dave Horne New Users to Excel 11 November 30th 08 12:01 AM
Math formula Saintsman Excel Discussion (Misc queries) 4 July 1st 07 11:17 PM
Math Formula Mike Rogers Excel Discussion (Misc queries) 6 March 13th 07 02:41 AM
simple math formula Gabriel Excel Discussion (Misc queries) 3 August 25th 06 03:25 PM
How do I do math on a cell name in formula? Mark Mulik Excel Worksheet Functions 3 November 23rd 04 03:43 PM


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"