is it possible to do step 33 in chapter 19, problem 7PS manually, without excel, if yes, how? thanks.

Step 33 diI 35 Calculate the standard deviation considering all the outcomes are equally likely using MS-EXCEL "STDEV.P" function as follows: A B D E 1 Pound- Denominated Return (%) Dollar-Denominated Return (%) for Exchange 2 Price per Share rate at the year end 3 () $1.80/ $2.00/ $2.20/ 4 35 -12.50% -21.25 % -12.50% -3.75% 5 40 0.00% -10.00% 0.00% 10.00% 6 45 12.50% 1.25% 12.50% 23.75% 7 Standard Deviation. 8 formula |=STDEV.P(C4:C6) |=STDEV.P(D4:F6) 10.21% 9 Standard Deviation 13.10% 10 Therefore, the standard deviation of the pound denominated return is 10.21%, and the standard deviation of the dollar denominated return is 13.10 % - Dollar denominated return is greater than the standard deviation of the pound denominated return. This has occurred due to the addition of the exchange rate risk. >