HDTutorial
EN
Excel 2013 Tutorial - How to Calculate a Weighted Average

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

Excel 2013 Tutorial - How to Calculate a Weighted Average

26,635 views November 15, 2016 3:08

Watch on YouTube
ChannelExcel Tutorial

Description from the creator

In this tutorial you will learn:

How to Calculate a Weighted Average.

You use a weighted average to average values where each value plays a larger or smaller role in the whole set.

How it works:
To compute the weighted average, the percentage that each investment contributes to the total value of the portfolio is multiplied by that investment’s rate of return.

We will use the SUMPRODUCT function to find the weighted average.



Another way to calculate the weighted average is instead of using SUMPRODUCT in one cell, you calculate each investment weight in its own cell the effect of the rate on the whole is calculated, and those values are summed.

About this tutorial

Excel Tutorial published this 3:08 video tutorial on November 15, 2016. It has been watched 26,635 times on YouTube.

Duration
3:08
Published
November 15, 2016
Views
26,635
Likes
64

Tags

Share

This tutorial in other languages