SheetFX
≡
<< Go back to all functions

AVERAGE.WEIGHTED

The AVERAGE.WEIGHTED function in Google Sheets finds the weighted average of a set of values, given the values and the corresponding weights.

Function Syntax and Parameters

Syntax: AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])

Parameters:

  • values: The range of values to consider for the weighted average.
  • weights: The range of weights corresponding to the values.
  • [additional values]: [Optional] Additional ranges of values to consider.
  • [additional weights]: [Optional] Additional ranges of weights corresponding to the additional values.

Step-by-Step Tutorial

  1. Using AVERAGE.WEIGHTED with a single set of values and weights:

    • Example: If A2:A6 contains the values 10, 15, 8, 6, 12 and B2:B6 contains the corresponding weights 0.2, 0.3, 0.1, 0.2, 0.2, then =AVERAGE.WEIGHTED(A2:A6, B2:B6) will return 10.2.

  2. Using AVERAGE.WEIGHTED with multiple sets of values and weights:

    • Example: If A2:A6 contains the values 10, 15, 8, 6, 12, B2:B6 contains the corresponding weights 0.2, 0.3, 0.1, 0.2, 0.2, D2:D4 contains additional values 5, 3, 7, and E2:E4 contains the corresponding additional weights 0.1, 0.2, 0.1, then =AVERAGE.WEIGHTED(A2:A6, B2:B6, D2:D4, E2:E4) will return 8.26.

Use Cases and Scenarios

  1. Grade Calculation: Calculate the weighted average of student exam scores.
  2. Investment Portfolio: Determine the weighted average return on a portfolio of investments.
  3. Product Rating: Calculate the weighted average rating of a product based on customer reviews.

Related Functions

  • AVERAGE: Find the arithmetic mean of a set of values.
  • SUMPRODUCT: Calculate the sum of the products of corresponding values.
  • WEIGHTED_MEAN: An alternative function to calculate the weighted average.

Related Articles