Help with MATH

[AndieB]

Hi all,

 

 

I need some help learning doing math calculation, hopefully you guys here can help me out.

 

How do you make a TOTAL percentage correctly calculated if the TOTAL percentage is based on lets say 5 other average percentage.

 

Example:

 

I have five (5) tables, lets call the T1 through T5.

In each table, I have five (5) rows, lets call these R1 through R5.

Each row, states only TRUE or FALSE.

 

So, it could look like this:

 

T1: R1=FALSE, R2=TRUE, R3=TRUE, R4=FALSE, R5=TRUE

 

So in order to calculate the percentage of HOW many are in status TRUE, the calculation would be made like this: 3 ROWS have value TRUE. So, 3 divided by 5 (number of total ROWS) will equal 0,6, which is 60%.

 

Now, for the rest of the tables it could look like this:

T1 = 60%

T2 = 60%

T3 = 80%

T4 = 20%

T5 = 0%

 

If I now want to give an overall percentage for all the tables percentage values, HOW do I do the math for that?

 

Is it as simple as (60+60+80+20+0)/5 ??

 

Anyone got some feedback about this?

 

Thanks in advance,

 

Andreas

 

[Maq]

If none of the tables are a weighted percentage, which it looks like they aren't, then yes, you are correct.

[AndieB]

If none of the tables are a weighted percentage, which it looks like they aren't, then yes, you are correct.

 

Excuse my lack of knowledge, but what is weighted percentage?

 

Sincerely,

Andreas

[Maq]

As in:

 

A)  1/5 = 20%

B)  20 /100 = 20%

 

They both equal 20% but B would have a higher weight.  Even if they're the same numbers you can have one section weighted higher than the next.

 

In your case it seems that you don't want weighted percentages, your all have the same numbers.