MS Excel is a powerful tool for crunching statistics. You may want to learn how to calculate the coefficient of variation, which is simply the standard deviation divided by the mean.

Here’s how:

1. First, isolate a range of cells who coefficient of variation you want to know. For this example, let’s assume that the data who coefficient of variation you want to calculate is in cells A2:A20.

2. Calculate the standard deviation of this data, the formula for which in this case is: =STDEV(A2:A20). Place that formula in cell C1.

3. Now, calculate the mean (average) for the same range by using this formula: =AVERAGE(A2:A20). Place that formula in cell C2.

4. To get the coefficient of variation, type this formula into cell C3: =C1/C2.

Click here to read the rest of this article.