please show work in excel

You invest 1 million dollars into a portfolio of four stocks, as provided below. The risk-free rate is 4% and the expected return on the market is 11%. a. What is the beta of this portfolio? b. What is the expected return for the portfolio? c. Which stock has the greatest market risk? d. Which stock has the greatest stand-alone risk? e. Which stock appears to be the best single investment? Explain your