Question by  mec109 (12)

How do you calculate weighted average percentages?

I would like to use excel to calculate weighted average percentages.


Answer by  worker7041 (64)

the formula is: sum (weights * values) / sum of weights 1. List the weights and values in two columns 2. Find the product of each row and record it in another column 3. Calculate the sum of weights * values and divide by the sum of weights Click on formulas>>insert a function to use the functions SUM and PRODUCT.


Answer by  jsmith (2067)

The function you want to use is SUMPRODUCT(). For example, the following formula in a cell - SUMPRODUCT(B4:B6, A4:A6) / SUM(A4:A6) would give the weighted averages in the cells B4-B6 weighted by the values in A4-A6. Expanded, the SUMPRODUCT function looks like (B4 x A4) + (B5 x A5) + (B6 x A6)


Answer by  VB (361)

Create a new column that multiplies the weight and the percentages together for each entry. Add the column that has all the weights and add the column that has all the results. Divide the results sum with the weights sum. That is the answer.


Answer by  canenguez (123)

Takes into account number of objects or how strong that value is represented in the set of numbers you´ve got. Add numbers represented and divide by the numbers of occurances.

You have 50 words left!