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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks