weighted average
Hi Whitney,
3.125 is the correct answer.
Provided your weightings are not going to change
you may be able to approach it like this.
=SUM(B1*4,B4*2,B5,B9)/8
HTH
Martin
"Whitney" wrote in message
...
I tried the formula as you indicated below, but came up with a different
sum.
B C
1 3 50%
2 4 25%
3 2 12.5%
4 3 12.5%
= 3.125
"Roger Govier" wrote:
Hi Whitney
With Values in B1:B4 and percentages in c1:C4
=SUMPRODUCT(B1:B4,C1:C4)
produces the result = 3.75
--
Regards
Roger Govier
"Whitney" wrote in message
...
I would like to calculate a weighted average for an overall score.
Example:
5 point scale
Quality - 3 weighted at 50%
Attendance - 4 weighted at 25%
Productivity
Hold Time - 2 weighted at 12.5%
Wrap Up - 3 weighted at 12.5%
Overall Score = average of the above
without weighting = 3
with weighting = ?
What formula can I use for the overall score to calculate a weighted
average?
|