Autove 8- File Home Imet Draw Page Layout ExC) Campetblity Mode - Excal P. Seach (A) Formulas Data Review View Help Powe Pat > - And 10-AK PO BIU -- SONS. Gmad % Condition Format G10 9 A B C D E F G H 1 Chapter 4, #4 4 INPUT Hotel Return Weight in Standart Portfole Deaton Hotel X 10% 75% 3% Hotel Y 20% 25% 9% Correlation Coefficient Calculate the expected retum of the portale O Expected Retum- 12.50% Calculate the standard deviation of the portio uning different corelation coefficients Standard Deviation of the Portfolio Sheet! Sheet Set Type here to search OUTPUT VALUE O B AVCR 7 1 0 A 2 3 WLE 4 5 6 7 R T Y F G H N X C V B 6