AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.Example: T table(Age,Height,Weight,RowName,LastName) creates a table. SUMPRODUCT: The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges. If the inputs are workspace variables, then table assigns their names as the.This example of weighted average calculates someone's grade in a school course:

This example shows the weighted averages of different numbers and weights:

If using a range of cells, that range must have the same number of rows and columns as the range of values.Īdditional weights are optional, but each additional_value must be followed by exactly one additional_weight.ĪVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2) Examples.

At least one of the weights must be positive.

Weights cannot be negative, though they can be zero.

May refer to a range of cells, or may contain the weights themselves.

The corresponding list of weights to apply.

The first column (column B in our example) contains the grades for each assignment. May refer to a range of cells, or may contain the values themselves. In order to calculate the weighted average, youll need at least two columns.Parts of an AVERAGE.WEIGHTED functionĪVERAGE.WEIGHTED(values, weights,, ) Part If the weights dont add up to one, find the sum of all the variables. The AVERAGE.WEIGHTED function finds the weighted average of a set of values, given the values and the corresponding weights. To find a weighted average, multiply each number by its weight, then add the results.

Assigning weights to variables in excel