Thread
:
Weighted Average Standard Deviation
View Single Post
#
4
Jerry W. Lewis
Posts: n/a
wrote:
....
Assume that A1:A5 has the values above, and B1:B5 has
the respective scores. Then the average score (C1) is:
=SUMPRODUCT(A1:A5,B1:B5)/(SUM(A1:A5)-1)
I think you meant
=SUMPRODUCT(A1:A5,B1:B5)/SUM(A1:A5)
Jerry
Reply With Quote