Please use cell refrences (=B3+B4, etc) to calculate the answers

a. Compute the average return for each of the assets from 1929 to 1940 (The Great Depression) S&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills b. Compute the variance and standard deviation for each of the assets from 1929-1940 S&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills Standard deviation c. Which asset had the highest standard deviation during the Great Depression? How does that fit with your intuition? Most Volatile Asset Which? Which? 2 est average return Does the asset with the highest average return also have the highest variance of returns? rFigur Yearly returns from 1926-2015 for the S&P 500, small stocks, corporate bonds, world portfolio, Treasury bills, and inflation (as Corp BondsWorld Portfolio Treasury Bills 3 0 3 5 2 0 1 2 2 0 1 2 0 3 3 0 5 a. Compute the average return for each of the assets from 1929 to 1940 (The Great Depression) S&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills b. Compute the variance and standard deviation for each of the assets from 1929-1940 S&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills Standard deviation c. Which asset had the highest standard deviation during the Great Depression? How does that fit with your intuition? Most Volatile Asset Which? Which? 2 est average return Does the asset with the highest average return also have the highest variance of returns? rFigur Yearly returns from 1926-2015 for the S&P 500, small stocks, corporate bonds, world portfolio, Treasury bills, and inflation (as Corp BondsWorld Portfolio Treasury Bills 3 0 3 5 2 0 1 2 2 0 1 2 0 3 3 0 5