Spreadsheet Problem Below are the monthly returns for May 2005 to October 2010 of three international stock indices: All Ordinaries of Aus- tralia, Nikkei 225 of Japan, and FTSE 100 of England. 

a. Compute and compare each index's monthly average return and stan- dard deviation.

b. Compute the correlation between (1) All Ordinaries and Nikkei 225, (2) All Ordinaries and FTSE 100, and (3) Nikkei 225 and FTSE 100, and compare them.

c. Form a portfolio consisting of one-third of each of the indexes and show the portfolio return each year, and the portfolio's return and standard deviation.

Transcribed Image Text:

Date Oct. 10 Sep. 10 All Ordinaries (Australia) Nikkei 225 (Japan) 2.08% -1.78% 6.18 FTSE 100 (England) 2.28% 6.19 -0.62 4-46 Aug. 10 -1.52 -7.48 Jul. 10. 4.22 1.65 6.94 Jun. 10 -2.89 -3.95 -5.23 May 10 -7.87 -11.65 -6.57 Apr. 10 -1.21 -0.29 Mar. 10 5.20 9.52 -2.22 6.07 Feb. 10 1.18 -0.71 3.20 Jan. 10 -5.85 -3.30 -4.15 Dec. 09 3-55 12.85 4.28 Nov. 09 1.48 -6.87 2.90 Oct. 09 -1.95 -0.97 -1.74 Sep. 09 5.69 -3.42 4.58 Aug. 09 5.52 1.31 6.52 Jul. 09 7.64 4.00 8.45 Jun. 09 3-53 4.58 -3.82 May 09 1.83 7.86 4.10 Apr. 09 6.01 8.86 8.09 Mar. 09 7.14 7.15 2.51 Feb. 09 -5.21 -5.32 -7.70 Jan. 09 -4-95 -9-77 -6.42 Dec. 08 -0.36 4.08 3.41 Nov. 08 -7.78 -0.75 -2.04 Oct. 08 -14.00 -23.83 -10.71 Sep. 08 -11.20 -13.87 -13.02 Aug. 08 3.22 -2.27 4.15 Jul. 08 -5.26 -0.78 -3.80 Jun. 08 -7.64 -5.98 -7.06 May 08 2.07 3-53 -0.56 Apr. 08 4-57 10.57 6.76