*54*

A **coefficient of variation**, often abbreviated as *CV*, is a way to measure how spread out values are in a dataset relative to the mean. It is calculated as:

**CV =Â Ïƒ /Â Î¼**

where:

**Ïƒ:**The standard deviation of dataset**Î¼:**The mean of dataset

In plain English, the coefficient of variation is simply the ratio between the standard deviation and the mean.

**When to Use the Coefficient of Variation**

The coefficient of variation is often used to compare the variation between two different datasets.

In the real world, itâ€™s often used in finance to compare the mean expected return of an investment relative to the expected standard deviation of the investment. This allows investors to compare the risk-return trade-off between investments.

For example, suppose an investor is considering investing in the following two mutual funds:

Mutual Fund A: mean = 7%, standard deviationÂ = 12.4%

Mutual Fund B: mean = 5%, standard deviationÂ = 8.2%

Upon calculating the coefficient of variation for each fund, the investor finds:

CV for Mutual Fund A = 12.4% / 7% =Â **1.77**

CV for Mutual Fund B = 8.2% / 5% =Â **1.64**

Since Mutual Fund B has a lower coefficient of variation, it offers a better mean return relative to the standard deviation.

**Example: Calculating the Coefficient of Variation in Google Sheets**

There is no built-in function in Google Sheets to calculate the coefficient of variation for a dataset, but itâ€™s relatively easy to calculate using simple formulas.

Suppose we have the following dataset that contains 20 values:

To calculate the coefficient of variation for this dataset, we only need to know two numbers: the mean and the standard deviation. These can be calculated using the following formulas:

To calculate the coefficient of variation, we then divide the standard deviation by the mean:

The coefficient of variation turns out to beÂ **0.0864**.

**Additional Resources**

How to Calculate the Coefficient of Variation in Excel

How to Calculate the Coefficient of Variation in SPSS