The following table contains albums for the stocks of ABC Corp (ABC) and XYZ Corp. DYZ) The mend using end of yew promised for evidence and sodom http:www.finance.yahoo.com Use Excel to create a present that ca thelum id portfolio of the stocks would have an each year. Then the evergreen derd door each stock over this period. Next, the average retum and standard deviation for a portfolio Painel 50% in HD and so in LOW. What is the correlation between Hand LOW sumie period? The werage portfolio return for 2005 (Enter as a percentage and round to two decimos) The average portfolio barn for 2005 is Enter as a percentage and round to two decimal places) The average portfolio retum for 2007 serasa percentage and round to be decimal plac The average portfolio return for 2008 in Enter as a percentage and round to decimal places) The average portorum for 2009 Enter as a percentage and round to the decimales) The were portato return for 2010 ( Esperitage and round to two decima) The average portfolio return for 2011 sa percentage and round ta two decionada The average portfolio turn to 2012 ma percentage and und in two decimal The were portfolio run for 2013 rasa percentage und round to deal The rage portfolio return for 2014 Enter as a percentage and found a decimal place) The wag porto run for 2015 Fra percentage and und dem The average portreturn fat 2016 Enter a percentage and we The werage porn 2017 as a percentage and we demais The average an for ABC Curves perce and round (Enter as a percentage and round to two decimal places.) The average portfolio return for 2014 is %. (Enter as a percentage and round to two decimal places.) The average portfolio return for 2015 is % (Enter as a percentage and round to two decimal places.) The average portfolio return for 2016 is %. (Enter as a percentage and round to two decimal places.) The average portfolio return for 2017 is %. (Enter as a percentage and round to two decimal places.) The average annual return for ABC Corp. over this period is % (Enter as a percentage and round to two decimal places) The average annual return for XYZ Corp. over this period is %. (Enter as a percentage and round to two decimal places.) The standard deviation for ABC Corp. over this period is %. (Enter as a percentage and round to two decimal places) The standard deviation for XYZ Corp. over this period is % (Enter as a percentage and round to two decimal places.) The average annual return for a portfolio that invests 50% in HD and 50% in LOW over this period is % (Enter as a percentage and round to two decimal places) The standard deviation for a portfolio that invests 50% in HD and 50% in LOW over this period is % (Enter as a percentage and round to two decimal places) The correlation between HD and Low returns over this period is (Round to two decimal places.) Enter your answer in each of the answer boxes. MacBook Air DOD OOOF 2.2 esc 3 FS k on the icon here in order to copy its contents of the data table below readsheet.) XYZ Returns 17.4% -6.9% - 27.6% - 3.3% 10.6% Year 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 ABC Returns -5.6% 1.8% - 30.6% - 12.6% 30.9% 25.4% 22.9% 51.9% 35.5% 29.4% 26.8% 4.2% 45.4% 8.6% 4.2% 41.4% 42.2% 39.1% 11.4% -0.1% 26.7% Print Done percentage and round to two decimal places.)