use Microsoft excel and show formulas you used.

In the past five years, the market portfolio's average return was 11.0%, the market portfolios standard deviation was 31.0%, and the riskfree rate was 3.5%. During the same period, the table below lists the average return, standard deviation, beta, and non-systematic risk of six portfolios. Port Ave Return Port Std Dev Port Beta Port Non-sys Risk Port 4 7.3% 31.4% 1.8 0.8 7.2% 24.8% Port 1 Port 2 Port 3 15.3% 12.4% 13.8% 25.0% 37.0% 43.8% 0.7 1.3 18.5% 19.9% Port 5 1.9% 26.3% 0.4 24.5% Port 6 11.0% 47.3% 1.9 12.6% What has been the performance of each portfolio? Which portfolio did the best