odes att NO NO SEST 10 15 16 17 13 19 20 21 C D CIG 0.7 2. Create a "Data Tablet calculates the expected return, standard deviation, and Sharpe ratio of a different portfolio on each row. For each row, the portfolio should have the listed weight for that row invested in the US Government bond asset, and the remainder invested in the US Stock For the Sharpe ratio, you can 1:24-3019 assume that the free rule of retumis 121%. L WeM Std Dew Expat Share 1.68% Bonds 0.75 2.869 ON 0.16 1.SEX 06765 -0.07-037 155 20 NIUE NOFT NE NOT Oct 1 No.1 Decor han 02 Feb 02 Mar Apr. May 02 Jun-02 02 Aug 02 - Octo Nov 02 Dec.co an 01 Teos M Aprico May as no lul 23 24 25 to-tas NET SGD SEE SUO VE NIE NSE 22 25 29 30 31 12 06 DAX2016 1.26 0.01295 1.01 206 40N NST 50% NO 01.25 GOS 34 15 NORD 70 ON 6. -0.04.18 BE 75 37 con NOOT NERO you WS Seps Oct OSEN 2014 0326 0,00 0.061 ON 1991- 001 L9630 0.530 41 43 43 41 15 46 Dec 03 lant- 04 Mar 04 Ar 04 M04 2. Using the Index and Match function, return the following information from the DataTable that you just created for the portfolio that has the largest Share to NITO NOT -11124 Weight MG PUS Espe Sharpe 09 ON odes att NO NO SEST 10 15 16 17 13 19 20 21 C D CIG 0.7 2. Create a "Data Tablet calculates the expected return, standard deviation, and Sharpe ratio of a different portfolio on each row. For each row, the portfolio should have the listed weight for that row invested in the US Government bond asset, and the remainder invested in the US Stock For the Sharpe ratio, you can 1:24-3019 assume that the free rule of retumis 121%. L WeM Std Dew Expat Share 1.68% Bonds 0.75 2.869 ON 0.16 1.SEX 06765 -0.07-037 155 20 NIUE NOFT NE NOT Oct 1 No.1 Decor han 02 Feb 02 Mar Apr. May 02 Jun-02 02 Aug 02 - Octo Nov 02 Dec.co an 01 Teos M Aprico May as no lul 23 24 25 to-tas NET SGD SEE SUO VE NIE NSE 22 25 29 30 31 12 06 DAX2016 1.26 0.01295 1.01 206 40N NST 50% NO 01.25 GOS 34 15 NORD 70 ON 6. -0.04.18 BE 75 37 con NOOT NERO you WS Seps Oct OSEN 2014 0326 0,00 0.061 ON 1991- 001 L9630 0.530 41 43 43 41 15 46 Dec 03 lant- 04 Mar 04 Ar 04 M04 2. Using the Index and Match function, return the following information from the DataTable that you just created for the portfolio that has the largest Share to NITO NOT -11124 Weight MG PUS Espe Sharpe 09 ON