&Poor's 500 annual returns for 2000 to the present. Go to Yahoo! Finance (htps/finance.yahoo.com), and in the search Internet exercise. Find the Standard field, enter SPY (the ticker symbol for the Standard &Poor's 500 exchange-traded fund). Select historical data, and find the year-end prices for the fund (use close price) and all dividends from 2000 through the end of 2013. Find each year's return (remember to add in the dividend distributions for the year). What was the arithmetic average annual return? What was the standard deviation? How does the standard deviation compare with the data in Table 8.1? Click on the Spreadsheet Learning Aid to see Table 8.1-Year-by-Year Returns, 1950-1999 Hint Make sure to round all intermediate calculations to at least seven (7) decimal places. The input instructions, phrases in parenthesis after each answer box, on apply for the answers you will type What is the return for each year? (Round to two decimal places.) Annual Return 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 What is the arithmetic average return of the Standard & Poor's 500 for the years 2000 to 2013? Li% (Round to two decimal places.) What is the standard deviation of the Standard& Poor's 500 from 2000 to 2013 %(Round to three decimal places) How does it compare with the data presented in the table below? Average Return of Large Comapny Stocks 1960-1969 1970-1979 1980-1989 1990-1999 Standard deviation of Large Company Stocks 14.532% 19.261% 12.657% 14 207% 755% 1824% 18 99% Enter your answer in each of the answer boxes