Explore BrainMass
Share

Explore BrainMass

    Excel Spreadsheet Setup

    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.

    © BrainMass Inc. brainmass.com October 9, 2019, 5:53 pm ad1c9bdddf
    https://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.

    $2.19