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:
Easy

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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