How to Calculate Coefficient of Variation in Microsoft Excel 2007

Written by dan howard
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Calculate Coefficient of Variation in Microsoft Excel 2007
You can calculate coefficient of variation by using Excel's STDEV and AVERAGE functions. (Jupiterimages/Comstock/Getty Images)

The coefficient of variation is a measure of the amount of dispersion, or spread, of an array of data. You can calculate a variable's coefficient of variation by dividing the standard deviation of a variable by the average value of that variable. Excel 2007 doesn't include a single function for calculating coefficient of variation, so you must create a formula that manually divides an array's standard deviation by its average.

Skill level:


  1. 1

    Open your workbook in the Excel 2007 application.

  2. 2

    Determine the cell addresses of your data array. For example, if your data is contained in the first 20 rows of column A, your cell addresses are A1:A20.

  3. 3

    Click a blank cell and type the following formula: =(STDEV(A1:A20)/AVERAGE(A1:A20))

    Substitute the address of your data array in place of A1:A20 in the above example.

  4. 4

    Press "Enter." Excel divides the standard deviation of the array by the average value of the array. The result of this calculation is the array's coefficient of variation, which is displayed in the cell.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.