Weighted Average , Formula, & Calculation

Weighted Average , Formula, & Calculation

Weighted average is a calculation that takes into account the varying degrees of importance of the numbers in a data set. Many weighted averages are found in finance, including the volume weighted average price (VWAP), the weighted average cost of capital (WACC), and exponential moving averages (EMAs) used in charting. In a weighted average, the final average number reflects the relative importance of each observation and is thus more descriptive than a simple average. A weighted average can be more accurate than a simple average in which all numbers in a data set are assigned an identical weight. For inventory accounting, the weighted average value of inventory accounts for fluctuations in commodity prices, for example, while LIFO (Last In First Out) or FIFO (First In First Out) methods give more importance to time than value.

The weighted average takes into account the relative importance or frequency of some factors in a data set.

What Is a Weighted Average?

Weighted average is a calculation that takes into account the varying degrees of importance of the numbers in a data set. In calculating a weighted average, each number in the data set is multiplied by a predetermined weight before the final calculation is made.

A weighted average can be more accurate than a simple average in which all numbers in a data set are assigned an identical weight.

The weighted average takes into account the relative importance or frequency of some factors in a data set.
A weighted average is sometimes more accurate than a simple average.
Stock investors use a weighted average to track the cost basis of shares bought at varying times.

Understanding Weighted Averages

In calculating a simple average, or arithmetic mean, all numbers are treated equally and assigned equal weight. But a weighted average assigns weights that determine in advance the relative importance of each data point.

A weighted average is most often computed to equalize the frequency of the values in a data set. For example, a survey may gather enough responses from every age group to be considered statistically valid, but the 18-34 age group may have fewer respondents than all others relative to their share of the population. The survey team may weight the results of the 18-34 age group so that their views are represented proportionately.

However, values in a data set may be weighted for other reasons than the frequency of occurrence. For example, if students in a dance class are graded on skill, attendance, and manners, the grade for skill may be given greater weight than the other factors.

In any case, in a weighted average, each data point value is multiplied by the assigned weight which is then summed and divided by the number of data points.

In a weighted average, the final average number reflects the relative importance of each observation and is thus more descriptive than a simple average. It also has the effect of smoothing out the data and enhancing its accuracy.

Weighted Average

Data Point

Data Point Value

Assigned Weight

Data Point Weighted Value

Weighted Average

Weighting a Stock Portfolio

Investors usually build a position in a stock over a period of several years. That makes it tough to keep track of the cost basis on those shares and their relative changes in value.

The investor can calculate a weighted average of the share price paid for the shares. In order to do so, multiply the number of shares acquired at each price by that price, add those values and then divide the total value by the total number of shares.

A weighted average is arrived at by determining in advance the relative importance of each data point.

For example, say an investor acquires 100 shares of a company in year one at $10, and 50 shares of the same stock in year two at $40. To get a weighted average of the price paid, the investor multiplies 100 shares by $10 for year one and 50 shares by $40 for year two, and then adds the results to get a total of $3,000. Then the total amount paid for the shares, $3,000 in this case, is divided by the number of shares acquired over both years, 150, to get the weighted average price paid of $20.

This average is now weighted with respect to the number of shares acquired at each price, not just the absolute price.

Examples of Weighted Averages

Weighted averages show up in many areas of finance besides the purchase price of shares, including portfolio returns, inventory accounting, and valuation.

When a fund that holds multiple securities is up 10 percent on the year, that 10 percent represents a weighted average of returns for the fund with respect to the value of each position in the fund.

For inventory accounting, the weighted average value of inventory accounts for fluctuations in commodity prices, for example, while LIFO (Last In First Out) or FIFO (First In First Out) methods give more importance to time than value.

When evaluating companies to discern whether their shares are correctly priced, investors use the weighted average cost of capital (WACC) to discount a company's cash flows. WACC is weighted based on the market value of debt and equity in a company's capital structure.

How does a weighted average differ from a simple average?

A weighted average accounts for the relative contribution, or weight, of the things being averaged, while a simple average does not. Therefore, it gives more value to those items in the average that occur relatively more.

What are some examples of weighted averages used in finance?

Many weighted averages are found in finance, including the volume weighted average price (VWAP), the weighted average cost of capital (WACC), and exponential moving averages (EMAs) used in charting. Construction of portfolio weights and the LIFO and FIFO inventory methods also make use of weighted averages.

How is a weighted average calculated?

You can compute a weighted average by multiplying its relative proportion or percentage by its value in sequence and adding those sums together. Thus if a portfolio is made up of 55% stocks, 40% bonds, and 5% cash, those weights would be multiplied by their annual performance to get a weighted average return. So if stocks, bonds, and cash returned 10%, 5%, and 2%, respectively, the weighted average return would be (0.55 x 10%) + (0.40 x 5%) + (0.05 x 2%) = 7.6%.

Related terms:

Accounting

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business to oversight agencies, regulators, and the IRS. read more

Average Price

Average price is the mean price of an asset or security observed over some period of time. read more

Descriptive Statistics

Descriptive statistics is a set of brief descriptive coefficients that summarize a given data set representative of an entire or sample population. read more

Duration

Duration indicates the years it takes to receive a bond's true cost, weighing in the present value of all future coupon and principal payments. read more

Exponential Moving Average (EMA)

An exponential moving average (EMA) is a type of moving average that places a greater weight and significance on the most recent data points. read more

First In, First Out (FIFO)

First-in, first-out (FIFO) is a valuation method in which the assets produced or acquired first are sold, used, or disposed of first. read more

Last In, First Out (LIFO)

Last in, first out (LIFO) is a method used to account for inventory that records the most recently produced items as sold first. read more

Moving Average (MA)

A moving average (MA) is a technical analysis indicator that helps smooth out price action by filtering out the “noise” from random price fluctuations. read more

Stratified Random Sampling

Stratified random sampling is a method of sampling that involves the division of a population into smaller groups known as strata. read more

T-Test

A t-test is a type of inferential statistic used to determine if there is a significant difference between the means of two groups, which may be related in certain features. read more