Question: How do you calculate the equity beta for the information above? H I 3 5 8 15 4 A B C D Names Ticker 1

How do you calculate the equity beta for the information above?
H I 3 5 8 15 4 A B C D Names Ticker 1 Date PERMNO Date Symbol Jan-16 89475 20160129 SNY Feb-16 89475 20160229 SNY Mar-16 89475 20160331 SNY Apr-16 89475 20160429 SNY 6 May-16 89475 20160531 SNY Jun-16 89475 20160630 SNY Jul-16 89475 20160729 SNY 9 Aug-16 89475 20160831 SNY Sep-16 89475 20160930 SNY Oct-16 89475 20161031 SNY Nov-16 89475 20161130 SNY 13 Dec-16 89475 20161230 SNY 14 Jan-17 89475 20170131 SNY Feb-17 89475 20170228 SNY 16 Mar-17 89475 20170331 SNY 17 Apr-17 89475 20170428 SNY May-17 89475 20170531 SNY Jun-17 89475 20170630 SNY Jul-17 89475 20170731 SNY Aug-17 89475 20170831 SNY Sep-17 89475 20170929 SNY Oct-17 89475 20171031 SNY Nov-17 89475 20171130 SNY Dec-17 89475 20171229 SNY Jan-18 89475 20180131 SNY Feb-18 89475 20180228 SNY Mar-18 89475 20180329 SNY Apr-18 89475 20180430 SNY May-18 89475 20180531 SNY Jun-18 89475 20180629 SNY Jul-18 89475 20180731 SNY Aug-18 89475 20180831 SNY Sep-18 89475 20180928 SNY Oct-18 89475 20181031 SNY Nov-18 89475 20181130 SNY Dec-18 89475 20181231 SNY 38 E G Return on the S&P 500 Risk-Free Returns Index Rate -0.023681 -0.050735 0.0023 -0.050192 -0.004128 0.0026 0.015424 0.065991 0.0025 0.023406 0.002699 0.0019 0.042099 0.015329 0.0023 0.015777 0.000906 0.0022 0.018638 0.03561 0.0026 -0.097584 -0.001219 0.0026 -0.007278 -0.001234 0.0019 0.018329 -0.019426 0.0024 0.033685 0.034174 0.0030 0.00597 0.018201 0.0042 0.008408 0.017884 0.0050 0.057626 0.037198 0.0048 0.049154 -0.000389 0.0066 0.045304 0.009091 0.0075 0.081757 0.011576 0.0073 -0.033878 0.004814 0.0084 -0.01148 0.019349 0.0097 0.03125 0.000546 0.0098 0.019451 0.019303 0.0099 -0.050412 0.022188 0.0100 -0.034687 0.028083 0.0109 -0.057844 0.009832 0.0120 0.021628 0.056179 0.0130 -0.106533 -0.038947 0.0138 0.021147 -0.026885 0.0164 -0.018962 0.002719 0.0166 0.020622 0.021608 0.0171 0.045466 0.004842 0.0181 0.083729 0.036022 0.0189 -0.011762 0.030263 0.0194 0.042474 0.004294 0.0204 0.001119 -0.069403 0.0217 0.014088 0.017859 0.0224 -0.042778 -0.091777 0.0237 Ri - Rp -0.0530 -0.0067 0.0635 0.0008 0.0130 -0.0013 0.0330 -0.0038 -0.0031 -0.0218 0.0312 0.0140 0.0129 0.0324 -0.0070 0.0016 0.0043 -0.0036 0.0096 -0.0093 0.0094 0.0122 0.0172 -0.0022 0.0432 -0.0527 -0.0433 -0.0139 0.0045 -0.0133 0.0171 0.0109 -0.0161 -0.0911 -0.0045 -0.1155 RM-Rf -0.0260 -0.0528 0.0129 0.0215 0.0398 0.0136 0.0160 -0.1002 -0.0092 0.0159 0.0307 0.0018 0.0034 0.0528 0.0426 0.0378 0.0745 -0.0423 -0.0212 0.0215 0.0096 -0.0604 -0.0456 -0.0698 0.0086 -0.1203 0.0047 -0.0356 0.0035 0.0274 0.0648 -0.0312 0.0221 -0.0206 -0.0083 -0.0665
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
