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 and STDEV.P 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
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 returns the standard deviation based on the entire population given as arguments.
- AVERAGE – This AVERAGE function 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.
Sample data
- To calculate coefficient of variation, you need to use the following formula in formula bar.
=H5/[AVERAGE](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)(B5:F5)
Use the Formula
- Then, you have to Hit the Enter key to get the result in the cell I5 as shown below.
Result for cell I5
- Now, you need to press Ctrl+D key to get the results in all other columns.
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 *and Excel Formulas *!!
Read Ahead:
Top comments (0)