Can i do a weighted average in excel

The result will be similar to this:. When all of the multiplications are done, the function adds up the products and returns that sum. Nor do they need to be expressed as percentages. Well, that's all about calculating weighted average in Excel. You can download the Weighted Average spreadsheet and try the formulas on your data.

In the next tutorial, we are going to have a close look at calculating moving average. I thank you for reading and look forward to seeing you next week! How to calculate weighted average in Excel by Svetlana Cheusheva updated on July 6, What is weighted average? You may also look at these useful functions in excel —. Your email address will not be published.

Save my name, email, and website in this browser for the next time I comment. Download Weighted Average Excel Template. Forgot Password? Free Excel Course. Login details for this Free course will be emailed to you.

Article by Madhuri Thakur. Weighted Average in Excel Calculation Weighted Average is an average in which each observation in the data set is assigned or multiplied by weight before summing to a single average value. In this procedure, each quantity to be averaged is assigned a weight that determines the relative importance of each quantity. Weightings are the equivalent of having that many like items with the same value involved in the average.

It is a more accurate measurement of scores, grades, or investments that are of relative importance to each other. This is often the case with investment portfolios Investment Portfolios Portfolio investments are investments made in a group of assets equity, debt, mutual funds, derivatives or even bitcoins instead of a single asset with the objective of earning returns that are proportional to the investor's risk profile.

You need to carry out the weighted average where different weights are given in different subjects. It can be calculated in two ways. Drag this formula for the rest of the cells of the column to get the result for the whole column. Suppose there is a list of students who achieved different marks in a single subject in different terms.

Each term consists of different percentage weight. Considering the percentage weight, you need to calculate the final marks for each of the students. Here we will be using the same formula. But instead of using the arrays column, we will use the row column. Look into the below example for getting a clear view.