Part d) Year Vacumin Returns 0.27 0.275 0.275 0.275 0.275 0.275 (1.275 0.275 0.275 0.275 Umbrellas Returns 0.5 0.45 0.4 035 0.3 0.25 0.2 0.15 0.1 0.05 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 Expected Retum Variance Standard Deviation 0.275 3,42388E-33 5.85139E-17 0.275 0.0229166667 0.151382518 Covarianace Correlation Weight Vacum Weight Umbrella -2.22552E-33 -2.51245E-16 0.5 0.5 1 0 0.9 0.1 0.8 0.2 0.7 0.3 0.6 0,4 0.5 0.5 0.3 0.7 0.2 0.8 0.1-9.992011-1 0.9 1 0.6 Expected Portfolio Return Portfolio Variance Portfolio Standard Deviation 0.275 0.00572916667 0,0756912589 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 3.43388E-33 0.0002291667 0.0000167 0.0020625 0.0036667 0.0057292 0.00825 0.0112292 0.0146667 0.0185625 0.0229167 5.85139E-17 0.0151382518 0.0312765 0.0454148 (2.060553 0,0756913 0.X1908295 0.1059678 0.121106 0.1362443 0.1513825 Assignment: You are provided with multiple year retum information for four scenarios in parts a) through d). Please calculate the expected returns, variances, standard deviations, covariances, and correlations for each part. The answers are provide for your guidance but you must replace the raw numbers with the appropriate equations or Excel functions. Please note that when you assign weights for a two-security portfolio, one weight will be "x" and the other will be "I-X". Graph the results for each each part placing the standard deviations on the horizontal axis and returns on verticle axis. Part d) Year Vacumin Returns 0.27 0.275 0.275 0.275 0.275 0.275 (1.275 0.275 0.275 0.275 Umbrellas Returns 0.5 0.45 0.4 035 0.3 0.25 0.2 0.15 0.1 0.05 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 Expected Retum Variance Standard Deviation 0.275 3,42388E-33 5.85139E-17 0.275 0.0229166667 0.151382518 Covarianace Correlation Weight Vacum Weight Umbrella -2.22552E-33 -2.51245E-16 0.5 0.5 1 0 0.9 0.1 0.8 0.2 0.7 0.3 0.6 0,4 0.5 0.5 0.3 0.7 0.2 0.8 0.1-9.992011-1 0.9 1 0.6 Expected Portfolio Return Portfolio Variance Portfolio Standard Deviation 0.275 0.00572916667 0,0756912589 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 0.275 3.43388E-33 0.0002291667 0.0000167 0.0020625 0.0036667 0.0057292 0.00825 0.0112292 0.0146667 0.0185625 0.0229167 5.85139E-17 0.0151382518 0.0312765 0.0454148 (2.060553 0,0756913 0.X1908295 0.1059678 0.121106 0.1362443 0.1513825 Assignment: You are provided with multiple year retum information for four scenarios in parts a) through d). Please calculate the expected returns, variances, standard deviations, covariances, and correlations for each part. The answers are provide for your guidance but you must replace the raw numbers with the appropriate equations or Excel functions. Please note that when you assign weights for a two-security portfolio, one weight will be "x" and the other will be "I-X". Graph the results for each each part placing the standard deviations on the horizontal axis and returns on verticle axis