a. (5 marks) Find the weights of Singapore Airlines Limited, Qantas Airways Limited and Cathay Pacific Airlines that will provide a daily return of 0.01% with the lowest level of risk. b. (5 marks) Plot a scatter diagram showing the portfolios from parts (e), (f) and (g), with the X-axis displaying standard deviation and the Y-axis displaying daily returns.

c. (4 marks) If the daily risk-free rate is 0.1%, estimate the Sharpe ratio for the portfolios mentioned in parts (e), (f) and (g) and highlight the highest Sharpe ratio using conditional formatting.

Daily Stock Return% (QAN.AX)(C6L.S (0293.HK) -5.33% 1.62% -4.69% -2.65% 0.00% 4.55% 4.26% 4.87% 2.20% -0.83% 9.54% 2.51% 3.37% 1.96%4 -3.53% -1.28% -2.257-0.327 7.207 1.30% -3.49% 0.00% 0.00% -3.53% -6.41% 0.83% -0.60% -28,61% 1.50% -1.63% 4.42% 0.83% -1.13% -1.31% 4.86% 1.33% -3.00% 0.33% 1.69% -2.62% -3.31% -0.67% -1.14% 5.67% -1.73% 0.23% 3.82% 0.00% 0.28% -2.72% 0.28% -6.76% -6.20% -4.75% 0.60% 2.367 0.90% -4.62% 3.55% -0.54% 0.86% -3.517 2.83% 1.96% -0.83% -0.27% 7.22% -0.83% 5.44% 4.44% 0.49% 1.60%4 0.007 0.007 -2.44% 1.57% 0.507 5.93% -0.75% 4.87% 5.28% 1.62% 7.16% -1.14% 3.12% -0.92% 6.48% 1.40% 0.41% -3.45% -6.46% -0.957 -3.02% 3.37% 0.99% -0.12% 0.98% 2.78% 1.29% 4.99% 0.88% -2.08% 0.90% 3.88% 0.32% -5.22% 1.35% -0.44% -0.89% -0.34% 2.48% 1.107 -1.41% 0.88% -0.22% -1.217 1.227 0.22% -0.44% -1.54% -0.67% -0.56% -3.28% 0.58% 1.63% -2.407 -5.04% -1.73% 1.76%A 0.37% -3.19% -0.25% 3.697 0.00% 1354 2.18% 5.454 -1017 -1.02% -3.44% -1.437 -3.0 -3.3 -3.56% 3.2 4.3 -0.48 0.00 -1.4% -3. -1.7% 0.4 0.5 -4.1 -1.74 2. -1.2 2. -1.54 -3.0 -0.52 -4.9 -1.838 4.4 -0.5 3.44 2.143 -2.3 11.05 -0.79 1.30 -3.43 0 -1.3 -1.533 0.0 -0.52 -2 -1.04% 0.00 -1.5 -0.5 -0.80 4.3 1.34 1.65 -1.3 -2. -0.54 0.28 -1.08 4. EOS 0.82 -3.42 -1.08 11.9 1.10 -2.67 -1.90 1.1 -0.28 -2.45 -1. -3.06 -1. -3.45 -3. -1.43 2 0. 0.25 -0.86 -0. -0.7 -1.0 -1.40 -0.3 -2.9% 0 -1.5 -1. 3.42% -2 2 -0.9 -5. 2. CUE 0 -3.243 3.5 -1.4 -2. -1. -1.0 0.52 -3.9 1.08 -3. 23 -0.94% -- Daily Stock Return% (QAN.AX)(C6L.S (0293.HK) -5.33% 1.62% -4.69% -2.65% 0.00% 4.55% 4.26% 4.87% 2.20% -0.83% 9.54% 2.51% 3.37% 1.96%4 -3.53% -1.28% -2.257-0.327 7.207 1.30% -3.49% 0.00% 0.00% -3.53% -6.41% 0.83% -0.60% -28,61% 1.50% -1.63% 4.42% 0.83% -1.13% -1.31% 4.86% 1.33% -3.00% 0.33% 1.69% -2.62% -3.31% -0.67% -1.14% 5.67% -1.73% 0.23% 3.82% 0.00% 0.28% -2.72% 0.28% -6.76% -6.20% -4.75% 0.60% 2.367 0.90% -4.62% 3.55% -0.54% 0.86% -3.517 2.83% 1.96% -0.83% -0.27% 7.22% -0.83% 5.44% 4.44% 0.49% 1.60%4 0.007 0.007 -2.44% 1.57% 0.507 5.93% -0.75% 4.87% 5.28% 1.62% 7.16% -1.14% 3.12% -0.92% 6.48% 1.40% 0.41% -3.45% -6.46% -0.957 -3.02% 3.37% 0.99% -0.12% 0.98% 2.78% 1.29% 4.99% 0.88% -2.08% 0.90% 3.88% 0.32% -5.22% 1.35% -0.44% -0.89% -0.34% 2.48% 1.107 -1.41% 0.88% -0.22% -1.217 1.227 0.22% -0.44% -1.54% -0.67% -0.56% -3.28% 0.58% 1.63% -2.407 -5.04% -1.73% 1.76%A 0.37% -3.19% -0.25% 3.697 0.00% 1354 2.18% 5.454 -1017 -1.02% -3.44% -1.437 -3.0 -3.3 -3.56% 3.2 4.3 -0.48 0.00 -1.4% -3. -1.7% 0.4 0.5 -4.1 -1.74 2. -1.2 2. -1.54 -3.0 -0.52 -4.9 -1.838 4.4 -0.5 3.44 2.143 -2.3 11.05 -0.79 1.30 -3.43 0 -1.3 -1.533 0.0 -0.52 -2 -1.04% 0.00 -1.5 -0.5 -0.80 4.3 1.34 1.65 -1.3 -2. -0.54 0.28 -1.08 4. EOS 0.82 -3.42 -1.08 11.9 1.10 -2.67 -1.90 1.1 -0.28 -2.45 -1. -3.06 -1. -3.45 -3. -1.43 2 0. 0.25 -0.86 -0. -0.7 -1.0 -1.40 -0.3 -2.9% 0 -1.5 -1. 3.42% -2 2 -0.9 -5. 2. CUE 0 -3.243 3.5 -1.4 -2. -1. -1.0 0.52 -3.9 1.08 -3. 23 -0.94%