Thread
:
Weighted Average Standard Deviation
View Single Post
#
5
[email protected]
Posts: n/a
Jerry W. Lewis wrote:
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)
Yes, you are right. Overzealous editing. Only the
variance formula changes for sample v. population
statistics.
Reply With Quote