Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Each year, create a table for average monthly percentage for each currency, Which currency has all 4 average number greater than -0.01%? Which currency has

image text in transcribed

Each year, create a table for average monthly percentage for each currency, Which currency has all 4 average number greater than -0.01%?
Which currency has all 4 average number greater than -0.01%?
year CAD1 JPY1 MXN1 THB1 SLR1 EUR1 CNY1 GBP1 INR1 SGD1
2010
2011
2012
2013
DATE CAD1 2010-01-01 1.0438 2010-02-01 1.0572 2010-03-01 1.0229 2010-04-01 1.0052 2010-05-01 1.0403 2010-06-01 1.0376 2010-07-01 1.0422 2010-08-01 1.0404 2010-09-01 1.0330 2010-10-01 1.0179 2010-11-01 1.0129 2010-12-01 1.0081 2011-01-01 0.9939 2011-02-01 0.9876 2011-03-01 0.9766 2011-04-01 0.9580 2011-05-01 0.9680 2011-06-01 0.9766 2011-07-01 0.9553 2011-08-01 0.9817 2011-09-01 1.0025 2011-10-01 1.0198 2011-11-01 1.0248 2011-12-01 1.0235 2012-01-01 1.0130 2012-02-01 0.9967 2012-03-01 0.9938 2012-04-01 0.9928 2012-05-01 1.0097 2012-06-01 1.0280 2012-07-01 1.0142 2012-08-01 0.9924 2012-09-01 0.9783 2012-10-01 0.9872 2012-11-01 0.9970 2012-12-01 0.9898 2013-01-01 0.9921 2013-02-01 1.0052 JPY1 MXN1 THB1 SLR1 EUR1 CNY1 GBP1 INR1 SGD1 0.01100.0781 0.0303 0.0087 1.4266 0.1465 1.6158 0.0218 0.7161 0.0111 0.0773 0.0302 0.0087 1.3680 0.1464 1.5618 0.0216 0.7081 0.0110 0.0796 0.0308 0.0088 1.3570 0.1465 1.5058 0.0220 0.7146 0.0107 0.0817 0.0310 0.0088 1.3417 0.1465 1.5332 0.0225 0.7237 0.0109 0.0786 0.0309 0.0088 1.2563 0.1465 1.4669 0.0218 0.7174 0.0110 0.0787 0.0308 0.0088 1.2223 0.1467 1.4768 0.0215 0.7155 0.0114 0.0781 0.0310 0.0089 1.28110.1476 1.5304 0.0214 0.7270 0.0117 0.0783 0.0315 0.0089 1.2903 0.1473 1.5661 0.0215 0.7380 0.0119 0.0781 0.0325 0.0089 1.3103 0.1484 1.5591 0.0218 0.7500 0.0122 0.0804 0.0334 0.0090 1.3901 0.1500 1.5867 0.0225 0.7677 0.0121 0.0811 0.0335 0.0090 1.3654 0.1503 1.5961 0.0223 0.7700 0.0120 0.0807 0.0332 0.00901.3221 0.1504 1.5595 0.0222 0.7655 0.0121 0.0825 0.0327 0.00901.3371 0.1516 1.5782 0.0220 0.7774 0.01210.0829 0.0326 0.0090 1.3656 0.1521 1.6124 0.0220 0.7839 0.01220.0834 0.0330 0.0091 1.4020 0.1523 1.6159 0.0223 0.7888 0.0120 0.0854 0.0333 0.0091 1.4460 0.1532 1.6379 0.0226 0.8024 0.0123 0.0858 0.0331 0.0091 1.4335 0.1539 1.6332 0.0223 0.8073 0.0124 0.0847 0.0328 0.0091 1.4403 0.1544 1.6219 0.0223 0.8106 0.0126 0.0857 0.0333 0.0091 1.4275 0.1549 1.6158 0.0225 0.8225 0.0130 0.0817 0.0335 0.0091 1.4333 0.1562 1.6356 0.0221 0.8272 0.0130 0.0765 0.0328 0.0091 1.37470.1565 1.5771 0.0210 0.7976 0.0130 0.0744 0.0324 0.0091 1.3732 0.1570 1.5768 0.0203 0.7839 0.0129 0.0730 0.0323 0.0090 1.3558 0.1573 1.5806 0.0197 0.7760 0.0129 0.0726 0.0321 0.0088 1.3155 0.1575 1.5587 0.0191 0.7720 0.01300.0747 0.0317 0.0088 1.2910 0.1583 1.5524 0.0196 0.7827 0.0127 0.0782 0.0326 0.0085 1.3238 0.1587 1.5804 0.0203 0.7978 0.01210.0784 0.0326 0.0080 1.3208 0.1584 1.5824 0.0199 0.7943 0.0123 0.0766 0.0324 0.0078 1.3160 0.1586 1.6000 0.0193 0.7994 0.0126 0.0734 0.0320 0.0078 1.2806 0.1581 1.5924 0.0184 0.7924 0.0126 0.0718 0.0316 0.0076 1.2541 0.1572 1.5556 0.0179 0.7822 0.01270.0748 0.0316 0.0075 1.2278 0.1569 1.5593 0.0180 0.7935 0.0127 0.0759 0.0319 0.0076 1.2406 0.1573 1.5722 0.0180 0.8013 0.0128 0.0774 0.0323 0.0076 1.2885 0.1582 1.6126 0.0184 0.8128 0.01270.0775 0.0326 0.0077 1.2974 0.1597 1.6080 0.0188 0.8172 0.0123 0.0765 0.0326 0.0077 1.2837 0.1604 1.5968 0.0183 0.8175 0.0119 0.0777 0.0327 0.0078 1.3119 0.1604 1.6145 0.0183 0.8194 0.01120.0788 0.0333 0.0079 1.3304 0.1607 1.5965 0.0184 0.8142 0.0107 0.0787 0.0335 0.0079 1.3412 0.1604 1.5563 0.0186 0.8076 DATE CAD1 2010-01-01 1.0438 2010-02-01 1.0572 2010-03-01 1.0229 2010-04-01 1.0052 2010-05-01 1.0403 2010-06-01 1.0376 2010-07-01 1.0422 2010-08-01 1.0404 2010-09-01 1.0330 2010-10-01 1.0179 2010-11-01 1.0129 2010-12-01 1.0081 2011-01-01 0.9939 2011-02-01 0.9876 2011-03-01 0.9766 2011-04-01 0.9580 2011-05-01 0.9680 2011-06-01 0.9766 2011-07-01 0.9553 2011-08-01 0.9817 2011-09-01 1.0025 2011-10-01 1.0198 2011-11-01 1.0248 2011-12-01 1.0235 2012-01-01 1.0130 2012-02-01 0.9967 2012-03-01 0.9938 2012-04-01 0.9928 2012-05-01 1.0097 2012-06-01 1.0280 2012-07-01 1.0142 2012-08-01 0.9924 2012-09-01 0.9783 2012-10-01 0.9872 2012-11-01 0.9970 2012-12-01 0.9898 2013-01-01 0.9921 2013-02-01 1.0052 JPY1 MXN1 THB1 SLR1 EUR1 CNY1 GBP1 INR1 SGD1 0.01100.0781 0.0303 0.0087 1.4266 0.1465 1.6158 0.0218 0.7161 0.0111 0.0773 0.0302 0.0087 1.3680 0.1464 1.5618 0.0216 0.7081 0.0110 0.0796 0.0308 0.0088 1.3570 0.1465 1.5058 0.0220 0.7146 0.0107 0.0817 0.0310 0.0088 1.3417 0.1465 1.5332 0.0225 0.7237 0.0109 0.0786 0.0309 0.0088 1.2563 0.1465 1.4669 0.0218 0.7174 0.0110 0.0787 0.0308 0.0088 1.2223 0.1467 1.4768 0.0215 0.7155 0.0114 0.0781 0.0310 0.0089 1.28110.1476 1.5304 0.0214 0.7270 0.0117 0.0783 0.0315 0.0089 1.2903 0.1473 1.5661 0.0215 0.7380 0.0119 0.0781 0.0325 0.0089 1.3103 0.1484 1.5591 0.0218 0.7500 0.0122 0.0804 0.0334 0.0090 1.3901 0.1500 1.5867 0.0225 0.7677 0.0121 0.0811 0.0335 0.0090 1.3654 0.1503 1.5961 0.0223 0.7700 0.0120 0.0807 0.0332 0.00901.3221 0.1504 1.5595 0.0222 0.7655 0.0121 0.0825 0.0327 0.00901.3371 0.1516 1.5782 0.0220 0.7774 0.01210.0829 0.0326 0.0090 1.3656 0.1521 1.6124 0.0220 0.7839 0.01220.0834 0.0330 0.0091 1.4020 0.1523 1.6159 0.0223 0.7888 0.0120 0.0854 0.0333 0.0091 1.4460 0.1532 1.6379 0.0226 0.8024 0.0123 0.0858 0.0331 0.0091 1.4335 0.1539 1.6332 0.0223 0.8073 0.0124 0.0847 0.0328 0.0091 1.4403 0.1544 1.6219 0.0223 0.8106 0.0126 0.0857 0.0333 0.0091 1.4275 0.1549 1.6158 0.0225 0.8225 0.0130 0.0817 0.0335 0.0091 1.4333 0.1562 1.6356 0.0221 0.8272 0.0130 0.0765 0.0328 0.0091 1.37470.1565 1.5771 0.0210 0.7976 0.0130 0.0744 0.0324 0.0091 1.3732 0.1570 1.5768 0.0203 0.7839 0.0129 0.0730 0.0323 0.0090 1.3558 0.1573 1.5806 0.0197 0.7760 0.0129 0.0726 0.0321 0.0088 1.3155 0.1575 1.5587 0.0191 0.7720 0.01300.0747 0.0317 0.0088 1.2910 0.1583 1.5524 0.0196 0.7827 0.0127 0.0782 0.0326 0.0085 1.3238 0.1587 1.5804 0.0203 0.7978 0.01210.0784 0.0326 0.0080 1.3208 0.1584 1.5824 0.0199 0.7943 0.0123 0.0766 0.0324 0.0078 1.3160 0.1586 1.6000 0.0193 0.7994 0.0126 0.0734 0.0320 0.0078 1.2806 0.1581 1.5924 0.0184 0.7924 0.0126 0.0718 0.0316 0.0076 1.2541 0.1572 1.5556 0.0179 0.7822 0.01270.0748 0.0316 0.0075 1.2278 0.1569 1.5593 0.0180 0.7935 0.0127 0.0759 0.0319 0.0076 1.2406 0.1573 1.5722 0.0180 0.8013 0.0128 0.0774 0.0323 0.0076 1.2885 0.1582 1.6126 0.0184 0.8128 0.01270.0775 0.0326 0.0077 1.2974 0.1597 1.6080 0.0188 0.8172 0.0123 0.0765 0.0326 0.0077 1.2837 0.1604 1.5968 0.0183 0.8175 0.0119 0.0777 0.0327 0.0078 1.3119 0.1604 1.6145 0.0183 0.8194 0.01120.0788 0.0333 0.0079 1.3304 0.1607 1.5965 0.0184 0.8142 0.0107 0.0787 0.0335 0.0079 1.3412 0.1604 1.5563 0.0186 0.8076

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby

1st Edition

0072992573, 9780072992571

More Books

Students also viewed these Accounting questions