What is the Weighted Average?

Robinhood Learn
Democratize Finance For All.
Definition:

A weighted average is an average that accounts for the relative importance of the different factors that you include in the average.

🤔 Understanding weighted average

Averages are standard statistical tools that you can use to find an approximate middle point in a set of numbers. The problem with finding the mean of a set of numbers is that it does not account for the relative importance of those numbers. Weighted averages correct for this flaw, assigning importance to each number and factoring that importance in when calculating the average. Weighted averages are valuable because they provide more information than a simple average without requiring much additional information — just the information needed to assign weights to each number.

Example

College professors regularly use weighted averages when assigning final grades in their classes. Think about a class where 25% of the grade comes from homework, 35% comes from quizzes, and the remaining 40% comes from the final exam. The professor uses weighted averages to determine each student’s final grade weighting homework grades at .25, quiz grades at .35, and the final at .4.

Takeaway

Finding a weighted average is like comparing the weights of two buckets of rocks as opposed to counting the number of rocks in each…

Each bucket may contain 10 rocks, but a three-pound stone is going to count for more than a pebble. Similarly, a more heavily weighted number in a set is going to count more than a lightly weighted one.

New customers need to sign up, get approved, and link their bank account. The cash value of the stock rewards may not be withdrawn for 30 days after the reward is claimed. Stock rewards not claimed within 60 days may expire. See full terms and conditions at rbnhd.co/freestock. Securities trading is offered through Robinhood Financial LLC.

Tell me more…

What is a weighted average?

A weighted average is an average that accounts for the importance of each number that you’re averaging. When you find the average (or mean) of a set of numbers, usually, all you have to do is add the numbers, then divide the sum by the number of values you added. Weighted averages assign importance (or weight) to each number.

A weighted average can be more useful than a regular average because it offers more nuance. It reduces the weight of data that is less important, allowing more material data to have a more significant effect on the result. You can also use it to correct for deficiencies in a dataset. For example, if you’re assessing a sprinter’s average sprint times, you might want to weight sprints from the past three months more heavily than sprints from the year previous to account for the sprinter’s improvement over time.

What are some examples of a weighted average?

One of the most common examples of a weighted average is the grade you receive in a class. For example, the class syllabus could state that homework is 20% of your final grade, quizzes 30%, and exams 50%. Rather than finding the simple average of every graded assignment, the professor weights those grades based on the type of task. Tests are two and a half times more important than homework assignments, and quizzes are 50% more important than homework.

In sports, statisticians use weighted averages to calculate an athlete’s performance. For example, in Major League Baseball, people calculate slugging percentage using a weighted average. Singles have a weight of one, doubles a weight of two, triples a weight of three, and home runs a weight of four.

Manufacturers can use weighted averages to determine the cost of their raw materials. If the manufacturer buys 200 units at \$5 per unit from one supplier and 500 units at \$3 per unit from another, it needs to use a weighted average to find the average cost per unit accurately. This is important for determining sales prices and profitability.

Similarly, investors can use weighted averages to determine their portfolios’ performances. If an investor puts \$30,000 in company ABC and \$10,000 in company XYZ, they should weight their returns 3:1 to find the average return for their portfolio. Bond investors can use a similar calculation to find the average interest rate of their portfolio.

What is a weighted average method?

The weighted average method is a method of determining the average cost of a product or investment. Companies frequently use this method to track inventory costs. Investors can use it to track the cost basis for investments where First-In, First-Out (FIFO) or Last-In, First-Out (LIFO) cost bases aren’t used.

The benefit of using the weighted average method is that it is easier to track. Systems such as FIFO or LIFO require individual tracking for every unit. That means that businesses have to track every unit of every item in inventory, and investors must track the cost basis for every share that they own.

The downside of the weighted average costing method is that it is less precise. If a business purchases raw materials at very different prices, the weighted average won’t adequately reflect the lowest or highest cost paid. This could result in the company pricing goods too low, leading it to lose money on sales where it used components purchased at a high price. In theory, sales from the goods made with low-cost batches of supplies make up for these losses, but this does not always happen.

When do you use weighted averages?

You should use a weighted average when you want to assign more importance to some numbers in a dataset than others. One scenario where this is useful is where one event can have multiple positive or negative results, but the magnitude of the positive or negative result is variable.

An example of this in baseball is slugging percentage. This particular batting average compares the number of hits (positive results) a player gets to the number of times they go up to bat, but not every hit is created equal. A double is more valuable (more positive) than a single, a triple more valuable than a double, and a home run more valuable still.

Using a weighted average offers more insight into the value of each of a player’s at-bats.

How do averages and weighted averages differ?

The most crucial difference between averages and weighted averages is that weighted averages assign importance to each number in a set of numbers. A regular mean or average does not.

Outliers tend to have a smaller impact on weighted averages than in typical averages. You can assign a low weight to outliers to reduce their impact on the weighted mean.

Averages tend to find a central tendency in a set of numbers. A weighted average does not because it is heavily based on the assigned weights.

