This is a repost. I did the spreadsheet separate from the questions this time. I hope that it is better to read. Please show how to do the problems.
This is probably the best I can get the pic.
1 1 DATE 03030.0087 1.4266 0.1465 1.6158 0.0218 0.7161 2010-02-01|1.0572/-0.0111 -00773-003020.0087 -130801-0.1464/ 15618 00216 0708 1.02291 00110|. 0079600308| 0.0088 13570-0. 1465| 15058100220| 0.7146 00773 00302 0.0087300.1464 15618 0.0216 2010-04.011 -1.0052 00107 | 00817| 00310| 0.0088| 13417| 01465 15332 78 00309 0.00882563 0.1465 1.4669 00218 07174 01-1 .0376|00110 00787 -0.03081, 0.0088-1.2223 -0.1467 4768 - 0 215-07155 2010-07-01 1.0422 00114 2010-08-011.0404 0 0117 0.0781 00310 0.0089 128110,1476 15304 00214 - 0.0783 00315 0.0089 290301473 1.5681 1.03301 00119 00781 00325 0.00891.31030.14841-15591i-002181 0750 804 0.03340.0090 3901 0.1500 1.5867 002250.7677 0811| 0.03351 0.0090 13654 | 01503| 15961 00223| 07700 0.1504 15595 00222 0.7655 2011-01-01 0.9939 - 00121 008251 00327| 0.00%) 13371 | 01516| 15782 002201-07774 2010-10-01 1.0179 00122 2010-11-01 1.0129 00121 2010-12-01 1.0081 00120 0080700332 0.0090 2011-02-01-09876-0.0121 2011-03-01 0.9 001210.0829 0 0326 00090 1.3656 1521 1.612400220 9766 0012200834 00330 0.0091 402001523 1.6159 0 02230.7888 0.0120 00854 0.0333 0.0091 14460 0.1532 2011-05-01 0.9680 0.01230 00858 0.0331 0.00911.433 01539 1.6332 00223 011-06-010.9766 00124 0.0847 00328 0.00914403 0 1544 1.6219 0022308108 2011-07-01 0.9553 0.0126 2 0.08570 0333 0.0091 142750.15491.6158 2011.08-01 0.9817 001300081700335 0.00911.4333 01562 16356 0022108272 01109-01 1.0025 00130 0076500328 0.0091 1.3747 0,156515771 0021007976 011-10-01 1.0198 00130 00744 00324 0.0091 13732 01570 1,5768 00203 07839 2011-11-01 1.0248 0.0129 007300 0323 0.00901.3558 0.1573 1.580 00197 0.7760 2011-12-01 1.0235 00129 0072600321 0.0088 1.31550.1575 15587 0019107720 2012-01 01 10130 00130 00747 00317 0.008812910 0.1583 1.5524 00196 2012-02-01-0.9967-00127-0.0782-0.0326 0.0085| 1.3238 2012-03-010.9938 0012100784 00326 0.0080 13208 0.1584 1.5824 0 0199 2012-04-01:0.9928. 00123 00766 0.0324| 0.0078 13160 0.1586 16000 00193 07994 0.1587 0.0203 0.7978 0.7943 201205-01 10097 0012600734 0.030 0.0078 12806 0.1581 15924 00184 07924 2012-06-01 1,0280-0012 00718 -0.03160.0076) 12541 01572-15558-0.0179 - 07822 2012-07-01 1.0142 001270.0748 00316 0.0075 1.2278 0.1569 559310 0.7935 2012-08-01 0.9924 0012700759 00319 0.0076 12406 0.1573 1.5722 00180 08013 12012-09-01 | 2012-10-01 | 0.9872 001271 0.0775 0.0326 0.0077 1.2974| 01597|-16080| 00188| O8172 2012-11-01 0.9970 001230.0765 00326 0.0077 128370.1604 1.5968 00183 08175 2012-12-01 0.9898 0.0119 00777 0.0327 0.0078 1.3119 0.1604 16145 00183 0.8194 2013-01-01 -0.9921 0 0112 - 00 788 -00333 0.0079 -- 1330401607 - 1596s l-0.0184-08142 2013-02-01 1.0052 0.0107 00787 0.0335 0.0079 1.3412 0.1604 1.5563 001860 8076 0.9783| 00128| 00774| 0.0323| 0.0076| 1.2885| -Q1582| 16126| 00184| O8128 This sheet contains monthly exchange rate. Value of each currency ts quoted in 1. Which currency has the highest average percentage change (in absolute term) For each currency, you calculate percentage change for each month Then get the average percentage change Use absolute value of the average above. This absolute average shows you how exchange rate changes regradless of direction . Which currency has the highest standard deviation of 3.On 2010-01-01, your company has: CAD UPY MXN 1,000,000 100,000,000 5,000,000 THB100,000,000 How much all these 4 positions worth in USD 4. If your company hold these 4 positions until 2011-01-01 How all these 4 positions worth in USD 5. If your company holds these 4 positions for the whole period we analyze (2010/01/01-2013/02 /01) Which month the total USD value of these 4 positions is highest put your answer in format yyymm (201101) 06 Each year, create a table for average monthly percentage for each currency which currency has all 4 average-umbergreater than-0.01%? JPY1 MXN1 THB1 SLR1 EUR1 CNY1 GBP1 INR1 SGD1 CAD1 2010 2011 2012 2013 1000 0000000000000000000 azi-001-002 002-001 :: 000 0 2010-03-01 1.0229 0.0110 2010-04-01 1.0052 0.0107 01005-011.0403 0.0109 2010-06-01 1.0376 0.0110 0 2010-07-01 1.0422 2010-08-01 1.0404 00117 0.0783 2010-09-01 1.0330 0.011 0 0 0 0 o 0.08170.0310 0.00881.3417 0.0786 0309 0.0088 1.2563 0.1465 1.4 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 1467 1.4768 0.0215 0.71 00110 0.0 00114 0.0781 0.0310 0.0089 1.53040.0214 0.7270 1.2811 0.0315 0.0089 12903 0.1473 15661 00215 01| 1.0179| 00122| 00804| 00334| 0.0090| 1.3901| 0.1500| 1586 00225 0.07810.0325 0.0089 13103 0.14841.5591 0.0218 0.7500 2010-11-01 1.019 0.0121 2010-12-01 1.0081 0.0120 0.0811 0.0335 0.0090 1.3654 0.1503 1.5961 0.0223 0.7700 00807 0.0332 0.0090 1.3221 0.1504 1.5595 0.02220.7655 2011-01-01/ 0.9939-00121 -00825-00327-000 9013371 01516-1.5782-0.02201- 0.7774 2011-02-01 0.9876 00121 008 2011-03-01 0.9766 00122 00834 2011-04-01 0.958000120 00854 00333 0.0091 1 2011-05-01 0.9680 00123 00858 0.0331 0.0091 14335 0.1539 1.6332 0.0223 1.4020 0.1523 .6159 0.0223 0.7888 1.4460 0.1532 1.6379 0.02280.8024 08073 0.02230.8106 0.0330 0.0091 1 0328 0.0091 1.4403 0.1544 1.6219 1.4333 0.1562 1.6356 0324 0.0091 1.3732 01570 1.5768 2011-07-01 0.9553 00126 00857 00333 0.0091 1427501549 16158 2011-08-01 0.9817 0.0130 0.0817 0.0335 0.00911 2011-09-01 1.0025 0.013000765 0.0328 0.0091 13747 2011-10-01 1.0198 0.0130 2011-11-01 1.0248 0.0129 0.0221 0.8272 01565 1577100210 0.7976 0129 0.0730 0.0323 0.0090 1.35580.1573 1.5806 260.0321 0.0088 1.3155 0.1575 1.5587 001 2 2011-12-011.0235 0.0129 0.0 2012-01-01 1.0130 001 2012-02-01 0.9967 00127 2012-03-01 0.993800121 2012-04-01 0.9928 0.0123 2012-05-01 1.0097 0.0 2012-06-01 1.02801-00126| 0.0718 00316 0.0076 1.2541 015721-1 2012-07-01 | 1.0142-001271 0.07481 00316| 0.0075 1.2278-0.1569 2012-08-01-09924| 00127 00759-00319-0.0076-12406 2012-09-01 0.9783 0.0128 00774 0 0323 0.0076 12885 00317 0.0088 12910 1.55240.0196 0.1584 1.5824 1586 1.60000.0193 0.7994 0.0180 0.7935 1573 1.57220.01 .61260.018408128 012-10-01 0.9872 0.0127 0.0775 2012-11-01 0.9970 2012-12-01 0.989800119 2013-01-01 | 0.9921| 0.0112| 00788| 00333| 0.0079| 13304 0.0326 0.0077 12837 0327 0.0078 1.31 1 -02-011.0052 00107 0.0787 0.0335 0.0079 1 1 DATE 03030.0087 1.4266 0.1465 1.6158 0.0218 0.7161 2010-02-01|1.0572/-0.0111 -00773-003020.0087 -130801-0.1464/ 15618 00216 0708 1.02291 00110|. 0079600308| 0.0088 13570-0. 1465| 15058100220| 0.7146 00773 00302 0.0087300.1464 15618 0.0216 2010-04.011 -1.0052 00107 | 00817| 00310| 0.0088| 13417| 01465 15332 78 00309 0.00882563 0.1465 1.4669 00218 07174 01-1 .0376|00110 00787 -0.03081, 0.0088-1.2223 -0.1467 4768 - 0 215-07155 2010-07-01 1.0422 00114 2010-08-011.0404 0 0117 0.0781 00310 0.0089 128110,1476 15304 00214 - 0.0783 00315 0.0089 290301473 1.5681 1.03301 00119 00781 00325 0.00891.31030.14841-15591i-002181 0750 804 0.03340.0090 3901 0.1500 1.5867 002250.7677 0811| 0.03351 0.0090 13654 | 01503| 15961 00223| 07700 0.1504 15595 00222 0.7655 2011-01-01 0.9939 - 00121 008251 00327| 0.00%) 13371 | 01516| 15782 002201-07774 2010-10-01 1.0179 00122 2010-11-01 1.0129 00121 2010-12-01 1.0081 00120 0080700332 0.0090 2011-02-01-09876-0.0121 2011-03-01 0.9 001210.0829 0 0326 00090 1.3656 1521 1.612400220 9766 0012200834 00330 0.0091 402001523 1.6159 0 02230.7888 0.0120 00854 0.0333 0.0091 14460 0.1532 2011-05-01 0.9680 0.01230 00858 0.0331 0.00911.433 01539 1.6332 00223 011-06-010.9766 00124 0.0847 00328 0.00914403 0 1544 1.6219 0022308108 2011-07-01 0.9553 0.0126 2 0.08570 0333 0.0091 142750.15491.6158 2011.08-01 0.9817 001300081700335 0.00911.4333 01562 16356 0022108272 01109-01 1.0025 00130 0076500328 0.0091 1.3747 0,156515771 0021007976 011-10-01 1.0198 00130 00744 00324 0.0091 13732 01570 1,5768 00203 07839 2011-11-01 1.0248 0.0129 007300 0323 0.00901.3558 0.1573 1.580 00197 0.7760 2011-12-01 1.0235 00129 0072600321 0.0088 1.31550.1575 15587 0019107720 2012-01 01 10130 00130 00747 00317 0.008812910 0.1583 1.5524 00196 2012-02-01-0.9967-00127-0.0782-0.0326 0.0085| 1.3238 2012-03-010.9938 0012100784 00326 0.0080 13208 0.1584 1.5824 0 0199 2012-04-01:0.9928. 00123 00766 0.0324| 0.0078 13160 0.1586 16000 00193 07994 0.1587 0.0203 0.7978 0.7943 201205-01 10097 0012600734 0.030 0.0078 12806 0.1581 15924 00184 07924 2012-06-01 1,0280-0012 00718 -0.03160.0076) 12541 01572-15558-0.0179 - 07822 2012-07-01 1.0142 001270.0748 00316 0.0075 1.2278 0.1569 559310 0.7935 2012-08-01 0.9924 0012700759 00319 0.0076 12406 0.1573 1.5722 00180 08013 12012-09-01 | 2012-10-01 | 0.9872 001271 0.0775 0.0326 0.0077 1.2974| 01597|-16080| 00188| O8172 2012-11-01 0.9970 001230.0765 00326 0.0077 128370.1604 1.5968 00183 08175 2012-12-01 0.9898 0.0119 00777 0.0327 0.0078 1.3119 0.1604 16145 00183 0.8194 2013-01-01 -0.9921 0 0112 - 00 788 -00333 0.0079 -- 1330401607 - 1596s l-0.0184-08142 2013-02-01 1.0052 0.0107 00787 0.0335 0.0079 1.3412 0.1604 1.5563 001860 8076 0.9783| 00128| 00774| 0.0323| 0.0076| 1.2885| -Q1582| 16126| 00184| O8128 This sheet contains monthly exchange rate. Value of each currency ts quoted in 1. Which currency has the highest average percentage change (in absolute term) For each currency, you calculate percentage change for each month Then get the average percentage change Use absolute value of the average above. This absolute average shows you how exchange rate changes regradless of direction . Which currency has the highest standard deviation of 3.On 2010-01-01, your company has: CAD UPY MXN 1,000,000 100,000,000 5,000,000 THB100,000,000 How much all these 4 positions worth in USD 4. If your company hold these 4 positions until 2011-01-01 How all these 4 positions worth in USD 5. If your company holds these 4 positions for the whole period we analyze (2010/01/01-2013/02 /01) Which month the total USD value of these 4 positions is highest put your answer in format yyymm (201101) 06 Each year, create a table for average monthly percentage for each currency which currency has all 4 average-umbergreater than-0.01%? JPY1 MXN1 THB1 SLR1 EUR1 CNY1 GBP1 INR1 SGD1 CAD1 2010 2011 2012 2013 1000 0000000000000000000 azi-001-002 002-001 :: 000 0 2010-03-01 1.0229 0.0110 2010-04-01 1.0052 0.0107 01005-011.0403 0.0109 2010-06-01 1.0376 0.0110 0 2010-07-01 1.0422 2010-08-01 1.0404 00117 0.0783 2010-09-01 1.0330 0.011 0 0 0 0 o 0.08170.0310 0.00881.3417 0.0786 0309 0.0088 1.2563 0.1465 1.4 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 1467 1.4768 0.0215 0.71 00110 0.0 00114 0.0781 0.0310 0.0089 1.53040.0214 0.7270 1.2811 0.0315 0.0089 12903 0.1473 15661 00215 01| 1.0179| 00122| 00804| 00334| 0.0090| 1.3901| 0.1500| 1586 00225 0.07810.0325 0.0089 13103 0.14841.5591 0.0218 0.7500 2010-11-01 1.019 0.0121 2010-12-01 1.0081 0.0120 0.0811 0.0335 0.0090 1.3654 0.1503 1.5961 0.0223 0.7700 00807 0.0332 0.0090 1.3221 0.1504 1.5595 0.02220.7655 2011-01-01/ 0.9939-00121 -00825-00327-000 9013371 01516-1.5782-0.02201- 0.7774 2011-02-01 0.9876 00121 008 2011-03-01 0.9766 00122 00834 2011-04-01 0.958000120 00854 00333 0.0091 1 2011-05-01 0.9680 00123 00858 0.0331 0.0091 14335 0.1539 1.6332 0.0223 1.4020 0.1523 .6159 0.0223 0.7888 1.4460 0.1532 1.6379 0.02280.8024 08073 0.02230.8106 0.0330 0.0091 1 0328 0.0091 1.4403 0.1544 1.6219 1.4333 0.1562 1.6356 0324 0.0091 1.3732 01570 1.5768 2011-07-01 0.9553 00126 00857 00333 0.0091 1427501549 16158 2011-08-01 0.9817 0.0130 0.0817 0.0335 0.00911 2011-09-01 1.0025 0.013000765 0.0328 0.0091 13747 2011-10-01 1.0198 0.0130 2011-11-01 1.0248 0.0129 0.0221 0.8272 01565 1577100210 0.7976 0129 0.0730 0.0323 0.0090 1.35580.1573 1.5806 260.0321 0.0088 1.3155 0.1575 1.5587 001 2 2011-12-011.0235 0.0129 0.0 2012-01-01 1.0130 001 2012-02-01 0.9967 00127 2012-03-01 0.993800121 2012-04-01 0.9928 0.0123 2012-05-01 1.0097 0.0 2012-06-01 1.02801-00126| 0.0718 00316 0.0076 1.2541 015721-1 2012-07-01 | 1.0142-001271 0.07481 00316| 0.0075 1.2278-0.1569 2012-08-01-09924| 00127 00759-00319-0.0076-12406 2012-09-01 0.9783 0.0128 00774 0 0323 0.0076 12885 00317 0.0088 12910 1.55240.0196 0.1584 1.5824 1586 1.60000.0193 0.7994 0.0180 0.7935 1573 1.57220.01 .61260.018408128 012-10-01 0.9872 0.0127 0.0775 2012-11-01 0.9970 2012-12-01 0.989800119 2013-01-01 | 0.9921| 0.0112| 00788| 00333| 0.0079| 13304 0.0326 0.0077 12837 0327 0.0078 1.31 1 -02-011.0052 00107 0.0787 0.0335 0.0079
