Question: hi, can you help me to : 1. do the variance-covariance matrix in exhibit 3 2. help to plot the correlation coefficient from range +ve
hi, can you help me to :
1. do the variance-covariance matrix in exhibit 3
2. help to plot the correlation coefficient from range +ve 1 to -ve 1



EXHIBIT 2: QUARTERLY RETURNS (BY PERCENTAGE) OF SHARMA'S SELECTED FUNDS, 2009 TO 2013 Fund # MF1 MF21 MF3 MF4 MF5 MF6 MF7 MF8 MF9 MF10 Quarter 200901 200902 2009Q3 200904 201001 201002 201003 201004 2011 01 201102 201103 201104 201201 201202 201203 201204 2013 Q1 2013 Q2 201303 201304 2.90 41.60 19.20 -0.20 3.40 2.90 15.40 1.20 -2.60 -1.00 -9.40 -2.40 12.70 -0.60 8.10 4.40 -4.90 1.80 1.30 10.00 0.101 44.30 23.401 -0.20 1.90 6.10 16.20 0.20 -5.80 -2.50 -8.70 -4.00 17.10 -1.90 8.60 3.80 -3.90 -0.60 -1.10 12.30 -13.70 66.00 30.50 14.10 9.20 9.40 14.20 -4.40 -14.70 1.50 -5.20 - 13.50 20.00 0.40 9.60 4.50 -15.80 -0.70 -4.50 24.90 -14.70 66.20 15.70 -0.20 4.60 0.20 19.10 0.10 -9.00 4.901 -1.400 -8.10 14.60 3.10 10.20 13.00 -12.50 -1.70 -8.40 13.10 -6.400 47.50 27.40 -0.20 5.40 5.00 18.30 -2.60 -7.30 2.60 -8.90 -8.50 21.10 1.40 10.70 5.40 -7.90 -3.10 -4.30 19.50 -11.40 49.10 19.80 5.60 1.80 0.40 14.30 -1.90 -4.90 -2.70 -10.70 -7.30 17.80 -3.20 9.30 5.20 1.90 2.10 17.00 16.30 -1.00 37.60 14.10 8.50 4.00 6.701 9.90 0.60 -3.10 4.60 -5.10 -6.60 15.50 -0.80 6.20 2.50 -5.80 -0.30 -2.30 15.40 -4.20 47.00 18.20 -0.20 4.10 6.60 12.50 -0.70 -3.20 1.60 -6.80 -7.50 16.00 -1.100 6.50 5.10 -8.60 -0.40 -7.30 17.10 7.40 4.70 1.80 1.70 1.20 5.70 1.40 1.10 1.20 1.10 1.40 3.201 2.00 3.40 2.00 2.40 2.60 5.20 -6.60 1.30 10.40 4.10 7.70 -0.20 -2.80) 14.20 1.50 7.30 1.30 4.90 19.20 2.00 3.80 3.500 5.20 -2.301 -2.80 -15.60 16.00 -7.60 Source: www.moneycontrol.com, accessed on January 31, 2014. Summary of Return and Risk Fund Name Cap Fund # MF1 MF2 MF3 MF4 ICICI Quantum DSP-BR Pru Long Micro SBI Focused Term Emerging Bluechip Equity Fund - Busi (G) Eqty G) RP (G) 5.19% 5.27% 6.59% 5.44% 22.43% 22.78% 29.08% 23.60% 1.15% 1.47% 3.51% 2.85% 4.61% 5.89% 14.06% 11.42% 21.47% 24.26% 37.49% 33.79% MFS MF6 MF7 MFS MF9 MF10 ICICI Reliance Pru Birla Sun R* HDFC HDFC Equity Exp&Oth Life GSec] Shares Formula in previous Balanced Prudence Oppor - er -LTF Golld column Fund (G) Fund (G) RP (G) Services ETF RP (G) 5.76% 5.93% 5.03% 4.74% 2.21% 3.08%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
