Hi, I posted this question earlier and just realized I had the wrong table loaded. Please help with this, thanks. Disregard the first table in the pictures.
Yearly returns from 1929-1940 for the S&P 500, small stocks, corporate bonds, world portfolio, Treasury bills, and inflation (as measured by the CPI). Year S&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills CPI 0.50467 0.07692 0.04321 1929 0.08907 0.04737 0.00746 0.02347 0.06420 1930 0.25257 0.45583 0.06343 0.22574 0.43858 0.01023 0.09235 1931 0.50216 0.02380 0.39305 0.08696 0.03030 0.00806 1932 0.08861 0.12198 0.10465 0.05255 0.00293 1933 0.52895 1.87200 0.66449 0.000974 0.02552 0.25209 1934 0.02341 0.09728 0.00155 0.01286 0.06860 1935 0.47208 0.64739 0.22782 0.00165 0.03175 0.06220 1936 0.32801 0.87508 0.19283 0.00175 0.01231 0.53403 0.03040 1937 0.35258 0.02546 0.16950 0.00319 0.02950 1938 0.33199 0.26275 0.04357 0.05614 0.00041 0.04247 1939 0.00910 0.00184 0.01441 0.00008 0.0000 0.00058 1940 0.10082 0.12340 0.04512 0.03528 0.00912 la la Print Done Using the data in the table Ea a. What was the average dividend yield for the S&P 500 from 2002-2014? b. What was the volatility of the dividend yield? c. What was the average annual return of the S&P 500 from 2002-2014 excluding dividends (ie, from capital gains only)? d. What was the volatility of the S&P 500 returns from capital gains? e. Were dividends or capital gains a more important component of the S&P 500's average returns during this period? Which were the more important source of volatility? a. What was the average dividend yield for the S&P 500 from 2002-2014 The average dividend yield is (Round to two decimal places.) b. What was the volatility of the dividend yield? The volatility of the dividend yield is the square root of the variance of dividend yields (Round to two decimal places.) c. What was the average annual return of the S&P 500 from 2002-2014 excluding dividends (ie, from capital gains only? 1%. The average annual return is (Round to two decimal places.) What was the volatility of the S&P 500 returns from capital gains? Annual volatility of returns is the square root of the variance of returns L% (Round to two decimal places.) e. Were dividends or capital gains a more important component of the S&P 500's average returns during this period? Which were the more important source of volatility? (Select from the drop-down menu.) were more important for returns and volatility Yearly returns from 1929-1940 for the S&P 500, small stocks, corporate bonds, world portfolio, Treasury bills, and inflation (as measured by the CPI). Year S&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills CPI 0.50467 0.07692 0.04321 1929 0.08907 0.04737 0.00746 0.02347 0.06420 1930 0.25257 0.45583 0.06343 0.22574 0.43858 0.01023 0.09235 1931 0.50216 0.02380 0.39305 0.08696 0.03030 0.00806 1932 0.08861 0.12198 0.10465 0.05255 0.00293 1933 0.52895 1.87200 0.66449 0.000974 0.02552 0.25209 1934 0.02341 0.09728 0.00155 0.01286 0.06860 1935 0.47208 0.64739 0.22782 0.00165 0.03175 0.06220 1936 0.32801 0.87508 0.19283 0.00175 0.01231 0.53403 0.03040 1937 0.35258 0.02546 0.16950 0.00319 0.02950 1938 0.33199 0.26275 0.04357 0.05614 0.00041 0.04247 1939 0.00910 0.00184 0.01441 0.00008 0.0000 0.00058 1940 0.10082 0.12340 0.04512 0.03528 0.00912 la la Print Done Using the data in the table Ea a. What was the average dividend yield for the S&P 500 from 2002-2014? b. What was the volatility of the dividend yield? c. What was the average annual return of the S&P 500 from 2002-2014 excluding dividends (ie, from capital gains only)? d. What was the volatility of the S&P 500 returns from capital gains? e. Were dividends or capital gains a more important component of the S&P 500's average returns during this period? Which were the more important source of volatility? a. What was the average dividend yield for the S&P 500 from 2002-2014 The average dividend yield is (Round to two decimal places.) b. What was the volatility of the dividend yield? The volatility of the dividend yield is the square root of the variance of dividend yields (Round to two decimal places.) c. What was the average annual return of the S&P 500 from 2002-2014 excluding dividends (ie, from capital gains only? 1%. The average annual return is (Round to two decimal places.) What was the volatility of the S&P 500 returns from capital gains? Annual volatility of returns is the square root of the variance of returns L% (Round to two decimal places.) e. Were dividends or capital gains a more important component of the S&P 500's average returns during this period? Which were the more important source of volatility? (Select from the drop-down menu.) were more important for returns and volatility
