# How to Calculate Coefficient of Variation in Microsoft Excel 2007

Written by dan howard
• Share
• Tweet
• Share
• Pin
• Email

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

## 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

#### References

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