Explore BrainMass
Share

### Explore BrainMass

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

I need some help in setting up a spreadsheet that beta is = to [cov(stock,market)]/[stdDev(market)] The coefficient of variation is equal to the standard deviation divided by the mean. Also the risk using CAPM in excel.

#### Solution Preview

Please see the attached files. Thank you for using BrainMass!

Excel spreedsheet
________________________________________
I don't know how to set up a spreedsheet that beta is = to [cov(stock,market)]/[stdDev(market)] The coefficient of variation is equal to the stand deviation divided by the mean. Also the risk using CAPM in excel. Any help??

Suppose that you have input some data in Excel, as I did in stat.xls on sheet 1, where there are two columns, column A (Stock data) and column B(Market Data).

Then we can define cov(stock,market) as C1: the first element in column C. We can click "Insert" on the ...

#### Solution Summary

This solution contains step-by-step instructions on how to setup a spreadsheet for the aforementioned variables of beta, coefficient variation, standard deviation, and mean.

\$2.19