Formula for Weighted Average
In this case I would use sumif and count as shown below:
=((0.25*SUMIF(A1:A100,2))+(0.5*SUMIF(A1:A100,3))+( 0.75*SUMIF(A1:A100,4))+(1*SUMIF(A1:A100,5)))/COUNT(A1:A100)
"MJ" wrote:
Is there a general formula for Weighted average? I have a row of numerical
data, from 1 to 5. If it's 1, the weight is 0%, 2 - 25%, 3 - 50%, 4 - 75%, 5
- 100%. Is there a formula which I can do this?
Thanks
|