 Related Questions

 Tags

Question by  mec109 (12)

# How do you calculate weighted average percentages?

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

 +1 vote! +7 you voted 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.

 +1 vote! +6 you voted 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)

 +1 vote! +6 you voted 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.

 +1 vote! +5 you voted 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.

 add your own answer here You have 50 words left!