contador web Skip to content

How to do weighted media in Excel | Productivity

Excel has a function that allows you to quickly calculate the weighted average of a set of numbers. This type of calculation applies to a sequence of values ​​that have different weights. The useful feature is to find a number that represents a dataset taking into account the importance of each table item in school grades, for example, each subject can impact the overall score at different levels. Here's how to find weighted arithmetic media in the Microsoft Spreadsheet Editor.

Excel formulas: the 68 most important functions of the program

How to create charts in Microsoft Excel

How to create charts in Microsoft Excel

Want to buy a cell phone, TV and other discounted products? Meet the Compare dnetc

Step 1. In a spreadsheet with values ​​containing weights, mark the cell that should show the weighted average of the numbers and use the SumProduct function. To do this, type: = SOMAPRODUCT.

Insert the function SOMAPRODUTO in Excel Photo: Reproduction / Paulo AlvesInsert the function SOMAPRODUTO in Excel Photo: Reproduction / Paulo Alves

Insert the function SOMAPRODUTO in Excel Photo: Reproduction / Paulo Alves

Step 2. Check all weightless values ​​first.

Mark the values ​​Photo: Reproduction / Paulo AlvesMark the values ​​Photo: Reproduction / Paulo Alves

Mark the values ​​Photo: Reproduction / Paulo Alves

Step 3. Then insert a semicolon into the formula and mark all weights at once.

Mark and enter all weights in the formula Photo: Reproduction / Paulo AlvesMark and enter all weights in the formula Photo: Reproduction / Paulo Alves

Mark and enter all weights in the formula Photo: Reproduction / Paulo Alves

Step 4. Finally, close the parentheses of the formula and add a slash. Then type the formula SUM, open another parenthesis, and mark all the weights together again. Do not forget to close the parenthesis.

Divide the resulting sum by the sum of the weights. Photo: Reproduction / Paulo AlvesDivide the resulting sum by the sum of the weights. Photo: Reproduction / Paulo Alves

Divide the resulting sum by the sum of the weights. Photo: Reproduction / Paulo Alves

Step 5. Hit Enter to see the result of the weighted average in the cell. The formula used adds each value multiplied by the corresponding weight and, in the end, divides the sum of all this by the total of the weights.

Weighted average considers weights of each value Photo: Reproduction / Paulo AlvesWeighted average considers weights of each value Photo: Reproduction / Paulo Alves

Weighted average considers weights of each value Photo: Reproduction / Paulo Alves