The coefficient of variation (CV) is a statistical measure of the dispersion of data points in a data series around the mean. The coefficient of variation represents the ratio of the standard deviation to the mean, and it is a useful statistic for comparing the degree of variation from one data series to another, even if the means are drastically different from one another.
The coefficient of variation shows the extent of variability of data in a sample in relation to the mean of the population. In finance, the coefficient of variation allows investors to determine how much volatility, or risk, is assumed in comparison to the amount of return expected from investments. Ideally, if the coefficient of variation formula should result in a lower ratio of the standard deviation to mean return, then the better the risk-return trade-off. Note that if the expected return in the denominator is negative or zero, the coefficient of variation could be misleading.
The coefficient of variation is helpful when using the risk/reward ratio to select investments. For example, an investor who is risk-averse may want to consider assets with a historically low degree of volatility relative to the return, in relation to the overall market or its industry. Conversely, risk-seeking investors may look to invest in assets with a historically high degree of volatility.
While most often used to analyze dispersion around the mean, quartile, quintile, or decile CVs can also be used to understand variation around the median or 10th percentile, for example.
The coefficient of variation formula or calculation can be used to determine the deviation between the historical mean price and the current price performance of a stock, commodity, or bond, relative to other assets.
Below is the formula for how to calculate the coefficient of variation:
\begin{aligned} &\text{CV} = \frac { \sigma }{ \mu } \\ &\textbf{where:} \\ &\sigma = \text{standard deviation} \\ &\mu = \text{mean} \\ \end{aligned}CV=μσwhere:σ=standard deviationμ=mean
Please note that if the expected return in the denominator of the coefficient of variation formula is negative or zero, the result could be misleading.
The coefficient of variation formula can be performed in Excel by first using the standard deviation function for a data set. Next, calculate the mean using the Excel function provided. Since the coefficient of variation is the standard deviation divided by the mean, divide the cell containing the standard deviation by the cell containing the mean.
For example, consider a risk-averse investor who wishes to invest in an exchange-traded fund (ETF), which is a basket of securities that tracks a broad market index. The investor selects the SPDR S&P 500 ETF, Invesco QQQ ETF, and the iShares Russell 2000 ETF. Then, they analyze the ETFs' returns and volatility over the past 15 years and assumes the ETFs could have similar returns to their long-term averages.
For illustrative purposes, the following 15-year historical information is used for the investor's decision:
Based on the approximate figures, the investor could invest in either the SPDR S&P 500 ETF or the iShares Russell 2000 ETF, since the risk/reward ratios are approximately the same and indicate a better risk-return trade-off than the Invesco QQQ ETF.