In: Finance
What is the coefficient of variation
Month | Values |
1 | 1278 |
2 | 576 |
3 | 1336 |
4 | 727 |
5 | 406 |
6 | 893 |
7 | 1136 |
8 | 1187 |
9 | 644 |
10 | 629 |
11 | 510 |
12 | 594 |
13 | 1091 |
14 | 1126 |
15 | 635 |
16 | 792 |
17 | 817 |
18 | 1318 |
19 | 1002 |
20 | 658 |
21 | 1064 |
22 | 1301 |
23 | 475 |
24 | 1077 |
25 | 653 |
26 | 637 |
27 | 782 |
28 | 1217 |
29 | 1183 |
30 | 1171 |
31 | 773 |
32 | 997 |
33 | 726 |
34 | 500 |
35 | 873 |
36 | 445 |
Coefficient of variation = standard deviation / Mean * 100
Coefficient of variation = 284.7567871/867.4722222 * 100
Coefficient of variation = 32.8260409743
Excel functions STDEV and AVERAGE are used to find the standard deviation and the mean of the values, respectively.
Screenshot with formulas