Coefficient of variance

[Geoff C]

Is there a simple way to get this from Excel? Looking to check some numbers
I've been given, but don't know enough stats to know what I'm looking for.

Thanks.

[Michael R Middleton]

Geoff C -

> Is there a simple way to get this from Excel? <

Coefficient of Variation, CV, or coefficient of variance, equals the
standard deviation divided by the arithmetic mean. So, in Excel,

=STDEV(data_range)/AVERAGE(data_range)

It's often expressed as a percentage. So, mulitply by 100, or format the
cell as a percent.

- Mike

www.mikemiddleton.com