Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Coefficient of variance
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does excel use different denominator for variance and covarian | Excel Worksheet Functions | |||
formula for "coefficient of variation" | Excel Worksheet Functions | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Correlation Coefficient Issue | Excel Worksheet Functions | |||
Variance calculation | Excel Worksheet Functions |