Excel Weighted Average Formula There is no built-in function that will automatically calculate a weighted average in Excel. Weighted average is a type of an average that takes into account the relative importance of each value under consideration and is calculated by multiplying the respective weights in percentage terms with its corresponding value Weighted Average Formula W1X1 W2X2 WnXn Here w respective weight in percentage x value. A weighted average formula is usually more accurate than a simple average.
W a n d x w.
The weighted average of the time you spent working out for the month is 209 minutes. Lastly apply the formula and find the weighted average by dividing. To find your weighted average simply multiply each number by its weight factor and then sum the resulting numbers up. A weighted average formula is usually more accurate than a simple average.