In mathematics and statistics, you calculate weighted average by multiplying each value in the set by its weight, then you add up the products and divide the products' sum by the sum of all weights. However, we want the average formula to consider the weight of each activity listed in column C.
A usual average is easily calculated with the Excel AVERAGE function. Students' grades are often calculated using a weighted average, as shown in the following screenshot.
In other words, each value to be averaged is assigned a certain weight. Weighted average is a kind of arithmetic mean in which some elements of the data set carry more importance than others. SUMPRODUCT formula for weighted average.
Compute geodist for each row how to#
How to calculate weighted average in Excel.
But what if some of the values have more "weight" than others and consequently contribute more to the final average? In such situations, you'll need to calculate the weighted average.Īlthough Microsoft Excel doesn't provide a special weighted average function, it does have a couple of other functions that will prove useful in your calculations, as demonstrated in the formula examples that follow. In one of the previous articles, we discussed three essential functions for calculating average in Excel, which are very straightforward and easy-to-use. The tutorial demonstrates two easy ways to calculate weighted average in Excel - by using the SUM or SUMPRODUCT function.
0 kommentar(er)
