what would the formula be in the excel. please provide with formulas in step for excel.

these two stocks. Each company is risky, which means we do not know what exactly is going to happen to them next year. However, we have some ideas on what might happen to each of the companies depending on what happens to the economy next year. These stocks are expected to behave differently in different economic situations as follows: (I recommend you copy the table to an Excel file, work on it, and copy back the clean answer table here) Calculate the expected rate of return and the standard deviation of the expected return for Alpha, Beta, a portfolio consisting of 50\% in Alpha and 50% in Beta (call it, Portfolio 1). a portfolio consisting of 80% in Alpha and 20% in Beta (call it, Portfolio 2) Find: a) expected returns ( r-hat) for Alpha, Beta, Portfolio 1, and Portfolio 2 b) the standard deviations for Alpha, Beta, Portfolio 1, and Portfolio 2 c) Coefficient of variation for each of these (I recommend you copy the table to an Excel file, work on it and copy back the clean answer table here)