# Arithmetic Average: When to Use It and When Not

## Arithmetic Average Has Strengths and Weaknesses

Arithmetic average is the most popular measure of central tendency and (the reason for its popularity is that) it is the easiest one to calculate. However, like every other statistical measure, arithmetic average has strengths and weaknesses and it is more suitable in some situations than in others. The following is a summary of situations when using arithmetic average is appropriate and those when arithmetic average should be replaced or complemented by other measures.

## When to Use Arithmetic Average

• When you work with independent data, for example performance of multiple stocks or investments in a single period of time (otherwise geometric average may be better).
• When all items in the data set are equally important (otherwise use weighted average).
• When you need a quick, easy, and rough information about the overall level. Arithmetic average is the easiest one to calculate.
• When you don’t have a computer at hand. Arithmetic average is much easier to calculate in your head or on paper compared to geometric, harmonic, or weighted average.

## When Not to Use Arithmetic Average (Alone)

• When the data set contains extreme values. Extreme values can bias arithmetic average to value which is not representative of the real central tendency in a data set. Median addresses this issue better.
• When errors can be expected in the input data. Sometimes you can have errors or missing data in your data set. For example when you download stock market data from a trading platform, some pieces of data can be missing. Some programs automatically set price or performance of a missing item to zero, which could taint your arithmetic average calculation. Before using arithmetic average (or any statistical tool), make sure your inputs are correct.
• When data set is very volatile or dispersed. There is nothing wrong with using arithmetic average for dispersed data sets. In fact, replacing arithmetic average with some other measure like geometric average will not solve all your problems here. It is always a good idea to add other statistical measures to your analysis to check the volatility or skewness in the data set (arithmetic average and other measures of central tendency can’t identify and describe such characteristics).
• When you work with percentage returns over multiple time periods, especially when the returns are volatile. In this case, the basis for the percentages is very likely to differ significantly from period to period and arithmetic average is quite useless. Geometric average is better here. See reasons and example here: Why arithmetic average fails to measure average percentage returns over time.
• When individual items have different weights or different importance in the data set. Arithmetic average assigns equal weight to all items. When you need to reflect different weights (for example in a portfolio of stocks or a stock index), weighted average is more useful. See reasons and example here: Why you need weighted average for calculating total portfolio return.

## Getting a More Complete Picture

In many cases it helps to use arithmetic average together with other measures, such as median or standard deviation. You can easily calculate these and other statistics in Excel using the Descriptive Statistics Calculator.

## Related pages

what is gamma in financecall option profit calculatorwhat is the wacc formulad2 calcdefine backwardationmsft stock split historyformula disthow to calculate standard deviation excelexcel stdev.sdividend yield calculationwhat does cboe stand forformula for finding the sample meanthe pricing of options and corporate liabilitiescalculating average annual returnshort etf s&pannualized volatilityhistorical var calculationsquare root squared calculatorvix chart yahootrading the macdsample excel formulashow to calculate weighted average cost of debtcalculate delta of call optionfx volatility calculationthinkorswim thinkbackproshares etfscalculate median on excelsharpe ratio interpretationcolor note padhistorical stock return calculatorgeometric average return formulacalculate median excelsample median calculatorstandard deviation formula for grouped datashort strangleconvert standard deviation to variancefxc etfannualizeshort vix etfpayoff put optionipath s&p 500geometric mean rate of return calculatordistribution kurtosishow to draw break even chart in excelexcel cumulative formulatick size futuresinverse s&p 500exponential moving average algorithmannualized daily returncalculate cv in excelformula for standard deviation on excelvix etf vxxstock option strike priceformula of skewness and kurtosisoption trading spreadsheetgarman kohlhagenwhat is overbought and oversoldvxx etntrial and error excelfuture indices bloombergdefining formula standard deviationvelocity shares etfdelta greeksshort term vixaverage cost method formulacalculating sample variancestd dev calcdelta option formulawhat is meant by weighted average cost of capital waccproshares short vix short-term futures etfformula for calculating wacckurtosis is a measure ofblack schole equationrsi stock indicatorcall option payoff graphstandard deviation in mathsvega option greekblack scholes price calculatorinventory average cost method