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?
btw... Bx + Cx is the same sum on all 17 groups.
Row D = Cx / Bx + Cx