we need to divide the resultant value by the sum of the weights to get the weighted average. Here’s how to do it in Excel: Now as you can see in the image, the average comes to 80.85 ...

A weighted average is simply a method of determining the mean of a set of data in which certain points occur multiple times or in which certain points are valued more highly than others.