The weights must be represented in terms of total relevancy as a percentage. To calculate a weighted average in Excel simply use SUMPRODUCT and SUM. Sum w and sum xw wandxw.
The weighted average formula is used to calculate the average value of a particular set of numbers with different levels of relevance.
Sum of variables weightsum of all weights weighted average. Calculating a weighted average is possible in Excel using the SUMPRODUCT formula. The weighted average is 9125. Lastly apply the formula and find the weighted average by dividing.