Another difference is that weighted averages can be biased or subjective. Each number in the set must have a weight. How to assign weights is generally an individual decision. Two people with the same dataset can assign weights in entirely different ways, which produces two different weighted averages. Because typical means don’t involve subjective weights, they cannot be biased in the same way.

How do you calculate a weighted average?

To calculate weighted averages, you need to start with a set of numbers. Weighted averages are frequently used to calculate class grades, so imagine a set of grades that looks like this.

• 100%
• 82%
• 70%
• 95%
• 100%
• 100%
• 60%
• 72%

Once you have the set of numbers, you must assign a weight to each. The list of assignments includes homework, quizzes, and exams. You can make a table with the grades and the type of task, such as:

 Homework Quiz Quiz Homework Exam Homework Quiz Exam 100% 82% 70% 95% 100% 100% 60% 72%

The syllabus states that homework assignments are worth 25% of the final grade, quizzes, 35%, and exams 40%. The next step is to multiply each grade by its corresponding weight.

 .25 .35 .35 .25 .4 .25 .35 .4 100% 82% 70% 95% 100% 100% 60% 72% 25% 28.7% 24.5% 23.75% 40% 25% 21% 28.8%

Finally, sum the results and divide it by the sum of the weights to find the final weighted average.

25% + 28.7% + 24.5% + 23.75% + 40% + 25% + 21% + 28.8% = 216.75%

.25 + .35 + .35 + .25 + .4 + .25 + .35 + .4 = 2.6

216.75% / 2.6 = 83.365%

How do you use Excel to find a weighted average?

One of the most significant disadvantages of using weighted averages is that the calculations can be complicated. This is especially true as the size of the data set grows. Modern tools, like Excel, can make finding weighted averages much easier.

To start, make two columns, one containing each number and another containing the weight for each number. Then, use the SUMPRODUCT function to multiply each number by its weight and to sum the results.

Next, use the SUM function to find the sum of all the weights. Finally, divide the SUMPRODUCT of the numbers by the SUM of the weights to find the weighted average.

New customers need to sign up, get approved, and link their bank account. The cash value of the stock rewards may not be withdrawn for 30 days after the reward is claimed. Stock rewards not claimed within 60 days may expire. See full terms and conditions at rbnhd.co/freestock. Securities trading is offered through Robinhood Financial LLC.

2784797

You May Also Like

PARTICIPATION IS POWER™

This information is educational, and is not an offer to sell or a solicitation of an offer to buy any security. This information is not a recommendation to buy, hold, or sell an investment or financial product, or take any action. This information is neither individualized nor a research report, and must not serve as the basis for any investment decision. All investments involve risk, including the possible loss of capital. Past performance does not guarantee future results or returns. Before making decisions with legal, tax, or accounting effects, you should consult appropriate professionals. Information is from sources deemed reliable on the date of publication, but Robinhood does not guarantee its accuracy.

Options trading entails significant risk and is not appropriate for all customers. Customers must read and understand the Characteristics and Risks of Standardized Options before engaging in any options trading strategies. Options transactions are often complex and may involve the potential of losing the entire investment in a relatively short period of time. Certain complex options strategies carry additional risk, including the potential for losses that may exceed the original investment amount.

Commission-free trading of stocks, ETFs and options refers to \$0 commissions for Robinhood Financial self-directed individual cash or margin brokerage accounts that trade U.S. listed securities and certain OTC securities electronically. Keep in mind, other fees such as trading (non-commission) fees, Gold subscription fees, wire transfer fees, and paper statement fees may apply to your brokerage account. Check out Robinhood Financial’s Fee Schedule for details.

Brokerage services are offered through Robinhood Financial LLC, (RHF) a registered broker dealer (member SIPC) and clearing services through Robinhood Securities, LLC, (RHS) a registered broker dealer (member SIPC). Cryptocurrency services are offered through Robinhood Crypto, LLC (RHC) (NMLS ID: 1702840). Robinhood Crypto is licensed to engage in virtual currency business activity by the New York State Department of Financial Services. The Robinhood spending account is offered through Robinhood Money, LLC (RHY) (NMLS ID: 1990968), a licensed money transmitter. A list of our licenses has more information. The Robinhood Cash Card is a prepaid card issued by Sutton Bank, Member FDIC, pursuant to a license from Mastercard®. Mastercard and the circles design are registered trademarks of Mastercard International Incorporated. RHF, RHY, RHC and RHS are affiliated entities and wholly owned subsidiaries of Robinhood Markets, Inc. RHF, RHY, RHC and RHS are not banks. Products offered by RHF are not FDIC insured and involve risk, including possible loss of principal. RHC is not a member of FINRA and accounts are not FDIC insured or protected by SIPC. RHY is not a member of FINRA, and products are not subject to SIPC protection, but funds held in the Robinhood spending account and Robinhood Cash Card account may be eligible for FDIC pass-through insurance (review the Robinhood Cash Card Agreement and the Robinhood Spending Account Agreement).

2784249