View Single Post
  #5   Report Post  
 
Posts: n/a
Default

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.