Coefficient of Variance in Excel

[gahooja]

Hello, I am trying to figure out how to calculate the coefficient of variation in excel but cant figure it out. Any help would be appreciated.

Stocks Expected Return Probability of Occurring
-20% .20
-10% .25
25% .40
35% .15

That is the problem, what formula can i use to get the coefficient of variation.

Thanks

 

[rwmill9716]

Coefficient of Variation is defined as the ratio of a population's standard deviation to its mean. For a given column of data (say A1:A5), that could be calculated as:

=stdev(A1:A5)/average(A1:A5)

Since you have two columns of data, I suspect that you might be looking for the coefficient of determination (Rsquare). That's available in the formula:

=linest(y-range, x-range, true, true)

This must be entered as an array. Read more about it in Excel's help function.


Ric