The following table, contains annual retums 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 standard deviation of annual returns over the 10-year period for ABC, XYZ, and of the equally-weighted portfolio of ABC and XYZ over the 10-year period. (Hint: Review the Excel screenshot on page 173.) Paide vo The average annual return for ABS-Comp. over the 40-year period to me (Enteras e percentage and round to-twe decimal places.) Data Table 0.9% TOO (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 18. ABC Returns XYZ Returns 2005 -4.2% as- 17.1% 2006 -8.6% 2007 2 - 32.6% SOOS - 26.5% 2008 dere - 10.6% SOOS - 3.2% 2009PTAS 29.5% Cros 10.9% 2010 PSS 25.9% POS 9.9% 2011 23.3% TOS 5.9% 2012 SITE 50.6% CTOS 42.1% 2013 8.0 38.5% FOS 40.2% 2014 31.9% 39.6%