Determine the weight value of each number. The first column column B in our example contains the grades for each assignment or test. Weighted Average Formula There is no fixed formula to determine a weighted average because the weights assigned to each variable can change from situation to situation.
And in the end you will get the weighted average by dividing values from both of the function.
One advantage of using the weighted average method is consistency. Lastly apply the formula and find the weighted average by dividing. A weighted average also called a weighted mean is an average where some values count more than others. Start by selecting the cell where you want the result to.