Weighted average is a calculation that takes into account the varying degrees of importance of the numbers in a data set.
One advantage of using the weighted average method is consistency.
Formula to calculate weighted average in excel.
To find the weighted average in excel we’ll be required to to sum the product of the score and their weight then divide the result by the sum of the weights.
Example:
Score | Weight |
60 | 20% |
82 | 70% |
98 | 5% |
92 | 5% |
We’ll begin by transferring the data to an excel spreadsheet.

Then we’ll type our formula.

After clicking OK we get our answer.

Therefore, your weighted average is 78.9.