please show work

Advanced Co 021 x f B G D From the following data compute the excess return for BAC and S&P500 and regress BAC excess returns on the S&P 500 index excess returns to get an estimate of BAC Compute the intercept of the regression, the beta of BAC (with respect to the S&P 500), and the Red Plot a graph of BAC excess returns (vertical axis) against S&P 500 excess returns as the independent variable (ali) Men BAC SAPSID Rete 1 1.32% 43% AMN 7 0.00% 1,89% 0.18% 3 4.50% ASIN 20% 2015 1:07% 4.01% 9 10 AN 11 33 14 919 119 T # TO 20 BU E W 24 21 24 AR NE n R 31 33 34 31 H 39 40 41 41 AN VE IN FF 1 ZM4% 4 7 4.41% 48 9. WE in -16% 4.42% 2.10% TO 100% ATIN 33 4.00% 12 GAPL 0,10% 13 2.35% 14 3005 0.00% 18 041% LIIN 14 1.22% 17 200% 3.00% * 4.62% 60% TP 3.33% Dar 20 242% 21 4.04% 2.40% 22 0.56% 3.198 23 320% 34 COMS 26 26 27 DAIN (29) 0.34% 4:33% 29 0.73% 3.21% 30 3.59% -578% 31 2016 4.20% KAPS 1.20% 0415 3.38% 144 1.48% 34 445% 4.49% 30 7005 FAOL 3.995 11 45 K NISO 21 SAY SOFE NARO SOVE NIVE NACE NORD Nove www. 1.24% 1415 3.495 NOTE ward 412% 3.40% NOVE NICO 6219 0.24% 4.23% 0.24% 0.31% 079% 027% 031% 0.32% VOCE 0.34% 0375 0.3% 043% G40% 042% 0415 SIPE GAIN 0.47% 0.44% 0.34% 043% 2.44% 041% NOVE 0409 0.42% 0.32% 0.32% 034% 637% 4.215 6.13% 4.17% Thone wa Ay hem INF 2. Advanced Co 021 x f B G D From the following data compute the excess return for BAC and S&P500 and regress BAC excess returns on the S&P 500 index excess returns to get an estimate of BAC Compute the intercept of the regression, the beta of BAC (with respect to the S&P 500), and the Red Plot a graph of BAC excess returns (vertical axis) against S&P 500 excess returns as the independent variable (ali) Men BAC SAPSID Rete 1 1.32% 43% AMN 7 0.00% 1,89% 0.18% 3 4.50% ASIN 20% 2015 1:07% 4.01% 9 10 AN 11 33 14 919 119 T # TO 20 BU E W 24 21 24 AR NE n R 31 33 34 31 H 39 40 41 41 AN VE IN FF 1 ZM4% 4 7 4.41% 48 9. WE in -16% 4.42% 2.10% TO 100% ATIN 33 4.00% 12 GAPL 0,10% 13 2.35% 14 3005 0.00% 18 041% LIIN 14 1.22% 17 200% 3.00% * 4.62% 60% TP 3.33% Dar 20 242% 21 4.04% 2.40% 22 0.56% 3.198 23 320% 34 COMS 26 26 27 DAIN (29) 0.34% 4:33% 29 0.73% 3.21% 30 3.59% -578% 31 2016 4.20% KAPS 1.20% 0415 3.38% 144 1.48% 34 445% 4.49% 30 7005 FAOL 3.995 11 45 K NISO 21 SAY SOFE NARO SOVE NIVE NACE NORD Nove www. 1.24% 1415 3.495 NOTE ward 412% 3.40% NOVE NICO 6219 0.24% 4.23% 0.24% 0.31% 079% 027% 031% 0.32% VOCE 0.34% 0375 0.3% 043% G40% 042% 0415 SIPE GAIN 0.47% 0.44% 0.34% 043% 2.44% 041% NOVE 0409 0.42% 0.32% 0.32% 034% 637% 4.215 6.13% 4.17% Thone wa Ay hem INF 2