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:
Other People Are Reading
Open your workbook in the Excel 2007 application.
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.
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.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for