In this video I explain how to calculate a weighted average in Excel.
The formula is very simple:

sumproduct(values_array,weights_array)/Sum(weights_array).

Check out my video on how to do the same thing in r, which is much easier: [ Ссылка ]
Let me know if you have any questions, comments or requests.
I'll try and upload the example video as soon as i can :)

свернуть