1) Choose an ETF share. (You can browse them on ETFdb.com for example). What are the underlying assets to the best of your knowledge? Can you explain when you should expect the value of the share to increase or decrease? Now download historical monthly prices on excel and measure the following statistics Monthly returns Standard deviation of the returns Sharp ratio Skewedness Kurtosis LPSD Sortino ratio VaR (596) Expected Shortfall (596) Send you excel file (which shows your calculations) to Shichen. Report the result on your hard copy of assignment 2) Suppose your expectations regarding the stock price are as follows State of the Market Boom Normal Growth Recession Probability 0.35 0.30 0.35 HPR(including dividends) 33.5% 19.0 15.5 Compute the mean and standard deviation of the HPR on the stocks