What is the Coefficient of Variation Formula?
Coefficient of Variation Formula refers to the statistical measure which helps in measuring the dispersion of the various data points in the data series around mean and according to the formula Coefficient of Variation is calculated by dividing the standard deviation by mean and multiplying the resultant with 100.
The term “coefficient of variation” refers to the statistical metric that is used to measure the relative variability in a data series around the mean or to compare relative variability of one data set to that of other data sets, even if their absolute metric may be drastically different. Mathematically, the coefficient of variation formula is represented as,
Coefficient of Variation = Standard deviation / Mean
It can be further expressed as below,
- Xi = ith random variable
- X= Mean of the data series
- N = Number of variables in the data series
Step by Step Calculation of Coefficient of Variation
The calculation of the coefficient of variation equation can be done by using the following steps:
- Step 1: Firstly, figure out the random variables that form part of a large data series. These variables are denoted by Xi.
- Step 2: Next, determine the number of variables in the data series which is denoted by N.
- Step 3: Next, determine the mean of the data series by initially summing up all the random variables of the data series and then dividing the result by the number of variables in the series. The sample mean is denoted by X.
- Step 4: Next, compute the standard deviation of the data series based on the deviations of each variable from the mean and the number of variables in the data series.
- Step 5: Finally, the equation for the coefficient of variation is calculated by dividing the standard deviation of the data series by the mean of the series.
Let us take the example of Apple Inc.’s stock price movement from January 14 2019, to February 13, 2019. Calculate the coefficient of variation for Apple Inc.’s stock price for the given period.
Below is data for calculation of the coefficient of variation of Apple Inc’s
Calculation of Mean
On the based of the stock prices mentioned above, we can calculate the mean stock price for the period can be calculated as,
Mean stock price = Sum of stock prices / Number of days (add up all the stock prices and divide by the number of days, the detailed calculation is mentioned in the last section of the article)
= 3569.08 / 22
Mean = $162.23
Calculation of Standard Deviation
Next, determine the deviation of each stock price from the mean stock price. It is shown in the third column, while the square of the deviation is calculated in the fourth column.
Now, the standard deviation is calculated on the basis of the sum of the squared deviations and the number of days as,
Standard deviation = (Sum of squared deviations / Number of days)1/2
= (1454.7040 / 22)1/2
Standard Deviation = $8.13
= $8.13 / $162.23
The coefficient will be –
Therefore, the coefficient for Apple Inc.’s stock price for the given period is 0.0501 which can also be expressed as the standard deviation is 5.01% of the mean.
Relevance and Use
It is important to understand the concept of coefficient of variation formula because it allows an investor to assess the risk or volatility in comparison to the amount of expected return from the investment. Please keep in mind that lower the coefficient, better is the risk-return trade-off. However, there is one limitation of this ratio that if the mean or expected return is negative or zero, then the coefficient could be misleading (since mean is the denominator in this ratio).
This has been a guide to the Coefficient of Variation Formula. Here we discuss the calculation of the coefficient of variation with practical example and downloadable excel sheet. You can learn more about excel modeling from the following articles –
- What is Normal Distribution Formula?
- Examples of Adjusted R Squared
- What is R Squared Formula in Excel?
- Explanation of the Standard Normal Distribution Formula
- ROUND Formula in Excel (Using Roundup)
- Formula of Covariance
- Formula of Portfolio Variance
- Create Lognormal Distribution in Excel
- Compare and Contrast – Correlation vs Covariance