Forum Discussion
What is this Madness? Weird Average and Sum results
There is no madness or devil math here, just a (common) misconception: "The darker green value and blue value should match."
No, they should not match. The average in the darker blue is an unweighted average of the percentages above. It would be meaningful only if each row of data had the same importance. The average in the darker green is the weighted average; it gives more weight to the larger values. The latter is almost certainly the one you want to use.
Yes, this is what we have been using, my brain was inspecting various things for accuracy and was clearly in need of a break I was refusing to give it. Thankfully we are using weighted average, Although in this particular case they are equally valued; they are people's scores on a single team, so the average of their scores is also viable; so there could be an argument for the other case. Thank you for the help. I'm so embarrassed. I can do calculus but apparently not basic math.