Internet exercise. Find the Standard & Poor's 500 annual returns for 2000 to the present. Go to Yahoo! Finance (https:/finance yahoo.com), and in the search field, enter SPY (the ticker symbol for the Standard & Poors 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, only apply for the answers you will type 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? (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? Standard deviation of Large Company Stocks 14.532% 19.261% Comapny Stocks 8.74% 1960-1969 1970-1979 Enter your answer in each of the answer boxes. How does it compare with the data presented in the table below? Average Return of Large ear 1960-1969 1970-1979 1980-1989 1990-1999 8.74% 7.55% 18.24% 18.99% Standard deviation of Large Company Stocks 14.532% 19.261% 12.657% 14.207% The return for the period 2000 to 2013 sany ten-year period in the table from 1960 to 199, (Belect from the drop-down menu.) any ten-year period in the table from 1960 to 1999. (Select from the drop-down menu.) yer peiod nh The standard deviation for the period 2000 to 2013 is any ten-year period in the table from 1960 to 1999. (Select from the drop-down menu.) Internet exercise. Find the Standard & Poor's 500 annual returns for 2000 to the present. Go to Yahoo! Finance (https:/finance yahoo.com), and in the search field, enter SPY (the ticker symbol for the Standard & Poors 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, only apply for the answers you will type 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? (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? Standard deviation of Large Company Stocks 14.532% 19.261% Comapny Stocks 8.74% 1960-1969 1970-1979 Enter your answer in each of the answer boxes. How does it compare with the data presented in the table below? Average Return of Large ear 1960-1969 1970-1979 1980-1989 1990-1999 8.74% 7.55% 18.24% 18.99% Standard deviation of Large Company Stocks 14.532% 19.261% 12.657% 14.207% The return for the period 2000 to 2013 sany ten-year period in the table from 1960 to 199, (Belect from the drop-down menu.) any ten-year period in the table from 1960 to 1999. (Select from the drop-down menu.) yer peiod nh The standard deviation for the period 2000 to 2013 is any ten-year period in the table from 1960 to 1999. (Select from the drop-down menu.)