not sure what I am getting wrong on this. when I submit it is not right. help!!! it does require all excel references which are in the numbers.

a Compute the average retum for each of the assets from 1929 to 1940 (The Great Depression) b. Compute the variance and standard deviation for each of the assets from 1929-1940. c. Which asset was riskiest during the Great Depression? How does that fit with your intuition? a. Compute the average retum for each of the assets from 1929 to 1940 (The Great Depression). S&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills Average retum 2.55290 15.650 O 2.940%[ 2.940 0.834 b. Compute the variance and standard deviation for each of the assets from 1929-1940. Treasury Bills 0.0002 1.400% Corp Bonds World Portfolio 0.0697 26.398% S&P 500 Small Stocks 0.1018 0.5046 0.0013 Variance of returms Standard deviation 31.90490| 71.035oof 3.589001 c. which asset had the highest standard deviation during the Great Depression? How does that fit with your intuition? Most Volatile Asset Highest average retum Does the asset with the highest average retum also have the highest variance of retuns 71.035%) 15.650%! which? which? |Small Stocks Ismall Stocks Yes