And there you have it. Weighted average Total of x1w1 x2w2x3w3xnwn Total of w1 w2w3wn. The formula for finding the weighted average is the sum of all the variables multiplied by its weight then divided by the sum of the weights.
Suppose your teacher says The test counts twice as much as the quiz and the final exam counts three times as much as the quiz.
A weighted average is an AVERAGE that takes into account not only the values of numbers. SUMPRODUCTC3C11D3D11SUMD3D11 Press Enter after typing the formula to view the weighted average. Its formula is given by. X w b y w.