emergency pleasee !!!

am sorry for this problem. please emergency need solution

a. Use the return data in the Excel file (link below) for various stocks and the market. (5 points) Compute the returns of the data and the statistics for each of the assets (mean return, variance and standard deviation of return) b. (10 points) Compute the excess returns and then the sample variance covariance matrix for the six stocks. (10 points) Compute the global minimum variance portfolio (GMVP) weights using the sample variance covariance matrix ink to File H PRICE DATA FOR STOCKS AND THE S&P500 COMPUTING THE SAMPLE VARIANCE-COVARIANCE MATRIX Variante www matrix Stock SO SR PE Dis NE MSFT AAR Wan Disney DIS 2050 31 Microso MORY NA NIKE 15 16 Apple AAR 2744 HP PFE 2013 333 NE MIFT AAR 28.67 20.20 3054 20.30 23.01 25.01 2340 244 360 3553 SAPO ASPC 107.01 1104.49 116.43 1116 10041 1090 71 11010 104333 11620 110326 1100 100 Sot Stock Hewitt Packard Prue HPG PFE 4871 1654 4830 170 5063 154 49 50 1400 1321 1129 12. 4393 1356 1600 1454 40 72 15.0 10,20 15.00 40.00 18.00 40.33 10.17 43.77 1685 41 79 17:06 39.32 15 38,75 1957 15.00 20,21 3505 33 87 1:14 CERE Dale 6 Oca 10 Dub 10 10 10 10 May 10 11 H10 12 Tom 10 10 14.10 15 CH10 16 10 17 Ara 10 18 Ocati 19 11 20 MA 1 1 Nis 11 | | | | | 21 11 M Tom 1 GMVP 3684 3342 3150 1300 32.64 3310 12 0151 3731 307 43.74 49,00 4310 41 63 30.04 3862 180 18.00 10. 18.45 17.00 2004 20.30 21.53 21.35 20 62 2220 1890 20 2013 30 22.54 250 2791 49. 43 00 444 4608 841 5046 40. 50.02 132722 1323 136361 1345.20 13306 1290 20 2500 2740 4736 56.78 22 May 11 23 Haz 11 24 Tem. 11 25 Agu. 11 26 Eyl.11 27 Eki 11 28 Kas 11 29 Ara 11 30 Oca 12 31 ub 12 32 Mar.12 33 Nis. 12 34 May. 12 35 Haz. 12 36 Tem. 12 37 Agu. 12 38 Eyl.12 39 Eki 12 40 Kas. 12 41 Ara, 12 35,88 35.05 33,87 25.07 21,74 25.76 27,06 25,05 27.21 24,61 23.29 24.20 22.16 19.77 17.93 16,59 16,90 13,72 12,87 14,25 20,21 19,41 18,14 18,08 16,85 18,35 19,32 20.83 20,60 20.55 22,02 22.27 21,48 22.59 23.61 23,65 24,63 24,65 25.02 25.08 41,63 39,04 38,62 34.06 30.16 34.88 35.85 37,50 38,90 41.99 43.78 43.11 4571 48.50 49.14 49,47 52.28 49.12 49,66 49,79 21.11 22,50 22.54 21.66 21.38 24,09 24.05 24.09 26,00 26,98 27.11 27,97 27.05 21,95 23,34 24,34 23.73 22,84 24,37 25,80 25.01 26,00 27,40 26,60 24,89 26.63 25,58 25,96 29,53 31,74 32.26 32.02 29.19 30.59 29.47 30.82 29,76 28,54 26,61 26,71 49.69 47,95 55,78 54.98 5447 57.83 54,60 57.86 65.21 77,49 85,65 83,43 82,53 83.43 87.25 95,03 95,30 85,05 83,61 76.02 1345,20 1320,64 1292 28 1218.89 1131.42 1253,30 1246,96 1257,60 1312,41 1365,68 1408,47 1397,91 1310,33 1362.16 1379,32 1406,58 1440,67 1412.16 1416,18 1426.19 PRICE DATA FOR STOCKS AND THE S&P500 Date Oca. 10 ub. 10 Mar. 10 Nis. 10 May. 10 Haz. 10 Tem. 10 Au. 10 Eyl. 10 Eki 10 Kas. 10 Ara. 10 Oca. 11 ub. 11 Mar. 11 Nis. 11 May.11 Haz. 11 Tem. 11 Stock1 Stock 2 Stock 3 Stock 4 Stock 5 Stock 6 Hewlett- Walt Packard Pfizer Disney Nike Microsoft Apple HPQ PFE DIS NKE MSFT AAPL 44,77 16,54 29,55 15,94 28,18 27,44 48,30 15.70 31.24 16,90 28,67 29.23 50,63 15.34 34,91 18,38 29,29 33,57 49,50 14.96 36,84 18,98 30,54 37.30 43,83 13,77 33,42 18.09 25,80 36.70 41,29 12.89 31,50 16,89 23,01 35,93 43,93 13,56 33,69 18.41 25,81 36,75 36,69 14,54 32,54 17,50 23,46 34,73 40,22 15.70 33,10 20.04 24,49 40,54 40,20 15.92 36.12 20,36 26.66 43,00 40,09 15.05 36,51 21,53 25,26 44,45 40,33 16,17 37,51 21,36 27,91 46,08 43,77 16,83 38,87 20,62 27.73 48,47 41.79 17.96 43,74 22.26 26,58 50,46 39,32 18,95 43,09 18,93 25,39 49.79 38,75 19,57 43,10 20,58 25,92 50,02 35,88 20,21 41,63 21,11 25.01 49,69 35,05 19,41 39,04 22,50 26,00 47.95 33.87 18,14 38,62 22,54 27,40 55,78 S&P500 AGSPC 1073.87 1104,49 1169,43 1186,69: 1089,411 1030,71; 1101,60 1049,33 1141,20 1183,26 1180,55 1257,64 1286,12 1327.22 1325,83 1363,611 1345,20 1320,64 1292.28 22 May 11 23 Haz. 11 24 Tem. 11 25 Au.11 26 Eyl.11 27 Eki. 11 28 Kas 11 29 Ara, 11 30 Oca. 12 31 ub 12 32 Mar.12 33 Nis. 12 34 May 12 35 Haz. 12 36 Tem. 12 37 Au. 12 38 Eyl.12 39 Eki. 12 10 Kas. 12 11 Ara, 12 35,88 35,05 33,87 25,07 21,74 25,76 27,06 25.05 27,21 24,61 23,29 24,20 22,16 19.77 17.93 16,59 16,90 13,72 12,87 14,25 20,21 19,41 18,14 18,08 16,85 18,35 19,32 20,83 20,60 20,55 22.02 22.27 21,48 22,59 23,61 23,65 24,63 24,65 25,02 25,08 41,63 39,04 38,62 34,06 30,16 34.88 35,85 37,50 38,90 41.99 43,78 43.11 45,71 48,50 49.14 49.47 52,28 49.12 49.66 49.79 21.11 22,50 22,54 21,66 21,38 24,09 24,05 24,09 26,00 26.98 27.11 27,97 27.05 21,95 23,34 24,34 23.73 22,84 24,37 25,80 25,01 26,00 27,40 26,60 24,89 26,63 25,58 25.96 29,53 31,74 32.26 32,02 29.19 30,59 29,47 30,82 29.76 28,54 26,61 26,71 49.69 47.95 55.78 54,98 54,47 57.83 54,60 57.86 65,21 77,49 85,65 83,43 82,53 83.43 87.25 95,03 95,30 85,05 83,61 76,02 1345,20 1320,64 1292,28 1218,89! 1131,42 1253,30 1246.96 1257.60 1312,413 1365,68 1408,47 1397.91 1310.33 1362,16 1379.32 1406,58 1440,67 1412.16 1416.18 1426,19 COMPUTING THE SAMPLE VARIANCE-COVARIANCE MATRIX Variance-covariance matrix HPQ PFE DIS NKE MSFT AAPL HPQ PFE DIS NKE MSET AAPL 1004 GMVP a. Use the return data in the Excel file (link below) for various stocks and the market. (5 points) Compute the returns of the data and the statistics for each of the assets (mean return, variance and standard deviation of return) b. (10 points) Compute the excess returns and then the sample variance covariance matrix for the six stocks. (10 points) Compute the global minimum variance portfolio (GMVP) weights using the sample variance covariance matrix ink to File H PRICE DATA FOR STOCKS AND THE S&P500 COMPUTING THE SAMPLE VARIANCE-COVARIANCE MATRIX Variante www matrix Stock SO SR PE Dis NE MSFT AAR Wan Disney DIS 2050 31 Microso MORY NA NIKE 15 16 Apple AAR 2744 HP PFE 2013 333 NE MIFT AAR 28.67 20.20 3054 20.30 23.01 25.01 2340 244 360 3553 SAPO ASPC 107.01 1104.49 116.43 1116 10041 1090 71 11010 104333 11620 110326 1100 100 Sot Stock Hewitt Packard Prue HPG PFE 4871 1654 4830 170 5063 154 49 50 1400 1321 1129 12. 4393 1356 1600 1454 40 72 15.0 10,20 15.00 40.00 18.00 40.33 10.17 43.77 1685 41 79 17:06 39.32 15 38,75 1957 15.00 20,21 3505 33 87 1:14 CERE Dale 6 Oca 10 Dub 10 10 10 10 May 10 11 H10 12 Tom 10 10 14.10 15 CH10 16 10 17 Ara 10 18 Ocati 19 11 20 MA 1 1 Nis 11 | | | | | 21 11 M Tom 1 GMVP 3684 3342 3150 1300 32.64 3310 12 0151 3731 307 43.74 49,00 4310 41 63 30.04 3862 180 18.00 10. 18.45 17.00 2004 20.30 21.53 21.35 20 62 2220 1890 20 2013 30 22.54 250 2791 49. 43 00 444 4608 841 5046 40. 50.02 132722 1323 136361 1345.20 13306 1290 20 2500 2740 4736 56.78 22 May 11 23 Haz 11 24 Tem. 11 25 Agu. 11 26 Eyl.11 27 Eki 11 28 Kas 11 29 Ara 11 30 Oca 12 31 ub 12 32 Mar.12 33 Nis. 12 34 May. 12 35 Haz. 12 36 Tem. 12 37 Agu. 12 38 Eyl.12 39 Eki 12 40 Kas. 12 41 Ara, 12 35,88 35.05 33,87 25.07 21,74 25.76 27,06 25,05 27.21 24,61 23.29 24.20 22.16 19.77 17.93 16,59 16,90 13,72 12,87 14,25 20,21 19,41 18,14 18,08 16,85 18,35 19,32 20.83 20,60 20.55 22,02 22.27 21,48 22.59 23.61 23,65 24,63 24,65 25.02 25.08 41,63 39,04 38,62 34.06 30.16 34.88 35.85 37,50 38,90 41.99 43.78 43.11 4571 48.50 49.14 49,47 52.28 49.12 49,66 49,79 21.11 22,50 22.54 21.66 21.38 24,09 24.05 24.09 26,00 26,98 27.11 27,97 27.05 21,95 23,34 24,34 23.73 22,84 24,37 25,80 25.01 26,00 27,40 26,60 24,89 26.63 25,58 25,96 29,53 31,74 32.26 32.02 29.19 30.59 29.47 30.82 29,76 28,54 26,61 26,71 49.69 47,95 55,78 54.98 5447 57.83 54,60 57.86 65.21 77,49 85,65 83,43 82,53 83.43 87.25 95,03 95,30 85,05 83,61 76.02 1345,20 1320,64 1292 28 1218.89 1131.42 1253,30 1246,96 1257,60 1312,41 1365,68 1408,47 1397,91 1310,33 1362.16 1379,32 1406,58 1440,67 1412.16 1416,18 1426.19 PRICE DATA FOR STOCKS AND THE S&P500 Date Oca. 10 ub. 10 Mar. 10 Nis. 10 May. 10 Haz. 10 Tem. 10 Au. 10 Eyl. 10 Eki 10 Kas. 10 Ara. 10 Oca. 11 ub. 11 Mar. 11 Nis. 11 May.11 Haz. 11 Tem. 11 Stock1 Stock 2 Stock 3 Stock 4 Stock 5 Stock 6 Hewlett- Walt Packard Pfizer Disney Nike Microsoft Apple HPQ PFE DIS NKE MSFT AAPL 44,77 16,54 29,55 15,94 28,18 27,44 48,30 15.70 31.24 16,90 28,67 29.23 50,63 15.34 34,91 18,38 29,29 33,57 49,50 14.96 36,84 18,98 30,54 37.30 43,83 13,77 33,42 18.09 25,80 36.70 41,29 12.89 31,50 16,89 23,01 35,93 43,93 13,56 33,69 18.41 25,81 36,75 36,69 14,54 32,54 17,50 23,46 34,73 40,22 15.70 33,10 20.04 24,49 40,54 40,20 15.92 36.12 20,36 26.66 43,00 40,09 15.05 36,51 21,53 25,26 44,45 40,33 16,17 37,51 21,36 27,91 46,08 43,77 16,83 38,87 20,62 27.73 48,47 41.79 17.96 43,74 22.26 26,58 50,46 39,32 18,95 43,09 18,93 25,39 49.79 38,75 19,57 43,10 20,58 25,92 50,02 35,88 20,21 41,63 21,11 25.01 49,69 35,05 19,41 39,04 22,50 26,00 47.95 33.87 18,14 38,62 22,54 27,40 55,78 S&P500 AGSPC 1073.87 1104,49 1169,43 1186,69: 1089,411 1030,71; 1101,60 1049,33 1141,20 1183,26 1180,55 1257,64 1286,12 1327.22 1325,83 1363,611 1345,20 1320,64 1292.28 22 May 11 23 Haz. 11 24 Tem. 11 25 Au.11 26 Eyl.11 27 Eki. 11 28 Kas 11 29 Ara, 11 30 Oca. 12 31 ub 12 32 Mar.12 33 Nis. 12 34 May 12 35 Haz. 12 36 Tem. 12 37 Au. 12 38 Eyl.12 39 Eki. 12 10 Kas. 12 11 Ara, 12 35,88 35,05 33,87 25,07 21,74 25,76 27,06 25.05 27,21 24,61 23,29 24,20 22,16 19.77 17.93 16,59 16,90 13,72 12,87 14,25 20,21 19,41 18,14 18,08 16,85 18,35 19,32 20,83 20,60 20,55 22.02 22.27 21,48 22,59 23,61 23,65 24,63 24,65 25,02 25,08 41,63 39,04 38,62 34,06 30,16 34.88 35,85 37,50 38,90 41.99 43,78 43.11 45,71 48,50 49.14 49.47 52,28 49.12 49.66 49.79 21.11 22,50 22,54 21,66 21,38 24,09 24,05 24,09 26,00 26.98 27.11 27,97 27.05 21,95 23,34 24,34 23.73 22,84 24,37 25,80 25,01 26,00 27,40 26,60 24,89 26,63 25,58 25.96 29,53 31,74 32.26 32,02 29.19 30,59 29,47 30,82 29.76 28,54 26,61 26,71 49.69 47.95 55.78 54,98 54,47 57.83 54,60 57.86 65,21 77,49 85,65 83,43 82,53 83.43 87.25 95,03 95,30 85,05 83,61 76,02 1345,20 1320,64 1292,28 1218,89! 1131,42 1253,30 1246.96 1257.60 1312,413 1365,68 1408,47 1397.91 1310.33 1362,16 1379.32 1406,58 1440,67 1412.16 1416.18 1426,19 COMPUTING THE SAMPLE VARIANCE-COVARIANCE MATRIX Variance-covariance matrix HPQ PFE DIS NKE MSFT AAPL HPQ PFE DIS NKE MSET AAPL 1004 GMVP