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
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 Alves
Step 2.
Check all weightless values first.
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 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.
Photo: Reproduction / Paulo Alves" title="Divide the result by the sum of the weights somatria Photo: Reproduction / Paulo Alves "src =" data: image / jpeg; base64, / 9j / 4AAQSkZJRgABAQAAAQABAAD / 2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT / 2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT / wgARCAAOABkDASIAAhEBAxEB / 8QAGQAAAQUAAAAAAAAAAAAAAAAAAQMEBQYH / 8QAFQEBAQAAAAAAAAAAAAAAAAAAAwT / 2gAMAwEAAhADEAAAAdfsEmuVD0grP EABkQAAIDAQAAAAAAAAAAAAAAAAIDAQQFEP // / // aAAgBAQABBQIc9EjhpFIcLOVMVqwVu EABcRAQEBAQAAAAAAAAAAAAAAAAECAxD / // 2gAIAQMBAT8BdrqUql5 8QAGBEAAwEBAAAAAAAAAAAAAAAAAQIDEBH / 2gAIAQIBAT8BEpqeqoz / xAAfEAABAwMFAAAAAAAAAAAAAAABAAISAxAREyEiMUH / 2gAIAQEABj8CadNp5YVSLY9XA3AByjD2 / wD / xAAaEAACAwEBAAAAAAAAAAAAAAABEQAQMYGR / 9oACAEBAAE / IWIALWD2AsTFl2xfYE2BRwjv / 9oADAMBAAIAAwAAABAUD // EABkRAQACAwAAAAAAAAAAAAAAAAEQESExYf / aAAgBAwEBPxCwuVhV09j / xAAWEQEBAQAAAAAAAAAAAAAAAAABEEH / 2gAIAQIBAT8QABJoBP / EABwQAQADAAMBAQAAAAAAAAAAAAEAESExUaFB0f / aAAgBAQABPxCywmbaHMghVXO7oB96lu77Le / YBAAtRU3mCUioIHF / svmXP / / Z"/>
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 Alves
