# Excel Weighted Average

The attached jpg file shows resultant data. Group B is consistently low on all members data but all other groups, generally, score pretty high. This pushes up the average score. But not, I think, an accurate picture.

Is there a way in Excel for weighted average to make a more accurate result?

Thanks

btw... Bx + Cx is the same sum on all 17 groups.

Row D = Cx / Bx + Cx

###### Who is Participating?

x

Commented:
I don't really see a problem with the way you are doing that now. If every row is a score out of 61 the it's legitimate to produce the %s for each row as you are and then you can also legitimately average the percentages.

regards, barry
0

SD-WAN SimplifiedCommented:
There are many types of averages. Arithmetic mean is what you are doing. There is also median (the middle number), mode (the most frequently appearing number). One of my favorites is a geometric mean. You multiply all the numbers and ^1/n the whole thing.
http://en.m.wikipedia.org/wiki/Geometric_mean?wasRedirected=true
0

Commented:
=MEDIAN(C1:C24)

will give you 90% rather than 83%

As long as you understand why, it's not a problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.