Excel Formulas to find Coefficient of variation in Excel!!
Tags: excelformula
Published: 2021-11-11 07:09:19

---
title: Excel Formulas to find Coefficient of variation in Excel!!
published: true
date: 2021-11-03 12:15:22 UTC
tags: ExcelFormula
canonical_url: https://geekexcel.com/excel-formulas-to-find-coefficient-of-variation-in-excel/
---

If you want to learn how to ** find the coefficient of variation**  in Excel 365? ** ** This post will give you an overview of how to do so using the **[AVERAGE](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)** and **[STDEV.P](https://geekexcel.com/how-to-use-excel-stdev-p-function-in-office-365-with-examples/) Function** in Excel, and it provides some simple formulas to help you quickly get it done. Let’s jump into this post!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- You can use the below-mentioned formula to find the coefficient of variation in Excel.

```
=[STDEV.P](https://geekexcel.com/how-to-use-excel-stdev-p-function-in-office-365-with-examples/)(B5:F5)/[AVERAGE](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)(B5:F5)

```

## Syntax Explanation

- **STDEV.P** – This **[STDEV.P function](https://geekexcel.com/how-to-use-excel-stdev-p-function-in-office-365-with-examples/)** returns the standard deviation based on the entire population given as arguments.
- **AVERAGE** – This **[AVERAGE function](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)** returns the arithmetic mean of given input numbers.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Division (/)** – It is used for dividing values or numbers.

## Practical Explanation

To find the coefficient of variation, refer to the below given example.

- For instance, you have to  **create a sample data**  in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/11/Sample-data-12.png)
_Sample data_

- To calculate coefficient of variation, you need to use the following formula in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=H5/[AVERAGE](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)(B5:F5)

```

![](https://geekexcel.com/wp-content/uploads/2021/11/Use-the-Formula-14.png)
_Use the Formula_

- Then, you have to  **Hit the Enter key**  to get the result in the  **cell I5**  as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/11/Result-for-cell-I5.png)
_Result for cell I5_

- Now, you need to  **press Ctrl+D key**  to get the results in all other columns.

![](https://geekexcel.com/wp-content/uploads/2021/11/Output-6.png)
_Output_

## Bottom-Line

Hope you understood the simple formula to  **find the coefficient of variation ** in Excel 365. Let me know if you have any  **doubts**  regarding this post or any other article on this site and share this post with others that can benefit from it! To learn more, check out our website **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[How to Find R-Squared(RSQ) Function in Excel Office 365?](https://geekexcel.com/how-to-find-r-squaredrsq-function-in-excel-office-365/)**
- **[How to show all Formulas in Excel Office 365 ~ With Examples!!](https://geekexcel.com/show-all-formulas-in-excel/)**
- **[Lookup the Next Largest Value in Excel Office 365!!](https://geekexcel.com/lookup-the-next-largest-value-in-excel-office-365/)**
- **[Excel Formulas to Find Last Row Number in a Range in Excel 365!!](https://geekexcel.com/excel-formulas-to-find-last-row-number-in-a-range-in-excel-365/)**