P311 (SllllllllU) WeSUl reply The following table, contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp. (XYZ). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits) retrieved from http://www.finance.yahoo.com/. Use the information to create an Excel spreadsheet that calculates the correlation coefficient for ABC and XYZ annual returns. (Hint: Review the Excel screenshot on page 174) The correlation coefficient is I. (Round to five decimal places.) (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Year 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 A Returns - 3.5% 2.2% - 30.9% - 10.7% 29.4% 25.4% 23.7% 52.2% 38.8% 29.2% XYZ Returns 17.5% -6.8% - 25.5% -3.2% 10.5% 10.6% 4.9% 41.5% 42.3% 40.8%