AVERAGE.WEIGHTED functionThe AVERAGE.WEIGHTED function finds the weighted average of a set of values, given the values and the corresponding weights. Parts of an AVERAGE.WEIGHTED functionAVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
Sample formulasAVERAGE.WEIGHTED(10, 1, 20, 3) AVERAGE.WEIGHTED(A1:A2, B1:B2) AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2) ExamplesThis example shows the weighted averages of different numbers and weights: This example of weighted average calculates someone's grade in a school course: A B C 1 Item Grade Percentage of final grade 2 Homework 95 25% 3 Participation 90 10% 4 Midterm exam 85 15% 5 Projects 88 20% 6 Final exam 82 30% 7 Formula Result 8 Final grade =AVERAGE.WEIGHTED(B2:B6, C2:C6) 87.7Related functions
|