he following table contains annual retums for the stocks of Company A (A) and Company B (B). The retums are calculated using end-ofyear prices (adjusted for dividends and stock splits) retrieved from Atp://www.finance.yahoo.com. Use Excel to create a spreadsheet that calculates the retum that an equally weighted portfolio of these two stoka would have eamed in each year. Then, calculate the average nhum and standard deviation for each stock over this period. Next, the average return and standard deviation for a portofe that invest Gos in HD and 50% in LOW. What is the commotion between HD and LOW tums over this period? The average portello return tor 2005 x (Enter as a percentage and round to two decimal place? - X Data table 2007 (Click on the son here in order to copy its contents of the datatable below into a spreadsheet) Year A Returns Returns 2005 -3.4% 16.15% 2008 15% - 8.0% - 31.9% -27.1% 2008 - 12:49 -35N 2009 29.3 0.8% 2010 25.7 103 011 22.7% 3.7 2012 51.0 42. 2013 30. 41.5% 2014 2009 389% 2018 200 110% 2016 3.6 -0.24 44.2 279 2017