Lab 6 - Workbook - Blank

.xlsx
Lab 6 Question: Calculate the 5-year Beta of the share price in an excel sheet using the regression method. Video: https://www.youtube.com/watch?v=ucKK528ApCw Beta from CAPM -1.232719
Date Open High Low Close Adj Close Volume Returns 11/19/2018 154.800003 157.710007 153.009995 157.179993 134.86647 1065100 11/20/2018 153.880005 154.350006 149.690002 151.139999 129.68396 1582000 48.5306544 11/21/2018 151.770004 156 151.580002 153.960007 132.103622 1292300 -18.312263 11/23/2018 148.5 148.940002 145.5 147.169998 126.277504 874600 -32.3222162 11/26/2018 149.259995 152.960007 149.259995 150.240005 128.911697 1152100 31.7287903 11/27/2018 149.779999 151.949997 145.960007 147.119995 126.234604 1633000 41.7411683 11/28/2018 147.130005 148.449997 145.220001 147.899994 126.903877 1263000 -22.6576852 11/29/2018 148.320007 151.300003 148.259995 149.169998 127.993561 1418200 12.2882027 11/30/2018 147.570007 150 145.770004 147.75 126.775192 2084800 47.0032435 12/3/2018 152.229996 154.830002 151.509995 153.380005 131.605957 1543600 -25.9593246 12/4/2018 153.389999 154.169998 145.009995 145.679993 124.999046 1661200 7.61855403 12/6/2018 141.279999 142.619995 135.240005 142.619995 122.373428 2534000 52.5403323 12/7/2018 146.160004 150.75 142.240005 143 122.699532 2265600 -10.5919495 12/10/2018 141.320007 143.550003 137.580002 140.559998 120.605873 1687900 -25.4987641 12/11/2018 143.320007 144.059998 138.300003 138.669998 118.984169 2012800 19.2487707 12/12/2018 141.630005 144.190002 140.130005 140.360001 120.434273 1685100 -16.2808029 12/13/2018 139.839996 140.550003 136.550003 138.600006 118.924126 2222100 31.867545 12/14/2018 139.25 141.059998 136.389999 137.139999 117.671379 2291300 3.11417128 12/17/2018 135.639999 138.020004 132.600006 133.429993 114.488052 1945700 -15.0831406 12/18/2018 133.899994 135.220001 130.830002 132.070007 113.321144 2433800 25.0860873 12/19/2018 132.729996 137.729996 131.779999 132.570007 113.750153 2512700 3.24184403 12/20/2018 130.25 134.550003 127.949997 128.619995 110.360886 2341500 -6.81338799 12/21/2018 127.849998 129.300003 124.470001 125.080002 107.323448 3277000 39.9530216 12/24/2018 123.650002 124.529999 120.449997 120.510002 103.402222 1164000 -64.479707 12/26/2018 122.089996 130.080002 119.080002 130.029999 111.570732 1983700 70.4209622 12/27/2018 127.290001 130.110001 124.459999 130.080002 111.613632 1786400 -9.94606039 12/28/2018 130.960007 131.610001 127.029999 130.509995 111.982605 2700600 51.1755486 12/31/2018 130.970001 133.270004 129.919998 131.520004 112.849213 1493100 -44.7122862 1/2/2019 128.779999 136.729996 128.679993 134.300003 115.234581 2248400 50.5860291 1/3/2019 134.970001 135.729996 132.300003 134.729996 115.603523 2578500 14.6815513 1/4/2019 137.880005 139.889999 135.5 139.289993 119.516151 2836200 9.99418266 1/7/2019 139.529999 143.869995 138.539993 142.320007 122.116051 2262900 -20.2136662 1/8/2019 144.429993 145.449997 141.5 142.199997 122.013084 1638700 -27.5840735 1/9/2019 144.009995 146.690002 142.910004 145.809998 125.11058 1795000 9.53804845 1/10/2019 144.130005 145.789993 142.809998 145.240005 124.621498 1858900 3.55988858 1/11/2019 143.869995 143.979996 141.210007 142.240005 122.047356 1465900 -21.1415353 1/14/2019 140.880005 144.25 140.009995 142.889999 122.605118 1050100 -28.3648271 1/15/2019 144.240005 145.490005 142.550003 143.029999 122.725258 1051700 0.15236644 1/16/2019 143.190002 144.669998 141.600006 143.539993 123.162857 1674200 59.189883 1/17/2019 142.199997 144.020004 140.619995 143.270004 122.93119 1168600 -30.1994983 1/18/2019 145.100006 145.169998 143.330002 144.899994 124.329758 1530200 30.9430087 1/22/2019 143.100006 143.160004 139.800003 139.979996 120.108223 1849600 20.8730885 1/23/2019 140.199997 140.880005 136.660004 137.419998 117.911659 1747900 -5.49848616 1/24/2019 137.050003 139.479996 136.710007 138.309998 118.675301 1413600 -19.1258081
Page1of 50
Uploaded by MinisterSpider3523 on coursehero.com