How to calculate weighted average in Excel (using SUMPRODUCT)

Опубликовано: 14 Январь 2025
на канале: Chandoo

7,808

145

#WeightedAverage #SUMPRODUCT #SUMOPRODUCT #WeightedMeanExcel

Today we will learn how to calculate weighted averages in Excel using formulas.

What is weighted average ?

Weighted average or weighted mean is defined as [from wikipedia],

The weighted mean is similar to an arithmetic mean ..., where instead of each of the data points contributing equally to the final average, some data points contribute more than others.
...

If all the weights are equal, then the weighted mean is the same as the arithmetic mean.

For example workbook and more explanation:
=====================================

https://chandoo.org/wp/weighted-avera...