# Excel Spreadsheet Setup

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.

© BrainMass Inc. brainmass.com October 9, 2019, 5:53 pm ad1c9bdddfhttps://brainmass.com/statistics/excel-spreadsheet-setup-71468

#### 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.