Please answer each part, and for the excel part, please use that format/layout in the second picture to complete the problem. thanks

Quiz 5 Q1. State Recession Neutral Boom probability a particular state occurs 0.25 0.50 0.25 stock return in a particular state 30% 15% -10% a) What is the expected return of this stock? b) What is variance and standard deviation of this stock? Using the formula. c) What is variance and standard deviation of this stock? Using Excel. Copy and paste your Excel table here. B 1 probability of a particular state 2 stock return when a particular state occurs 3 par probability times return 4 ES expected return 5 diff difference between rand Es 6 diffaz square the difference 7 p'diff^2) probability times square of the difference B 9 10 state par ES diff diff^2 11 recession 0.25 30% 12 neutral 05 15% 13 boom 0.25 -10% 14 15 variance 16 standard deviation 17 18 19 p"(diff^2) O Sum of column H 0.00% Square root of variance