Show detailed steps to solve the following questions. You can work with an Excel spreadsheet, or show your steps in Word document. 1. Calculate the Expected Rate, Standard Deviation, Variance and Coefficient of variation and decide which of the following company is better for investment. 2. Consider a portfolio comprised of three securities in the following proportions and with the indicated security beta. a. What is the portfolio's beta? b. What is the portfolio's expected return