I have problem om this question. I finish part a. on calulating, but I cannot find way to do comparisons on excel to answer part a last question. Also, I need help on part b too. Thank you!

MINI-CASE hn and Marsha on Portfolio Selection Jo John and Marsha hold hands in a cozy French restaurant in downtown Manhattan, The scene a $125 financiere The Wall Street Journal by candlelight. l vears before the mini-case in Chapter 9. Marsha is a futures-market trader. John manages lion common-stock portfolio for a large pension fund. They have just ordered tournedos for the main course and flan financiere for dessert. John reads the financial pages of Wow! Potato futures hit their daily limit. Let's add an order of gratin dauphinoise. Did you manage to hedge the forward interest rate on that euro loan? Marsha: John, please fold up that paper. (He does so reluctantly) John, I love you. Will you marry ? Johe: Oh, Marsha. I love you too, but.. there's something you must know about me-something I've never told anyone Marsha: (concerned) John, what is it? John: I think I'm a closet indexer. Marsha: What? Why? John: My portfolio returns always seem to track the S&P 500 market index. Sometimes I do a littl better, occasionally a little worse. But the correlation between my returns and the market returns is over 90%. Marsha: What's wrong with that? Your client wants a diversified portfolio of large-cap stocks. Of John: Why doesn't my client just buy an index fund? Why is he paying me? Am I really adding Marsha: Oh, John, I know you're adding value. You were a star security analyst course your portfolio will follow the market. value by active management? I try, but I guess I'm just an... indexer John: It's not easy to find stocks that are truly over- or undervalued. I have firm opinions abouta few, of course. ha: You were explaining why Pioneer Gypsum is a good buy. And you're bullish on Global Mining. John: Ri Right, Pioneer. (Pulls handwritten notes from his coat pocket) Stock price $87.50. I esti- mate the expected return as 11% with an annual standard deviation of 32%, nha: Only 11%? You're forecasting a market return of 12.5%