In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

How to use Excel’s RANK.AVG () function Figure D Figure D Word’s RANK.AVG () better accommodates duplicates. Figure E Figure E The average rank increase with every duplicate.