i just need help with c. using excel formulas.

:L:G: alll 92% 8:01 AM X Question aCompute the average retum for each of the assets from 1929 to 1940 The Great Depression). .Which asset was nskiest during the Great Depression? How does that fit with your intuition? Compute the variance and standard deviation for each of the assets from 1929-1940. Compute the average retum for each of the assets from 1929 to 1940 (The Great Depression). S&P 500 Small Stecks Corp Bonds World Portfolio Treasury Balls Average retum 15.650%[ 29409T b. Compute the variance and standard deviation for each of the assets from 1929-1940 S&P 500 Small Stocks Corp Bonds World Portfolio TreasSurY Bills 0.1018 31.904% 12 4995 71.0356 e. Which asset had the highest standard deviation during the Great Depression? How does that fit with your intuition Most Volatile Asset 71.0356 Which? Does the asset with the highest average retum also have the highest variance of retums P 500 Small Stoeka Corp Honds World Pertfolie Treary Billa 0.062852 0.257543 0.433079 0334633 0.504667 0.455830 0.50216 0.086957 1930 0.252573 0.438580 0.085612 0.063433 0.225738 0 393052 0 023474 0 092343 0.104651 0009740 0012362 0 008055 0 052552 -0.023405 0.47208) 0.325010 0.352577 0.252089 0.025524 0.227824 0.192827 0.062197 0.025456 0.043571 0.042473 0001749 0.262751 0.100823 0.117673 -0,123396 0.137282 0.035282 0.187439 0.011890 0.000582 0.002616 0.003396 0 003215 0 09041 48 49 0.033643 0.257576 0.196935 0 024450 0 021480 0.102399 0.604078 0.326647 0.126085 0,035119 0.025378 -0.081804 0.052401 0.003521 0.004611 0.009790 0 011051 0.066086 0.043267 0.234772 0.305792 the VAK fianction and cell 7 In cell F18, by using the VAR fanction and cell references, calculate the viriance of retuens for the Samul Stocks (l p) 8 in cell G18, by using the VAR function and cell teferences, ealeidate the p 9 In cell IHIS, by using the VAR function and cell references,calculate the variance of cetums for the Wold Porfide ( p) 10 In cell 118, by using the VAR function and cell references, calculate the variancn of setums for the Treasuay Bils(1 p) 11 In cell E19, by using the STDEV flanction and cell refreences, cakulate the standard deviation of retums for the Sa3 500 variance of setums for the Corp Bonds ( er for 12 In cell F19, by using the STDEV flanction and cell referenees, calculate the standard deviation of retums for the ea Stocks (I pt) Bonds (1 pt.) Portfolie (I pt.) 13 In cell G19, by using the STDEV function and cell refeences, caleculate the standard deviation of retums fee the Corp 14 In cel H19, by using the STDEV fiunction and cell references, calculate the standard deviation ef retuns for 1s In cell I19, by usin 16 In cell E23, by usin 17 In cell G23, type either s.&P 500, Small Stocks, Corp Bonds, World Pertfelilo or Tre g the STDEV function and cell references, calculate the standard deviation of retums for the Treasuary g cell references, calculate the highest standard deviation of retuns from all the assets (I pe) Nete Use the Excel function MAX asset has the highest standard deviation of retums (1 pt.) hiahact aerage retun from all