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 decimal places. The input instructions (phrases in parentheses after each answer box) apply for the answers you will type. What is the return for each year? (Round to two decimal places.)
Year
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: Average Return of Large Company Stocks and Standard Deviation of Large Company Stocks
1960-1969: 8.74% (average return), 14.532% (standard deviation)
1970-1979: 7.55% (average return), 19.261% (standard deviation)
1980-1989: 18.24% (average return), 12.657% (standard deviation)
1990-1999: 18.99% (average return), 14.207% (standard deviation)
Enter your answer in each of the answer boxes.