Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Internal Rate of Return (IRR)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Mortgage APR vs Interest Rate
- Regression Formula
- Correlation Coefficient Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- Regression vs ANOVA

**Coefficient of Variation Formula (Table of Contents)**

## What is the Coefficient of Variation Formula?

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. It is calculated by dividing the standard deviation of the data series by the mean of the series.

Mathematically, the coefficient of variation formula is represented as,

**Coefficient of Variation Formula = Standard deviation / Mean**

It can be further expressed as below,

** **where

- X
_{i}= i^{th}random variable - X= Mean of the data series
- N = Number of variables in the data series

### Explanation of the Coefficient of Variation Formula

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 X_{i}.

**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. The standard deviation is calculated as shown below.

**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 as shown below.

4.9 (927 ratings)

**Coefficient of Variation formula = Standard Deviation / Mean**

or

### Example of Coefficient of Variation Formula (with Excel Template)

**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**

**Coefficient Calculation**

= $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 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).

### Recommended Articles

This has been a guide to 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 –

- 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

## Leave a Reply