Asking about this question below. if you need the number data, please follow the instruction in the question to download the number and solve it for me because i can not add the excel files here. I also give you the pictures to compare is that you are downloading right data numbers or wrong one. and please give me the detail explanations and proper answers in Excel. Thanks so much!

Equation 11.8 is:?p=?1?1+?2?2+...+?n?n

AA AB M 0 Q | Date Open High Low Close Adj Close Volume 2013-01-01 8 11.63 7.47 11.36 11.36 2814600 2013-02-01 11.37 12.12 10.6 11.6 11.6 4391600 JOUI A W N - 2013-03-01 11.75 12.2 10.59 10.81 10.81 1515400 2013-04-01 10.71 11.69 10.08 11.14 11.14 948400 2013-05-01 11.06 12 10.8 11.8 1 1.8 1274500 2013-06-01 11.82 13.62 11.22 13.43 13.43 1225300 2013-07-01 13.49 14.5 12.92 13.28 13.28 1147400 2013-08-01 13.27 14.33 12.57 13.02 13.02 1203800 2013-09-01 13.02 17.18 12.53 16.9 16.9 2849800 11 2013-10-01 16.889999 21 16.66 18.879999 18.879999 3304100 12 2013-11-01 18.83 22.08 16.27 20.110001 20.110001 2241100 13 2013-12-01 20.49 25.76 19 25.690001 25.690001 1994900 14 2014-01-01 25.940001 28.309999 22.440001 22.780001 22.780001 3802600 15 2014-02-01 22.780001 23.82 20.01 22.74 22.74 2882000 16 2014-03-01 22.26 27.49 21.82 24.120001 24.120001 2439300 17 2014-04-01 24.15 26.700001 21.540001 23.66 23.66 2179800 18 2014-05-01 23.73 24.6 18.48 20.33 20.33 2610400 19 2014-06-01 20.52 23 19.75 21.610001 21.610001 1269700 20 2014-07-01 21.790001 22.76 19.75 20.719999 20.719999 1391300 2014-08-01 21.52 31.120001 21.24 30.440001 30.440001 2751400 2014-09-01 31.5 33.5 28.98 30 30 2561600 2014-10-01 29.950001 30.91 25.540001 30.84 30.84 2025200 2014-11-01 30.75 45.459999 29.440001 43.16999 43.169998 2835400 2014-12-01 42.810001 56.91 10.82 55.200001 55.200001 4213000 2015-01-01 55.41 56.939999 45 45.959999 45.959999 3479700 2015-02-01 46.509998 50 39.689999 47.02 47.02 2906900 2015-03-01 47.470001 47.61000 39.029999 41.970001 41.970001 2346500 2015-04-01 41.790001 48.34 40.740002 42.389999 42.389999 1563100 2015-05-01 43.169998 6.91 36.130001 37.990002 37.990002 2068600 2015-06-01 38.299999 38.93 30.120001 31.030001 31.030001 2242000 2015-07-01 31.93 35 29.32 32.150002 32.150002 1709800 2015-08-01 32 $3.93 25.0 29.5 29.5 158500 2015-09-01 28.959999 31 27.200001 28.280001 28.280001 949800 35 2015-10-01 28.32 33.950001 27.6 32.610001 32.610001 1115800 36 2015-11-01 32.75 34.060001 18.719999 23.18 23.18 3421700 37 2015-12-01 23.18 23.5 20.360001 21.77 21.77 1726800 28 SW.TO (2) (+Date Open High Low Close Adj Close Volume 2013-01-01 61.299999 64.699997 60.880001 62.990002 43.082462 27979900 2013-02-01 63.200001 64.309998 62.150002 64.209999 44.41304 28391500 NUI A W N - 2013-03-01 64.120003 64.5 63.32 63.939999 44.226288 32647800 2013-04-01 63.970001 64.43 61.509998 63.189999 43.707512 28641800 2013-05-01 63.189999 53.84 60.98 61.369999 42.95076 37802000 2013-06-01 61.419998 51.84 58.68 61 42.691814 33669900 2013-07-01 61 65.989998 60.59 63.869999 44.700436 29943100 2013-08-01 64.139999 67.010002 63.209999 66.110001 46.794395 28532400 2013-09-01 66.489998 69.190002 66.30000 68.75 48.663052 22747300 11 2013-10-01 68.849998 73.900002 68.349998 72.620003 51.402348 28278500 2013-11-01 72.800003 74.690002 72.349998 73.610001 52.6301 22830600 13 2013-12-01 73.62000 74.18 68.349998 70.809998 50.628132 34578200 14 2014-01-01 70.68 73.230003 68.010002 68.059998 48.661926 31039400 15 2014-02-01 68.099998 73.599998 67.040001 72.940002 52.721752 26317000 16 2014-03-01 72.519997 74.290001 71.639999 73.959999 53.459019 27085300 17 2014-04-01 74 76.68 73.510002 75.550003 54.608303 23299000 18 2014-05-01 75.739998 77.449997 74.279999 76.279999 55.69279 16673500 19 2014-06-01 76.25 78.860001 76.010002 78.580002 57.372055 23167000 2014-07-01 78.599998 82.790001 78.449997 81.269997 59.336029 20771200 2014-08-01 81.010002 83.809998 78.589996 83.660004 61.664875 24477400 2014-09-01 83.800003 85.709999 81.44999 82.43 60.758228 24612400 2014-10-01 82.389999 83.089996 76.410004 81.730003 60.24229 29573600 2014-11-01 81.879997 84.389999 80.709999 83.860001 62.404961 24068600 2014-12-01 83.440002 83.809998 77.150002 82.18 61.154778 41787300 2015-01-01 82.419998 82.910004 72.870003 72.93 54.271347 36877900 2015-02-01 73.400002 79.370003 73.120003 77.459999 58.245537 29332700 2015-03-01 77.510002 77.660004 74.190002 75.900002 57.072517 35937200 2015-04-01 75.870003 80.760002 75.050003 78.82 59.268192 28405700 2015-05-01 78.860001 79.43 75.830002 75.910004 57.652267 21945400 2015-06-01 76.010002 76.800003 73.129997 74.010002 56.209255 42240800 2015-07-01 74.419998 75.970001 71.269997 72.980003 55.426971 33246100 2015-08-01 72.980003 73.980003 64.010002 54.541714 30968200 2015-09-01 69.839996 72.889999 68.150002 72.779999 55.9091 30224700 2015-10-01 73 78.5 71.160004 76.040001 58.413406 36807900 2015-11-01 76.07 77.330002 74.010002 77.110001 59.860672 23683800 37 2015-12-01 77.57 80.050003 76.230003 78.080002 60.613693 37175000 38 39 BMO.TO (2) +\fObtain monthly for Sierra Wireless, the Bank of Montreal, and the SScPfTSX Composite Index for January 1, 2013 to December 31, 2015. (Note: monthly historical prices, adjusted for dividends, are available from http:L'cafmanceyahoocom.) To obtain the data, go to the website and search using thel following ticker symbols: SW.T0 BMOIO AGSPTSE Which rm do you expect to have a larger beta? Explain your reasoning. Calculate the beta for each company. Create a portfolio consisting of 50 percent in Sierra Wireless and 50 percent in Bank of Montreal. i. Calculate the monthly returns for the portfolio and calculate the beta of the portfolio using those monthly returns. ii. Using equation 11.8, calculate the beta of the portfolio. iii. Compare the two betas. PET?\