You will find historical Excess Return data for portfolio S, portfolio Q, and Market Index in the Excel Spreadsheet provided to you.

You need to calculate the followings:

1. The average excess return of portfolio S, Q, and Market Index? Standard deviation of the excess return of portfolio S, Q, and Market Index? By running the regression, what is the alpha, Beta, standard error of each portfolio and Market Index? Sharpe Ratio, Treynor Ratio, Information Ratio, and R-square. Based on Sharpe Ratio, Treynor Ratio, and Information ratio, which portfolio is better? Explain Why?

use the following data.

Month	The excess return of Portfolio S	The excess return of Portfolio Q	The excess return of Index M
1	3.58%	2.81%	2.20%
2	-4.91%	-1.15%	-8.41%
3	6.51%	2.53%	3.27%
4	11.13%	37.09%	14.41%
5	8.78%	12.88%	7.71%
6	9.38%	39.08%	14.36%
7	-3.66%	-8.84%	-6.15%
8	5.56%	0.83%	2.74%
9	-7.72%	0.85%	-15.27%
10	7.76%	12.09%	6.49%
11	-4.01%	-5.68%	-3.13%
12	0.78%	-1.77%	1.41%