Google Sheets

AVERAGE.WEIGHTED: Google Sheets Formulae Explained

How do you use AVERAGE.WEIGHTED in Google Sheets?

AVERAGE.WEIGHTED is a function in Google Sheets that calculates the average of a series of numbers, each of which is weighted according to a specified value. The function takes as its input a range of cells containing numbers, and a weight for each number in that range. It then calculates the average of the numbers in the range, weighted according to the specified values.

What is the syntax of AVERAGE.WEIGHTED in Google Sheets?

The syntax of AVERAGE.WEIGHTED in Google Sheets is: AVERAGE.WEIGHTED(values, weight_column) The function takes two arguments: a list of numbers (values) and a column of numbers that represent the weights (weight_column). The function calculates the weighted average of the numbers in the values list, using the numbers in the weight_column to determine the weight of each number.

What is an example of how to use AVERAGE.WEIGHTED in Google Sheets?

The AVERAGE.WEIGHTED function in Google Sheets calculates the average of a series of numbers, using a weighting value assigned to each number. The function takes two arguments: the series of numbers and the weighting value. The weighting value can be a number, or it can be a percentage value. If the weighting value is a number, the function uses that number as the weight for each number in the series. If the weighting value is a percentage, the function uses the percentage as the weight for each number in the series. The function then calculates the average of the numbers in the series, using the weighting value for each number.

When should you not use AVERAGE.WEIGHTED in Google Sheets?

Google Sheets' AVERAGE.WEIGHTED function is designed to calculate the average of a series of numbers, where each number is weighted according to a corresponding value in a separate column. The function is not designed to calculate the average of a series of numbers where the corresponding values in the separate column are not all present. Additionally, the function is not designed to calculate the average of a series of numbers where the corresponding values in the separate column are not all of the same type (e.g. numbers, text, dates, etc.).

What are some similar formulae to AVERAGE.WEIGHTED in Google Sheets?

The formulae for weighted averages in Google Sheets are AVERAGE.WEIGHTED and AVERAGE.PRODUCT. The AVERAGE.WEIGHTED formula calculates the weighted average of a list of numbers, where each number is weighted by a corresponding value in a second list. The AVERAGE.PRODUCT formula calculates the weighted average of a list of numbers, where each number is weighted by the product of a corresponding value in a second list.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.