Solved
Weighted Avg
Posted on 2011-03-10
I'm having a senior moment. If I have a table like this, what's the formula for a weighted average? Is the value I have on the right correct?
TYPE COUNT SR RATE WEIGHTED AVG
APPLE 24 8% 1%
BANANA 36 40% 9%
ORANGE 1 0% 0%
CHERRY 15 21% 2%
GRAPE 27 33% 5%
LIME 2 0% 0%
LEMON 10 18% 1%
STRAWBERRY 41 16% 4%
BLUEBERRY 10 28% 2%
Grand Total 166 25% 24%