Table of Contents
The AVERAGE.WEIGHTED function in Google Sheets is a useful tool for calculating the weighted average of a group of numbers. To use this function, simply select the cell where you want the result to appear, type “=AVERAGE.WEIGHTED(” and then select the range of cells containing the numbers you want to calculate the average of. Then, add a comma and select the range of cells containing the corresponding weights for each number. Finally, close the parentheses and press enter to get the weighted average. This function is especially helpful when dealing with data sets that have varying levels of importance assigned to each number.
AVERAGE.WEIGHTED function
The AVERAGE.WEIGHTED function finds the weighted average of a set of values, given the values and the corresponding weights.
Parts of an AVERAGE.WEIGHTED function
AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
| Part | Description | Notes |
values | The values to be averaged. |
|
weights | The corresponding list of weights to apply. |
|
[additional_values] | Additional values to average. |
|
[additional_weights] | Additional weights to apply. |
|
Sample formulas
AVERAGE.WEIGHTED(10, 1, 20, 3)
AVERAGE.WEIGHTED(A1:A2, B1:B2)
AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2)
Examples
This example shows the weighted averages of different numbers and weights:
| A | B | C | D | |
| 1 | 2 | 1 | Formula | Result |
| 2 | 4 | 3 | =AVERAGE.WEIGHTED(A1:A2, B1:B2) | 3.5 |
| 3 | 8 | 6 | =AVERAGE.WEIGHTED(2, 10, 4, 15) | 3.2 |
| 4 | =AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2) | 6.2 |
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.7 |
Related functions
- SUMPRODUCT: The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.
- AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.
Cite this article
stats writer (2024). “How do I use the AVERAGE.WEIGHTED function in Google Sheets?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-average-weighted-function-in-google-sheets/
stats writer. "“How do I use the AVERAGE.WEIGHTED function in Google Sheets?”." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-average-weighted-function-in-google-sheets/.
stats writer. "“How do I use the AVERAGE.WEIGHTED function in Google Sheets?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-average-weighted-function-in-google-sheets/.
stats writer (2024) '“How do I use the AVERAGE.WEIGHTED function in Google Sheets?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-average-weighted-function-in-google-sheets/.
[1] stats writer, "“How do I use the AVERAGE.WEIGHTED function in Google Sheets?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. “How do I use the AVERAGE.WEIGHTED function in Google Sheets?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.