Please show all work in excel with formulas

4. The spreadsheet, contains monthly returns for Apple (AAPL) stock and for the S&P 500 Composite Index for Jan. 2015 through Dec. '18 (48 observations, total). Your task is to perform a regression analysis to estimate a beta for AAPL. Provide the regression output, report the beta, and offer a brief explanation of (i) what this AAPL beta measures (or tells us) and (ii) your level of confidence in your beta estimate given the significance level (p-values) from your Returns Data for AAPL Beta S&P500 AAPL Date 20150131 -0.035583 -0.142496 20150228 0.043117 0.098397 0.043135 20150331 0.006932 20150430 0.006201 0.143806 20150530 -0.042859 0.021030 20150630 0.019058 -0.025498 -0.150233 20150731 0.015080 20150829 0.037655 0.036781 regression model. 20150930 0.015514 -0.104547 0.168402 20151031 0.023201 20151128 0.024534 0.079163 20151231 -0.004189 -0.012605 20160130 -0.031041 -0.059120 20160227 0.054893 0.154361 -0.017396 20160331 -0.043718 20160430 0.008521 -0.004395 20160529 0.010491 -0.029548 -0.060321 20160630 -0.021012 0.019742 20160731 -0.031270 -0.030597 20160831 -0.062581 20160930 -0.026443 -0.045496 20161030 0.082983 -0.033105 20161130 0,015540 0.000505 20161231 -0.017530 0.035361 20170129 -0.080028 -0.050735 -0.004128 20170229 0.114998 20170331 0.065991 0.247012 20170429 0.002699 -0.089106 20170531 -0.029780 0.015329 20170630 0.000906 -0.030705 20170729 0.035610 0.219820 -0.001219 20170831 -0.005432 -0.001613 20170930 -0.001234 -0.025385 20171031 -0.019426 0.034174 0.044660 20171130 0.018201 20171230 0.023785 0.017884 0.023373 20180131 0.037198 0.048610 20180228 -0.000389 -0.000508 20180331 0.009091 20180428 0.011880 20180531 0.011576 -0.031373 0.044835 20180630 0.004814 20180731 0.019349 0.005718 20180831 0.000546 -0.013440 20180929 0.019303 0.068321 20181031 0.022188 -0.054998 0.028083 20181130 0.051354 20181229 0.009832 -0.002779 4. The spreadsheet, contains monthly returns for Apple (AAPL) stock and for the S&P 500 Composite Index for Jan. 2015 through Dec. '18 (48 observations, total). Your task is to perform a regression analysis to estimate a beta for AAPL. Provide the regression output, report the beta, and offer a brief explanation of (i) what this AAPL beta measures (or tells us) and (ii) your level of confidence in your beta estimate given the significance level (p-values) from your Returns Data for AAPL Beta S&P500 AAPL Date 20150131 -0.035583 -0.142496 20150228 0.043117 0.098397 0.043135 20150331 0.006932 20150430 0.006201 0.143806 20150530 -0.042859 0.021030 20150630 0.019058 -0.025498 -0.150233 20150731 0.015080 20150829 0.037655 0.036781 regression model. 20150930 0.015514 -0.104547 0.168402 20151031 0.023201 20151128 0.024534 0.079163 20151231 -0.004189 -0.012605 20160130 -0.031041 -0.059120 20160227 0.054893 0.154361 -0.017396 20160331 -0.043718 20160430 0.008521 -0.004395 20160529 0.010491 -0.029548 -0.060321 20160630 -0.021012 0.019742 20160731 -0.031270 -0.030597 20160831 -0.062581 20160930 -0.026443 -0.045496 20161030 0.082983 -0.033105 20161130 0,015540 0.000505 20161231 -0.017530 0.035361 20170129 -0.080028 -0.050735 -0.004128 20170229 0.114998 20170331 0.065991 0.247012 20170429 0.002699 -0.089106 20170531 -0.029780 0.015329 20170630 0.000906 -0.030705 20170729 0.035610 0.219820 -0.001219 20170831 -0.005432 -0.001613 20170930 -0.001234 -0.025385 20171031 -0.019426 0.034174 0.044660 20171130 0.018201 20171230 0.023785 0.017884 0.023373 20180131 0.037198 0.048610 20180228 -0.000389 -0.000508 20180331 0.009091 20180428 0.011880 20180531 0.011576 -0.031373 0.044835 20180630 0.004814 20180731 0.019349 0.005718 20180831 0.000546 -0.013440 20180929 0.019303 0.068321 20181031 0.022188 -0.054998 0.028083 20181130 0.051354 20181229 0.009832 -0.002779