Verify the beta and alpha from the regression with beta and alpha computed using the analytical formula. Finally, compare your results to the beta listed in Yahoo Finance Stock Report. Does any of your results match the Yahoo Finance Report beta? What might explain the differences?Given: yahoo finance beta is 0.87
TWTR ^GSPC Return Excess Return Date Adj Close Date Adj Close TWTR ^GSPC TWTR 9/1/20 44.740002 9/1/20 3335.469971 0.102514 -0.047093 0.0725135 -0.077093 8/1/20 40.580002 8/1/20 3500.310059 0.114835 0.070065 0.0848352 0.040065 7/1/20 36.400002 7/1/20 3271. 120117 0.221887 0.055101 0.1918866 0.025101 29.790001 6/1/20 3100.290039 -0.038101 0.018388 -0.068101 -0.011612 5/1/20 5/1/20 3044.310059 28.68 4/1/20 2912.429932 0.1377525 0.096844 3/1/20 3/1/20 2584.590088 0.260241 -0.125119 0.290241 -0.155119 2/1/20 33.200001 2/1/20 2954.219971 0.022168 -0.08411 0.007832 -0.11411 1/1/20 32.48 1/1/20 3225.52002 0.013417 -0.001628 -0.016583 -0.031628 12/1/19 32.049999 12/1/19 3230.780029 0.036881 0.02859 -0.00141 11/1/19 30.91 11/1/19 3140.97998 0.031365 0.034047 0.0013647 0.004047 10/1/19 10/1/19 3037.560059 0.272573 0.020432 -0.302573 -0.009568 9/1/19 41.200001 -0.033998 0.017181 0.063998 -0.012819 8/1/19 42.650002 8/1/19 2926.459961 0.008036 -0.018092 -0.021964 -0.048092 7/1/19 42.310001 7/1/19 2980.379883 0.212321 0.013128 0.1823209 -0.016872 6/1/19 34.900002 6/1/19 2941.76001 -0.042261 0.06893 0.03893 5/1/19 36.439999 5/1/19 2752.060059 -0.086946 -0.065778 -0.116946 -0.095778 4/1/19 39.91 4/1/19 2945.830078 0.213808 0.039313 0.1838077 0.009313 3/1/19 32.880001 3/1/19 2834.399902 0.068226 0.017924 0.0382261 -0.012076 2/1/19 30.780001 2/1/19 2784.48999 0.082837 0.029729 -0.112837 -0.000271 1/1/19 33.560001 1/1/19 2704. 100098 0.167711 0.078684 0.1377105 0.048684 12/1/18 28.74 12/1/18 2506.850098 0.086169 -0.091777 -0.116169 -0.121777 11/1/18 31.450001 11/1/18 2760. 169922 -0.094964 0.017859 -0.124964 -0.012141 10/1/18 34.75 10/1/18 2711.73999 0.221012 -0.069403 0.191012 -0.099403 9/1/18 28.459999 0.191018 0.004294 -0.221018 -0.025706 8/1/18 35. 18 2901.52002 0.103859 0.030263 0.0738594 0.000263 7/1/18 31.870001 7/1/18 2816.290039 0.270208 0.036022 -0.300208 0.006022 6/1/18 6/1/18 2718.370117 0.258501 0.004842 0.2285013 -0.025158 5/1/18 34.700001 5/1/18 2705.27002 0.144837 0.021608 0.1148368 -0.008392 4/1/18 30.309999 4/1/18 2648.050049 0.044812 0.002719 0.0148121 -0.027281 3/1/18 29.01 3/1/18 2640.870117 -0.089454 -0.026884 0.119454 -0.056884 2/1/18 31.860001 2/1/18 2713.830078 0.234405 -0.038947 0.2044054 -0.068947 1/1/18 25.809999 1/1/18 2823.810059 0.074969 0.056179 0.0449687 0.026179 24.01 12/1/17 2673.610107 0.166667 0.034343 0.1366667 0.004343 11/1/17 20.58 11/1/17 2584.840088 -0.00194 0.00372 -0.02628 10/1/17 20.620001 0.222288 0.022188 0.1922881 -0.007812 9/1/17 16.870001 9/1/17 2519.360107 -0.002365 0.019303 -0.032365 -0.010697 8/1/17 8/1/17 2471.649902 0.050963 0.000546 0.0209633 -0.029454 7/1/17 7/1/17 2470.300049 -0.099608 0.019349 -0.129608 -0.010651 6/1/17 17.870001 6/1/17 2423.409912 0.004814 -0.054563 -0.025186 5/1/17 5/1/17 2411.800049 0.11165 0.011576 0.0816505 -0.018424 4/1/17 4/1/17 2384. 199951 0.102341 0.009091 0.0723411 -0.020909 3/1/17 3/1/17 2362.71997 -0.051997 -0.000389 -0.081997 -0.030389 2/1/17 2/1/17 2363.639893 -0.104994 0.037198 -0.134994 0.007198 1/1/17 17.620001 1/1/17 2278.870117 0.080982 0.017884 0.0509817 -0.012116 12/1/16 16.299999 0.118442 0.018201 -0.148442 -0.011799 11/1/16 18.49 11/1/16 2198.810059 0.030084 0.034175 8.351E-05 0.004175 10/1/16 17.950001 10/1/16 2126. 149902 0.221258 -0.019426 -0.251258 -0.049426 9/1/16 23.049999 9/1/16 2168.27002 0.199896 -0.001234 0.1698959 -0.031234 8/1/16 19.209999 8/1/16 2170.949951 0.154447 -0.001219 0.1244471 -0.031219 7/1/16 16.639999 7/1/16 2173.600098 0.03561 -0.045967 0.00561 6/1/16 16.91 6/1/16 2098.860107 0.111038 0.000911 0.0810381 -0.029089 5/1/16 15.22 5/1/16 2096.949951 0.04104 0.015325 4/1/16 14.62 4/1/16 2065.300049 -0.116616 0.002699 -0.146616 -0.027301 3/1/16 3/1/16 2059.73999 -0.086645 0.065991 -0.116645 0.035991 2/1/16 18. 120001 1932.22998 0.078572 -0.004128 0.0485716 -0.034128 1/1/16 16.799999 1/1/16 1940.23999 0.273984 -0.050735 0.303984 -0.080735 12/1/15 23. 139999 12/1/15 2043.939941 -0.088976 -0.01753 0.118976 -0.04753 11/1/15 25.4 11/1/15 2080.409912 -0.107519 0.000505 -0.137519 -0.029495 10/1/15 28.459999 10/1/15 2079.360107Stock TWTR ^GSPC Analytical Regression Expected Risk -0.0125511 -0.021061695 Beta 0.84783455 Risk Free 0.03 Alpha 0.00530569 Covariance TWTR ^GSPC TWTR 0.01895372 ^GSPC 0.00150272 0.001772419 SUMMARY OUTPUT Regression Statistics Multiple R 0.25926687 R Square 0.06721931 Adjusted R So 0.05085474 Standard Erro 0.1352775 Observations 59 ANOVA df SS MS F Significance F Regression 1 0.075169301 0.0751693 4.10761159 0.04737789 Residual 57 1.043100128 0.0183 Total 58 1.11826943 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.00530569 0.01969258 0.26942565 0.78857509 -0.03412803 0.0447394 -0.034128 0.0447394 ^GSPC 0.84783455 0.418327509 2.02672435 0.04737789 0.01014816 1.68552094 0.01014816 1.68552094
