Here is the formula that will give you the weighted average in Excel: =SUMPRODUCT(B2:B8,C2:C8) In such a case, you can use the SUMPRODUCT function to get the weighted average of the score. A simple average can not be calculated here as the importance of different evaluations vary.įor example, a quiz, with a weight of 10% carries twice the weight as compared with an assignment, but one-fourth the weight as compared with the Exam. In the above data, a student gets marks in different evaluations, but in the end, needs to be given a final score or grade. Suppose you have a dataset with marks scored by a student in different exams along with the weights in percentages (as shown below): Below are three different situations where you can use the SUMPRODUCT function to calculate weighted average in Excelīelow are three different situations where you can use the SUMPRODUCT function to calculate weighted average in Excel Example 1 – When the Weights Add Up to 100% There could be various scenarios where you need to calculate the weighted average. Calculating Weighted Average in Excel – SUMPRODUCT Function
#Average percentages calculator how to
In this tutorial, you’ll learn how to calculate the weighted average in Excel: Calculating Weighted Average in Excel – SUM Function.Example 3 – When the Weights Need to be Calculated.Example 2 – When Weights Don’t Add Up to 100%.Example 1 – When the Weights Add Up to 100%.Calculating Weighted Average in Excel – SUMPRODUCT Function.
0 kommentar(er)
