answer all parts of question and state answers clearly please.

1. The sheet, P1, has the monthly stock price of IBM and WMT(Wal-Mart) for the last six years. Using the given data, answer the following questions.
a. Calculate the monthly return each stock by using the following equation; , where the index t denotes a time t. Copy and paste the last months return of IBM and WMT (March, 2020) to the sheet Answer.
b. Find the Average, the Variance, and the Standard Deviation of the return each stock. Paste only the statistical values of IBM to the sheet Answer.
c. Using the data analysis in the tools menu, find the correlation between IBM and WMT.
d. Construct portfolios that include two stocks, IBM and WMT. Calculate their standard deviation and expected return at the different level of weights where the weight of IBM decrease e by .02 from one to zero. Paste to the sheet Answer the standard deviation and the average return of two portfolios; the one portfolio includes IBM by 0.6 and the other one includes IBM by 0.4. For calculating the mean and standard deviation of the portfolios, use the following equations:

Two asset case:

Porfolio Mean:

Portfolio Standard Deviation:

e. Draw the efficient frontier of the portfolio with the answers in question d. Do not forget to write the appropriate title, labels of X and Y on the Picture

Answer P1 Problem Price WMT Return IBM Date WMT 6543 6301 03 04/01/14 05/01/14 05 01/14 MI 01714 1001/14 63.00 6540 6903 6703 247 73.14 1201114 OTOS 0201/15 GO 04/01/15 05 01/15 050115 0701/15 68.98 6574 6300 64.00 5777 S80 5136 37 6 110 0915 18 19 09 64.34 66556 65.46 54 6470 64 61 Date IRM 0170114 15.10 G0114 15339 03/01/14 1630 040114 01/14 1935 601/14 147.36 OTO 14 GR/01/14 09/01/14 1441 100114 13.79 139.13 2011 14 170115 1223 2015 IN 1230 GLOS 13756 08.0VIS 60113 1327) 07/01/15 192 O 01/15 12039 WIS 100115 115.17 1170 1142) 12015 01/01/16 1026 105.14 OL016 126.91 OL0116 1221 S016 060116 IN GH16 13726 16 135.77 09/01/16 100116 1324 11/01/16 IWB 1 2016 147 151.29 017 15640 OLLEY 15766 040117 14:53 05/01/17 133.80 00117 07/01/17 OK 01/17 126.61 017 IN. 100117 11/01/17 120117 1386 01/01/18 1410 DOR 100 139.99 13326 SOLIS 0001/18 125.88 OWNIK 133.30 08 OLIB 135.0 090118 1417 TOOLIS 107744 11/01/18 115.88 107333 101 1264 000119 10.45 0119 0019 0.019 660119 01/01/19 1431 O 01/19 131.00 01/19 14224 10/01/19 10.80 11/01 13151 101 132.60 01/01/20 102.24 20 00:20 119.93 01/15 190175 11701715 1201/15 01 01/16 2017/16 0301/16 041716 01/16 06. 01/16 01/16 08. 01/16 06 TO 01/16 11/01/16 1201/16 OLE01/17 0201/17 01/17 04/01/17 OS 01/17 65.91 66 2037 73.51 713 75.37 73.56 74. 92.19 93.44 10161 85.80 10 DO IS 79.15 82.45 8610 9250 91.14 971 07.01/17 1/17 01/12 1001/17 11011 1271717 01/ 0201/18 03/01/18 01/13 05.01/18 1/18 Otors 08.01/18 is T18 11/01/18 1201/18 OLE 0201/19 01/19 0401/19 Os 01/19 0601/19 070119 O 01/19 0901/19 1001/19 11019 1201/19 OL 1/20 90/41 93.31 90 15.01 1000 ORI TO REI PCIE 108 10887 112 116 22 116.04 117. 11390 10221 b. IBM WMT Average Var Stdev c. IBM WMT IBM WMT d. Weights IBM WMT Portfolio Std Dev Return Answer P1 Probleme Price Date M Return IBM WVT 01/01/14 01/14 Blond 04/01/14 WMT SRSI SR 670 13610 153039 STO 15514 Date 01/14 2014 040/14 105 6181 60 01 73.34 72.36 ARTS 65744 6108 1473 07/01/14 1500 08.071 14045 wote 14141 1001/14 129 11/2017/18 139.15 1201714 01/01/15 122265 02/01/15 120.15 01/01/15 04/01/13 DS 08/01/15 13634 0001/15 1963 07/01/13 13700 01/15 091071 1601713 11/15 12/01/15 B016 101 0001718 0814 0.00 126 16 123 01/16 129 01/16 07/01/16 137.36 080116 01/16 100170 11933 12/01/16 017017112 1151.14 10/01/17 156.40 01/17 1 04/01/12 14053 08/01/17 01/17 16 07/01/17 0601714 07/01/14 01/14 GROUP 1001/10 11/01/14 10019 01/01/15 0201/15 03.2015 04013 OS 01/15 015 07/01/15 01/15 000 10/01/15 11 OPIS 12/01/15 01/01/16 000116 01/16 040/16 LISI 3751 3. 3136 ST 54 5992 59990 6.14 08 41 GOLIG 01/16 07/01/16 08. 01/16 0201/16 1001/16 64.60 4498 T01/16 6701 469 2011 SIL ICIL LOSE 01/16 01/01/12 02/01/17 02/01/17 04/01/12 OS 01/17 01/12 07/01/17 01/17 09.01/17 10/01/17 11/01/17 1201/17 01/01/ 7356 09/01/17 1601717 11/01/17 1301717 01/01/18 117.20 13:40 RTS 147 140.79 130. 12.79 92.14 9374 10161 838 GOU 81/100 1102 128.93 6601/18 0101 9350 91.14 9733 07/01/18 08/01/18 LE 09/01/18 1001/18 11/01/18 12/01/18 01/01/19 00201/19 01/01/19 1380 141.00 1074 1155 107.35 1264 13043 1 1340 0:41 951 09/01/18 10/01/18 11/08 12/01/18 01/01/19 0701/19 01/19 04019 01/19 06.01/19 07/01/19 100 8/01/19 06/01/19 07/0179 IETEI 1058 108,57 13162 143 34 1100 09/01/19 1001/19 11/01/19 12/01/19 01/01/20 09/01/19 10/01/19 11/01/19 1201/19 01/01/20 02/01/20 000 0/01/20 Answer P1 Problem Price WMT Return IBM Date WMT 6543 6301 03 04/01/14 05/01/14 05 01/14 MI 01714 1001/14 63.00 6540 6903 6703 247 73.14 1201114 OTOS 0201/15 GO 04/01/15 05 01/15 050115 0701/15 68.98 6574 6300 64.00 5777 S80 5136 37 6 110 0915 18 19 09 64.34 66556 65.46 54 6470 64 61 Date IRM 0170114 15.10 G0114 15339 03/01/14 1630 040114 01/14 1935 601/14 147.36 OTO 14 GR/01/14 09/01/14 1441 100114 13.79 139.13 2011 14 170115 1223 2015 IN 1230 GLOS 13756 08.0VIS 60113 1327) 07/01/15 192 O 01/15 12039 WIS 100115 115.17 1170 1142) 12015 01/01/16 1026 105.14 OL016 126.91 OL0116 1221 S016 060116 IN GH16 13726 16 135.77 09/01/16 100116 1324 11/01/16 IWB 1 2016 147 151.29 017 15640 OLLEY 15766 040117 14:53 05/01/17 133.80 00117 07/01/17 OK 01/17 126.61 017 IN. 100117 11/01/17 120117 1386 01/01/18 1410 DOR 100 139.99 13326 SOLIS 0001/18 125.88 OWNIK 133.30 08 OLIB 135.0 090118 1417 TOOLIS 107744 11/01/18 115.88 107333 101 1264 000119 10.45 0119 0019 0.019 660119 01/01/19 1431 O 01/19 131.00 01/19 14224 10/01/19 10.80 11/01 13151 101 132.60 01/01/20 102.24 20 00:20 119.93 01/15 190175 11701715 1201/15 01 01/16 2017/16 0301/16 041716 01/16 06. 01/16 01/16 08. 01/16 06 TO 01/16 11/01/16 1201/16 OLE01/17 0201/17 01/17 04/01/17 OS 01/17 65.91 66 2037 73.51 713 75.37 73.56 74. 92.19 93.44 10161 85.80 10 DO IS 79.15 82.45 8610 9250 91.14 971 07.01/17 1/17 01/12 1001/17 11011 1271717 01/ 0201/18 03/01/18 01/13 05.01/18 1/18 Otors 08.01/18 is T18 11/01/18 1201/18 OLE 0201/19 01/19 0401/19 Os 01/19 0601/19 070119 O 01/19 0901/19 1001/19 11019 1201/19 OL 1/20 90/41 93.31 90 15.01 1000 ORI TO REI PCIE 108 10887 112 116 22 116.04 117. 11390 10221 b. IBM WMT Average Var Stdev c. IBM WMT IBM WMT d. Weights IBM WMT Portfolio Std Dev Return Answer P1 Probleme Price Date M Return IBM WVT 01/01/14 01/14 Blond 04/01/14 WMT SRSI SR 670 13610 153039 STO 15514 Date 01/14 2014 040/14 105 6181 60 01 73.34 72.36 ARTS 65744 6108 1473 07/01/14 1500 08.071 14045 wote 14141 1001/14 129 11/2017/18 139.15 1201714 01/01/15 122265 02/01/15 120.15 01/01/15 04/01/13 DS 08/01/15 13634 0001/15 1963 07/01/13 13700 01/15 091071 1601713 11/15 12/01/15 B016 101 0001718 0814 0.00 126 16 123 01/16 129 01/16 07/01/16 137.36 080116 01/16 100170 11933 12/01/16 017017112 1151.14 10/01/17 156.40 01/17 1 04/01/12 14053 08/01/17 01/17 16 07/01/17 0601714 07/01/14 01/14 GROUP 1001/10 11/01/14 10019 01/01/15 0201/15 03.2015 04013 OS 01/15 015 07/01/15 01/15 000 10/01/15 11 OPIS 12/01/15 01/01/16 000116 01/16 040/16 LISI 3751 3. 3136 ST 54 5992 59990 6.14 08 41 GOLIG 01/16 07/01/16 08. 01/16 0201/16 1001/16 64.60 4498 T01/16 6701 469 2011 SIL ICIL LOSE 01/16 01/01/12 02/01/17 02/01/17 04/01/12 OS 01/17 01/12 07/01/17 01/17 09.01/17 10/01/17 11/01/17 1201/17 01/01/ 7356 09/01/17 1601717 11/01/17 1301717 01/01/18 117.20 13:40 RTS 147 140.79 130. 12.79 92.14 9374 10161 838 GOU 81/100 1102 128.93 6601/18 0101 9350 91.14 9733 07/01/18 08/01/18 LE 09/01/18 1001/18 11/01/18 12/01/18 01/01/19 00201/19 01/01/19 1380 141.00 1074 1155 107.35 1264 13043 1 1340 0:41 951 09/01/18 10/01/18 11/08 12/01/18 01/01/19 0701/19 01/19 04019 01/19 06.01/19 07/01/19 100 8/01/19 06/01/19 07/0179 IETEI 1058 108,57 13162 143 34 1100 09/01/19 1001/19 11/01/19 12/01/19 01/01/20 09/01/19 10/01/19 11/01/19 1201/19 01/01/20 02/01/20 000 0/01/20