a) calculate the standard deviation for each asset

b) calculate the correlations between each pair of assets

c) calculate the (arithmetic) average of the monthly HPRs for each asset, which you will use as the historical analysis E[r] inputs for the "next time period" in the model.

Sign in AutoSaver File Home Projert 3 template - Upload Blocked Page Layout Formulas Data Search View 3 Share - 6 x Comments Review Help Insert X Draw fic KS STDEV STDLV.P DIV/0! 9.521 .56 HOVYO NDIV/0! DIV/0! HOVO!' OIV/0! DIVYO ADIV/0! HDV/0! MIV/! 'DIV/0! 3.6550401 2040 0.400 SPY BSV LOD W/O!'OIV/0!' DIVO! NOVO! NOVO! 1.529 1.523 9 NOW 3.655 15.566 1010 16.494 TSLG SPY 2 -7 917 0040 2903 3.620 2210 1.943 953 0.893 0.19 0.093 0.416 -0.255 1 001 .440 0.528 0.4/> 0.445 -0.756 5 0228.20 0191:20 12/31/19 y 11/28/19 9 10 11 10 UEM 11 0820M 12 072-1MS 13 06 289 14 0591M9 15 04/30119 16 03/29149 110222011 UIN -3 519 19.809 0.254 14.4/1 2.596 -3.051 -5.56 1.027 7 917 040 2903 2.620 2.210 1.948 27A 55.516 26.90 4.69 30.343 6.764 -5.622 R.122 20.SAS -22.127 14./11 12:51 4.14 0253 1.512 4105 8007 -6910 505 3.001 27.101 -12.220 1181 1.512 0.029 6050 597 -6377 0915 40055 0.156 1.800.965 3942 0.094 8.007 0.624 8.7944 0.993 1.855 0.355 -6.910 0.057 0.505 -0.157 3192 0378 1205 0055 05/0 0. 00 2.431 0.313 051/ 0.223 -2.742 0.2301 3.696 -0.795 5636 DAR 1200 2011 30570 271 2.356 0.025 2014 0.309 0292 0.34U 2035 0.344 0.67 -0.089 1411 0.746 3705 0570 2.742 20.44/ 3.120 10.435 -22.425 -3.175 12.79 0.000 1.200 1650 -352A 149 10.151 2900 9.926 23.572 -3.997 nas 2.337 -7.458 01.10 0021 11 541 1144 0.487 2.994 6.904 0.417 0557 8.155 14.173 1.2.10 SONA -0 124 -2567 0.192 7.521 0.048 1.13 0.676 5.19 4.198 0.490 1.29 10.764 2014 0.204 0.532 1721 0.145 21.599 1.640 10.595 5.415 11.04 -0.216 8.917 -3.00 1.295 12.31 -7.301 05120 210 1594 1 5336 1.010 11.251 20 11:20M8 21 102- 18 22 DEZEMS 23 0918 24 0781M8 25 08/28118 26 063 118 270408 28 0326118 29 02/28MS 39 0121M8 11 1212047 12 1118047 JJ 1091M7 J4 081281447 35009117 36 071/17 37 UN077 38 21M7 39 04.2EMT 10 03317 -1 021287 42 013147 43 1212018 44 11 2016 45 10 1/16 4G UNCMG 47 08:21M6 2156 2.806 10.026 10.142 5.141 8.578 12.53 11.124 1411 0126 17.595 12.925 2028 0.176 1919 1789 2028 3.684 1734 0.003 0.170 3650 0.47 1 701 0 195 0.724 0.107 0106 0.259 0.0/0 1.00/ 0.203 0.187 -0.270 0.17? 106 0 206 0.095 0.44/ 0.008 3.04 -3.764 -9.702 10.604 16. 2EIE 3.650 1701 19 06 2016 58 0591MB 51 04/26MB 52 098176 Ow5 -7 21 4.78) 19./16 0724 Sheet1 + E -- + 7 - Type here to search 11:26 PM 4/22/2020 Sign in AutoSaver File Home Projert 3 template - Upload Blocked Page Layout Formulas Data Search View - x Comments Insert Draw Review Help Share 0 083 20. 1.053 0.123 .064 0.153 0.574 11.506 29.11 0.91/ 6.565 17.567 -2.128 -11.051 1/18 02 11.2/4 - 15.095 -0.878 -6.095 0003 4978 1/18 0900 8.305 -2.543 -6095 2.750 -2019 1 285 0983 174 5.620 2005 0056 7.747 0.317 0.792 0.149 0.299 0.078 0.510 -0.076 0.144 0127 0.119 0.04 0.44) 0.4/8 0.951 -0.279 0.258 -2019 -1.421 -0.787 6.962 10.999 14.99 -1.119 1860 0.198 3.304 0.149 7,443 -0.017 0256 2747 53 02/2016 54 0112916 55129115 56 1016 57 100MG SA 05/2015 59 08 2:1MS fon 0721MS 61 0819045 62 0512675 0 04/2015 64 099115 65 P2716 GG UNMG 67 12/21M4 FR 11128M4 f 10314 70 2044 71 00264 12 0791M4 1308/2014 14 06014 75 U4N0114 7600114 77 02128M4 76 01314 79 12191MS 001112049 U11091M9 U2 09 2018 43 2013 84 UNM 15.567 -3044 -1.779 1144 0918 0.00 -1.179 3046 1144 2003 2.321 OGOS 0.831 -1.557 3575 2.500 2.964 4.031 3.109 2999 3.163 -1.333 -0147 0.353 0.2J/ 0.036 0.4JY 0.254 0.798 0.157 0.525 455 0.207 0.903 0.909 0.2LY 0.420 -0.533 5.100 19.444 5.209 - 17.023 -11.960 7.799 13.248 0.831 2.142 1.167 -1104 -10 019 20.729 6.902 15.541 0.09 -0.269 - 14.852 34.14 20.595 1R 187 -20.420 1/2 14,420 2. 1.220 -0.020 1.113 1.885 0214 0118 .00 1./43 3575 2 con 2.901 4.031 5.120 10.915 7.5/2 22:19 2.174 -0017 1076 9.875 - 10.254 13.149 11 RR 1.071 1703 31.271 42.111 R.ZA 7.145 0.896 0.149 20.222 3.923 -1.820 a6 0521M3 A7 0420M3 on 09128MS 0902128MS Yu 0191M9 91129112 92 112012 93 UN1M2 54 05 28M2 95 08 2:1M2 16 07:21M2 47 061242 90 05:31M2 yy 0413042 TUU 09: 32 101 P2262 102 U1N1M2 3 42/2011 104 11/2011 SOS 1.071 179R 1276 119 0.896 050 1820 2.536 7.505 1.179 1057 6005 U 2216 4341 4.637 10444 -0.105 0.205 0011 0.228 0.025 0.04/ 0.206 0.002 0.051 0.226 0405 0059 0.134 0.4 0.199 0.019 0.569 0.240 0.125 4.012 -12.368 0.991 7.964 6.4LU 20.750 1.101 74.373 -0.054 15.185 9.756 DOWNIA 0.758 WNIA 1.062 NUA .420 N/A 1.632 N/A 2.145 N/A 2.485 N/A 2.158 UNIA -6005 -10.952 1 2.216 4.941 4.67 11.44 14.92 -12.367 11.474 -0.406 Sheet1 A -- 70% " (D + - Type here to search A 11:26 PM 4 122/2020 Sign in AutoSaver File Home Projert 3 template - Upload Blocked Page Layout Formulas Data Search View Help - x Comments Insert Draw Review Share K5 10 915 20.018 12.1/6 2.000 -1.689 10915 0.21) 0945 0.294 499 0.03 2.000 0.616 -1.689 0.023 - 1.121 0.618 7.295 0.950 0011 -0.101 14740222 23900.350 0032 0.500 0.002 0.396 -3.351 2.23 -0.541 16.157 011 05 10/31M1 106 OG 2011 U/ 009111 103 07:2611 109 UBNM 1 110 0621M1 111 04/25411 112 02:31M1 111 0212811 114 0131M1 115 12/910 116 11900 11/ HOME TO 118 CM 119 08/21MO 123 07MO 121 2 O -2 05:28MO 23 04/2010 124 09910 -9.501 2.509 0.51 0.229 2.431 0.700 1.269 2.502 -0.5.10 1081 0017 0.748 1.61 0.261 0.460 2.857 2.110 1270 -1100 1 SO 0.051 N/A NA N/A N/A N/A N/A WNIA WNIA N/A NA PNA N/A N/A N/A UNA WNIA NA WNIA NA N/A WW2 01./6/ 8955 0.279 7493 0.479 6.830 0.60 -5.1731.00 - 7 0A05 1549 0.517 191 0.31/ .493 6830 5.173 -7018 -2.307 -16.324 ANIN HNA 191 HN/A 120 127 128 129 171 12 135 110 1411 140 153 Sheet1 + A " 70% -- . + - Type here to search 11:27 PM 4/22/2020 Sign in AutoSaver File Home Projert 3 template - Upload Blocked Page Layout Formulas Data Search View 3 Share - 6 x Comments Review Help Insert X Draw fic KS STDEV STDLV.P DIV/0! 9.521 .56 HOVYO NDIV/0! DIV/0! HOVO!' OIV/0! DIVYO ADIV/0! HDV/0! MIV/! 'DIV/0! 3.6550401 2040 0.400 SPY BSV LOD W/O!'OIV/0!' DIVO! NOVO! NOVO! 1.529 1.523 9 NOW 3.655 15.566 1010 16.494 TSLG SPY 2 -7 917 0040 2903 3.620 2210 1.943 953 0.893 0.19 0.093 0.416 -0.255 1 001 .440 0.528 0.4/> 0.445 -0.756 5 0228.20 0191:20 12/31/19 y 11/28/19 9 10 11 10 UEM 11 0820M 12 072-1MS 13 06 289 14 0591M9 15 04/30119 16 03/29149 110222011 UIN -3 519 19.809 0.254 14.4/1 2.596 -3.051 -5.56 1.027 7 917 040 2903 2.620 2.210 1.948 27A 55.516 26.90 4.69 30.343 6.764 -5.622 R.122 20.SAS -22.127 14./11 12:51 4.14 0253 1.512 4105 8007 -6910 505 3.001 27.101 -12.220 1181 1.512 0.029 6050 597 -6377 0915 40055 0.156 1.800.965 3942 0.094 8.007 0.624 8.7944 0.993 1.855 0.355 -6.910 0.057 0.505 -0.157 3192 0378 1205 0055 05/0 0. 00 2.431 0.313 051/ 0.223 -2.742 0.2301 3.696 -0.795 5636 DAR 1200 2011 30570 271 2.356 0.025 2014 0.309 0292 0.34U 2035 0.344 0.67 -0.089 1411 0.746 3705 0570 2.742 20.44/ 3.120 10.435 -22.425 -3.175 12.79 0.000 1.200 1650 -352A 149 10.151 2900 9.926 23.572 -3.997 nas 2.337 -7.458 01.10 0021 11 541 1144 0.487 2.994 6.904 0.417 0557 8.155 14.173 1.2.10 SONA -0 124 -2567 0.192 7.521 0.048 1.13 0.676 5.19 4.198 0.490 1.29 10.764 2014 0.204 0.532 1721 0.145 21.599 1.640 10.595 5.415 11.04 -0.216 8.917 -3.00 1.295 12.31 -7.301 05120 210 1594 1 5336 1.010 11.251 20 11:20M8 21 102- 18 22 DEZEMS 23 0918 24 0781M8 25 08/28118 26 063 118 270408 28 0326118 29 02/28MS 39 0121M8 11 1212047 12 1118047 JJ 1091M7 J4 081281447 35009117 36 071/17 37 UN077 38 21M7 39 04.2EMT 10 03317 -1 021287 42 013147 43 1212018 44 11 2016 45 10 1/16 4G UNCMG 47 08:21M6 2156 2.806 10.026 10.142 5.141 8.578 12.53 11.124 1411 0126 17.595 12.925 2028 0.176 1919 1789 2028 3.684 1734 0.003 0.170 3650 0.47 1 701 0 195 0.724 0.107 0106 0.259 0.0/0 1.00/ 0.203 0.187 -0.270 0.17? 106 0 206 0.095 0.44/ 0.008 3.04 -3.764 -9.702 10.604 16. 2EIE 3.650 1701 19 06 2016 58 0591MB 51 04/26MB 52 098176 Ow5 -7 21 4.78) 19./16 0724 Sheet1 + E -- + 7 - Type here to search 11:26 PM 4/22/2020 Sign in AutoSaver File Home Projert 3 template - Upload Blocked Page Layout Formulas Data Search View - x Comments Insert Draw Review Help Share 0 083 20. 1.053 0.123 .064 0.153 0.574 11.506 29.11 0.91/ 6.565 17.567 -2.128 -11.051 1/18 02 11.2/4 - 15.095 -0.878 -6.095 0003 4978 1/18 0900 8.305 -2.543 -6095 2.750 -2019 1 285 0983 174 5.620 2005 0056 7.747 0.317 0.792 0.149 0.299 0.078 0.510 -0.076 0.144 0127 0.119 0.04 0.44) 0.4/8 0.951 -0.279 0.258 -2019 -1.421 -0.787 6.962 10.999 14.99 -1.119 1860 0.198 3.304 0.149 7,443 -0.017 0256 2747 53 02/2016 54 0112916 55129115 56 1016 57 100MG SA 05/2015 59 08 2:1MS fon 0721MS 61 0819045 62 0512675 0 04/2015 64 099115 65 P2716 GG UNMG 67 12/21M4 FR 11128M4 f 10314 70 2044 71 00264 12 0791M4 1308/2014 14 06014 75 U4N0114 7600114 77 02128M4 76 01314 79 12191MS 001112049 U11091M9 U2 09 2018 43 2013 84 UNM 15.567 -3044 -1.779 1144 0918 0.00 -1.179 3046 1144 2003 2.321 OGOS 0.831 -1.557 3575 2.500 2.964 4.031 3.109 2999 3.163 -1.333 -0147 0.353 0.2J/ 0.036 0.4JY 0.254 0.798 0.157 0.525 455 0.207 0.903 0.909 0.2LY 0.420 -0.533 5.100 19.444 5.209 - 17.023 -11.960 7.799 13.248 0.831 2.142 1.167 -1104 -10 019 20.729 6.902 15.541 0.09 -0.269 - 14.852 34.14 20.595 1R 187 -20.420 1/2 14,420 2. 1.220 -0.020 1.113 1.885 0214 0118 .00 1./43 3575 2 con 2.901 4.031 5.120 10.915 7.5/2 22:19 2.174 -0017 1076 9.875 - 10.254 13.149 11 RR 1.071 1703 31.271 42.111 R.ZA 7.145 0.896 0.149 20.222 3.923 -1.820 a6 0521M3 A7 0420M3 on 09128MS 0902128MS Yu 0191M9 91129112 92 112012 93 UN1M2 54 05 28M2 95 08 2:1M2 16 07:21M2 47 061242 90 05:31M2 yy 0413042 TUU 09: 32 101 P2262 102 U1N1M2 3 42/2011 104 11/2011 SOS 1.071 179R 1276 119 0.896 050 1820 2.536 7.505 1.179 1057 6005 U 2216 4341 4.637 10444 -0.105 0.205 0011 0.228 0.025 0.04/ 0.206 0.002 0.051 0.226 0405 0059 0.134 0.4 0.199 0.019 0.569 0.240 0.125 4.012 -12.368 0.991 7.964 6.4LU 20.750 1.101 74.373 -0.054 15.185 9.756 DOWNIA 0.758 WNIA 1.062 NUA .420 N/A 1.632 N/A 2.145 N/A 2.485 N/A 2.158 UNIA -6005 -10.952 1 2.216 4.941 4.67 11.44 14.92 -12.367 11.474 -0.406 Sheet1 A -- 70% " (D + - Type here to search A 11:26 PM 4 122/2020 Sign in AutoSaver File Home Projert 3 template - Upload Blocked Page Layout Formulas Data Search View Help - x Comments Insert Draw Review Share K5 10 915 20.018 12.1/6 2.000 -1.689 10915 0.21) 0945 0.294 499 0.03 2.000 0.616 -1.689 0.023 - 1.121 0.618 7.295 0.950 0011 -0.101 14740222 23900.350 0032 0.500 0.002 0.396 -3.351 2.23 -0.541 16.157 011 05 10/31M1 106 OG 2011 U/ 009111 103 07:2611 109 UBNM 1 110 0621M1 111 04/25411 112 02:31M1 111 0212811 114 0131M1 115 12/910 116 11900 11/ HOME TO 118 CM 119 08/21MO 123 07MO 121 2 O -2 05:28MO 23 04/2010 124 09910 -9.501 2.509 0.51 0.229 2.431 0.700 1.269 2.502 -0.5.10 1081 0017 0.748 1.61 0.261 0.460 2.857 2.110 1270 -1100 1 SO 0.051 N/A NA N/A N/A N/A N/A WNIA WNIA N/A NA PNA N/A N/A N/A UNA WNIA NA WNIA NA N/A WW2 01./6/ 8955 0.279 7493 0.479 6.830 0.60 -5.1731.00 - 7 0A05 1549 0.517 191 0.31/ .493 6830 5.173 -7018 -2.307 -16.324 ANIN HNA 191 HN/A 120 127 128 129 171 12 135 110 1411 140 153 Sheet1 + A " 70% -- . + - Type here to search 11:27 PM 4/22/2020