HDTutorial
EN
How To calculate Weighted Averages in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To calculate Weighted Averages in Excel

343,028 views November 10, 2013 1:08

Watch on YouTube
ChannelSimplyExcel

Description from the creator

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: youtube.com/watch?v=VysdQKixuc4
Let me know if you have any questions, comments or requests.
I'll try and upload the example video as soon as i can :)

About this tutorial

SimplyExcel published this 1:08 video tutorial on November 10, 2013. It has been watched 343,028 times on YouTube.

Duration
1:08
Published
November 10, 2013
Views
343,028
Likes
707

Tags

Share

This tutorial in other languages