Need some help with Excel formatting. Correct answers are shown to the right of the bolded boxes but need them entered using excel.

A D 31 1 Ford Run M stum WMT an Foto Letum -10.12% 17.05 4. 12.12% 10 IS K.79 2015 7.IT 4.17% -2.00% 1 This is the Real Price Data for IBM and WMT from 2007 to 2017 2 Waista vart 70% WMT IBM Retra WMT BE 12/31/0 $ 10.10 5 12/31/ 165 6 12/31/03 1200 3 5145 7 12/31/105 14.MS 12/01 IKE 27 12/31/12 5 191.58 $ 10 12/31/13 17.57 7. 12/31/14 100 S. 12 12/31/15 1. 15 12/10 15.90 5 12 14 12/23 15342 3 9.75 15 16 Average Return 17 wake IK Sadard Deviario 19 20 Covare 21 Certi 1417% 15.33% 9.14% -14.22 20161% -7.57% -7. -IK.54% IK.22 7.50% 12. W 2.TK 0.00 D. 22.25% 17.2 - -0.10 0.000 23 Variace od okolo with 70% weigh in Mand 30% weight in WMT: Plau awain de 31 24 Standard Deviation of Polo with 70% weigh in Mand 30% weight in WMT: peau afla in de 31 2. Calculate the Portfolio return and standard deviation with direction of Pollowige 27 Weight in AM Welge in WMT Failam Feeded 0% 10% 19% 0% 18% 31 12 Forma Fortfolio Standard Deviaria 17.20 KO K 73% 15.31% K. 14. K. 13.774 K.239 13. K. 12.7 7. 12.54 12. 28% 70% 65% 15 35% 37 30% 12.TK 38% 30% 48% 40% w 7. 1396 14 41 42 70 75% 20% 25% 45 10.19 6.73% 6.5% 6 6.25% 15% 10% 3% 0% IK. 68% 19. 21.01% 22.29% 47 95% 100% 3. 3.72% 30 Drawicie Froer weg direction of poor and ndard deviation above Tilent Irontier 36 30 45 67 A. e Plan Calculate Welight of Milan Variance Follo Weight of 70 Weig WMT 71 72 Pleie Meerdere 7 Plan Calculate Milan Variance pro Standard De 74 75 12470% 10. A D 31 1 Ford Run M stum WMT an Foto Letum -10.12% 17.05 4. 12.12% 10 IS K.79 2015 7.IT 4.17% -2.00% 1 This is the Real Price Data for IBM and WMT from 2007 to 2017 2 Waista vart 70% WMT IBM Retra WMT BE 12/31/0 $ 10.10 5 12/31/ 165 6 12/31/03 1200 3 5145 7 12/31/105 14.MS 12/01 IKE 27 12/31/12 5 191.58 $ 10 12/31/13 17.57 7. 12/31/14 100 S. 12 12/31/15 1. 15 12/10 15.90 5 12 14 12/23 15342 3 9.75 15 16 Average Return 17 wake IK Sadard Deviario 19 20 Covare 21 Certi 1417% 15.33% 9.14% -14.22 20161% -7.57% -7. -IK.54% IK.22 7.50% 12. W 2.TK 0.00 D. 22.25% 17.2 - -0.10 0.000 23 Variace od okolo with 70% weigh in Mand 30% weight in WMT: Plau awain de 31 24 Standard Deviation of Polo with 70% weigh in Mand 30% weight in WMT: peau afla in de 31 2. Calculate the Portfolio return and standard deviation with direction of Pollowige 27 Weight in AM Welge in WMT Failam Feeded 0% 10% 19% 0% 18% 31 12 Forma Fortfolio Standard Deviaria 17.20 KO K 73% 15.31% K. 14. K. 13.774 K.239 13. K. 12.7 7. 12.54 12. 28% 70% 65% 15 35% 37 30% 12.TK 38% 30% 48% 40% w 7. 1396 14 41 42 70 75% 20% 25% 45 10.19 6.73% 6.5% 6 6.25% 15% 10% 3% 0% IK. 68% 19. 21.01% 22.29% 47 95% 100% 3. 3.72% 30 Drawicie Froer weg direction of poor and ndard deviation above Tilent Irontier 36 30 45 67 A. e Plan Calculate Welight of Milan Variance Follo Weight of 70 Weig WMT 71 72 Pleie Meerdere 7 Plan Calculate Milan Variance pro Standard De 74 75 12470% 10