In this article:

How to Find Coefficient of Variation in Google Sheets (Easiest Way in 2024)

May 8, 2024

Coefficient of Variation in Google Sheets

The coefficient of variation (CV) in statistics is a measure of relative variability that indicates the size of the standard deviation in relation to the mean. It's often expressed as a percentage and is useful for comparing the degree of variation from one data series to another even if the means are drastically different from each other.

Google Sheets Coefficient of Variation Formula

In Google Sheets, to calculate the coefficient of variation (CV) for a dataset, you would use a formula that divides the standard deviation of the dataset by the mean of the dataset and then multiplies the result by 100 to express it as a percentage.

Here's how the formula looks:

=(STDEV.S(range) / AVERAGE(range)) * 100

In this formula:

  • STDEV.S(range) calculates the standard deviation of your sample data. If you're working with an entire population, you would use STDEV.P(range) instead.
  • AVERAGE(range) calculates the mean of your data.
  • range is the range of cells that contain your data (e.g., A2:A100).

So, if your data is in cells A2 through A10, you would write the formula like this:

=(STDEV.S(A2:A10) / AVERAGE(A2:A10)) * 100

How to Find Coefficient of Variation in Google Sheets

Follow the steps below to find the coefficient of variation in Google Sheets. 

1. Input Data into Google Sheets

For our example, enter your data in column B, starting from cell B2. Place scores 82, 76, 90, and so on, down to 85 in cells B2 through B11.

coefficient of variation google sheets

2. Calculate the Average Score

Use the formula to find the average score of your data. In a new cell, type =AVERAGE(B2:B11) and press Enter.

google sheets coefficient of variation

3. Compute the Standard Deviation of Scores

Determine how much your scores vary from the average. For a sample, in another cell, type =STDEV.S(B2:B11) and press Enter. Use STDEV.P if you have the whole population.

how to find coefficient of variation in google sheets

4. Find the Coefficient of Variation as a Percentage

Find the CV to see the variability of scores relative to the average. In a different cell, enter =(STDEV.S(B2:B11) / AVERAGE(B2:B11)) * 100.

coefficient of variation in google sheets

This formula calculates the CV as a percentage.

We hope that you now have a better understanding of how to find coefficient of variation in Google Sheets. If you enjoyed this article, you might also like our article on how to shuffle rows in Google Sheets or our article on how to set up Google Sheets reverse array.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->