Question: Question 4) Using the start year (see Column Z) and end year (see Column AA) plot the US Dollar to Euro exchange rate (see Column

Question 4) Using the start year (see Column Z) and end year (see Column AA) plot the US Dollar to Euro exchange rate (see Column AE), the US Dollar to Australian Dollar exchange rate (see Column AF) and Canadian Dollar to US Dollar exchange rate (see Column AG) plot the value of the three currencies in terms of both US Dollar to Foreign Currency and Foreign Currency to US Dollar from January of the start year (see Column Z) to December of the end year (see Column AA) What happened to the value of the dollar compared to each currency. Your comment should be included with the graph.

Question 4) Using the start year (see Column Z) and end year(see Column AA) plot the US Dollar to Euro exchange rate (seeColumn AE), the US Dollar to Australian Dollar exchange rate (see ColumnAF) and Canadian Dollar to US Dollar exchange rate (see Column AG)plot the value of the three currencies in terms of both US

THank you in advance

AutoSave OF AA? 2... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments C X [G Arial v 10 ~ A 25 Wrap Text Insert v General ' , AY O Delete v Paste B 1 U UV CvA Av Y Y = = = - Merge & Center v $ % ) Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format v Analyze Data Find & Select V A1 1 X z AB AJ AK AL AM AN Start year AA End year 2004 2014 3 4 5 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 observation date M1SL 11/1/00 61103 7:1/03 &11/03 9/1103 10'1:03 11:1:03 121/03 1:1.04 21:04 3/1/04 4/1/04 51/04 B:1:04 7:1:04 &11/04 911/04 101.04 11/1104 121.04 1:1:05 211.05 311.05 4/1105 51:05 61.105 7/1105 AC AD AE AF AG AMBSL EXUSEU EXUSAL EXCAUS 1092.4 611291 D8552 0.5218 1.5428 1261.0 799.91B 1.1674 0.662 1.3525 1287.5 741.596 1.1365 0.8607 1.3821 12964 745.687 1.1156 0.8518 1.3983 1297.2 746839 1.1267 0.8635 1.3834 1297.9 753 935 1.1714 0.8943 1.2221 1299.1 754901 1.171 0.7188 1.313 13062 752980 1.2298 0.7291 1.3129 1306.0 755 824 12538 0.7717 1.2959 13214 763 246 1.254 0.777 1.3299 1328.7 764.456 1.2261 0.7495 1.3286 1332.B 768.000 1.1889 0.7443 1.342 1333.3 770.188 1.2 0.7059 1.3789 1342.7 775.422 1.2146 0.8837 1.3578 1340.8 780.983 12268 0.7161 1.3225 1354.3 781.823 1.2191 0.7111 1.3127 1262.5 796 294 12224 0.7028 1.2891 1262.3 792 217 1.2507 0.7237 1.2469 1374.2 793.892 1.2007 0.7704 1 1.1969 1376.0 787963 13406 0.7575 1.2189 1367.1 793 817 1.3123 0.7668 1.2248 1371.1 800.427 1.3013 0.7812 1.2401 1370,8 800 915 1.3185 0.7848 1.216 13584 802 330 12943 0.7738 1.2359 4200 1366.0 800 439 12597 0.7663 1.2555 1380.1 8114 9153 12156 0.7667 1.24012 1369.00 8116 6016 12:41 0.71574 1.2229 1378.00 HIB 01:55 1.2296 0.7614 1.2023 1378.6 812420 12234 0.7661 1.1777 1376.6 816 732 12022 0.7635 1.1774 1376,9 817.475 1.1789 0.7363 1.1815 1374.3 16.430 1.1961 0.7423 1.1615 1379.5 225.173 12126 0.7505 1.1672 1378.4 232.414 1.194 0.7418 1.1499 1383.1 234.047 12028 0.7200 1.1573 13814 835 329 12273 0.7389 1.1441 1387.2 836.974 12767 0.7639 1.11 1375.5 836.893 1.2861 0.7399 1.1137 1372.5 835 001 1.2881 0.7528 1.1294 1372.6 834.647 1.281 0.7631 1.1182 1361.3 834.227 12722 0.7519 1.1181 911/05 101/08 11/1105 1241/05 1/1/06 211/08 31/06 4/1/08 5/1/08 B:1/08 71/08 81/08 9:1108 data + Ready Average: 7609.469333 Count: 1186 Sum: 8781327.611 + 110% % AutoSave OF AA? 2... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 ~ A C. 5 Wrap Text General E. Insert v AY O [G Paste B 1 U oy A = = = Merge & Center v Y $ % Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter v Find & Select Sensitivity Analyze Data V A1 Y z AB AC AE AF AG AH AI AJ AK AL AM 1.1286 1.1359 1.1532 1.1763 1.171 1.2617 1.2896 1.3205 1.2993 1.308 1.3248 1.3513 1.3510 1.3421 1.3726 1.2626 1.3511 1.4233 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 50 60 81 82 83 84 65 66 67 68 69 70 71 72 73 74 75 763 77 78 79 80 81 1011:06 11/1/06 12/1/06 1/1/07 2/1/07 3/1/07 4/1/07 5/1:07 B/1:07 7/1/07 B/1/07 93/1/17 10/1/07 11/1/07 12/1/07 1/1/08 2/1/08 3/1/08 4/1/08 5/1:06 B/1/06 7/1/06 8/1/18 5/1/08 10/108 11/1/08 12/1/08 1/1/09 2/1/09 3/1/09 4/1/09 5/1/09 6/1:09 7/1/0099 1/1/00 5/1/09 1011/09 11/1/09 1370.4 1370.5 1388.4 1371.7 1382.9 1388.4 1378.2 1391,0 1388.2 1371.9 1376.8 1371.6 13796 13712 1373.0 1377.7 1380.4 1388.6 1391.6 1393.6 1404.6 1421.2 14.17.9 1462.2 1474.1 1513.6 1601.1 1582.8 1587.1 157.8 1612.0 1617.9 1659.0 16412.7 1600.7 1655.1 1678.3 1681.3 1691.9 AD --- 337.901 840.328 837.709 843.499 847.280 848.177 B49.954 849.602 351.165 B61.802 BA3.299 11.4014 896.411 857.433 847.370 851.369 857.100 880.680 855.651 B60.67 B63.BA 871.637 872.297 536.491 1142.185 1480.773 1669.269 1730. 169 1590.168 1688.491 1787.713 1799.228 1704.012 1683.749 1729.132 1819.780 1975.372 2014.694 2017.350 1.4683 1.4559 1.1728 1.4758 1.552 1.5754 1.5654 1.6842 1.5759 1.4955 1.4342 1.9266 1.2744 1.3511 1.3244 1.2797 1.305 1.3199 1.3648 1.4014 1.40012 1.4266 1.4575 1.4821 1.4908 1.4570 0.7544 0.7728 0.7858 0.7826 0.783 0.7932 0.8273 0.8254 0.8423 0.8877 D.8291 0.41 0.8986 0.8981 0.8719 0.8823 0.9133 0.9221 0.9309 0.9492 0.9511 0.962 0.8415 0.8168 0.687 0.6581 0.6719 0.6754 0.6504 0.0866 0.7158 0.7646 D.8025 0.149 0.8353 0.8522 0.9067 0.9187 0.9021 1.1882 1.135 1.0951 1.0861 1.0502 1.0579 1.01267 0.9754 0.9672 1,0021 1.0099 0.9886 1.0029 1.0137 0.9993 1.0166 1.013 1.1586 10587 1.1847 12171 12337 12248 12452 1.2845 12242 1.1528 1.1264 1.1229 10472 1 09-16 10547 1,0596 1.0537 12/1:00 data + Ready Average: 7609.469333 Count: 1136 Sum: 8781327.611 OP + 110% % AutoSave OF AA? 2... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial C v 10 ~ Al 25 Wrap Text Insert v General X [G Ayu 0 Delete Paste B 1 Uv Oy A - Y = = = - Merge & Center v $ $ % ) Conditional Format Cell Formatting es Table Styles Sensitivity Sort & Filter # Format Find & Select Analyze Data V A1 X Y Z AA AB AC AD AE AF AG AH AL AJ AK AL 1691.8 1674.5 1699.7 14579 1.4266 1.368 1.357 1.3417 12563 1.2223 12811 1.2003 13103 91 82 83 84 85 86 87 BB 99 90 1 92 93 94 95 BE 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 1211.09 1:1110 211/10 3/1/10 411/10 5/1/10 G11/10 7:1/10 81/10 911/10 101110 11/1/10 121/10 1/1/11 21/11 311/11 4/1/11 5/1/11 G1/11 7/1/11 841/11 11/11 10/1/11 11/1/11 1211/11 1/1/12 211/12 31/12 4/1/12 511/12 G41/12 7/1/12 841/12 SV1/12 10/1/12 11/1/12 12/1/12 1/1/13 1711.8 1899.8 1710.8 1731.7 1724.4 1749.3 1766.5 17809 18252 1995.8 1853 1872.5 1891.3 19014 1938.7 1968.2 2001.9 2113.8 2124.1 2140.2 2164.1 2163.5 2201.8 2209.9 2229.0 2248.8 2267.2 2277.3 2218.5 2348.9 23501 2422.5 2421.2 2460.5 2473.3 2017 350 2010.154 2151.018 2106.633 2044 379 2034.558 2024 077 2015 286 2014.724 1991 247 19198 598 1991.198 2009 353 2057 208 2213 647 2428 273 2531 785 2590 433 2871.520 2703 588 2580 468 2655682 2678 541 2523.193 2503.716 2547.726 2733 303 2884.414 2873 910 2836.134 2844 989 2869 480 2009 841) 2669 2415 688 2549 206 2565 524 2557 234 2719 240 1.3901 13654 1.3221 1.3371 1.3656 1.402 1.446 1.4335 1.4403 1.4275 1.4333 13747 13732 1.3558 1.3155 1.291 13238 1.3208 1.316 12906 12541 12278 1.2406 12895 12974 12837 1.3119 1.3304 0.9021 0.9127 0.8857 0.8123 0.8262 0.8713 0.8539 0.8788 0.900 0.9399 0.51818 0.9883 0.8929 0.8562 1.0084 1.0113 1.0589 1.0675 1.0617 1.0781 1.0502 1.6822 1.01168 1.0112 1.0122 1.0415 1.0732 1.0528 1.085 0.999 0.9900 1.03 1.0475 1.0406 1 0295 1.0405 1.0465 1.05 1,083 1.0438 1.0572 1.0228 1.0052 1.0403 1.0378 1.0422 1.0404 1.033 1.0179 1.0129 1.0081 0.9938 0.9676 0.9766 0.95 0.986 0.9766 0.9652 0.9817 1.0025 1.0198 1.0249 1.0235 1.013 0.8937 0.8938 0.9926 1.0097 1.029 1.0142 (1.9824 01.9783 0.5672 0.997 0.9698 0.8921 data + Ready Average: 7809.469333 Count: 1136 Sum: 8781327.611 EP + 110% AutoSave OF A APC ... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial C. v 10 VA 5 Wrap Text Insert v General X [G 0 0 >Delete Paste 1 B U = = = oy A -- Merge & Center v Y Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Sensitivity Analyze Data V A1 fix Y z AA AB AC AD AE AF AH A AJ AK 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 156 1/1/13 211.13 3/1/13 4'1/13 5'1:13 6'1/13 7/1/13 8'1/13 9/1/13 10/1/13 11/1/18 12/1/13 1/1/14 211/14 311/14 4'1/14 11/14 6'1/14 7/1/14 841/14 9/1/14 10/1/14 11/1/14 121.14 1/1/15 211.15 3/1/15 4'1/16 E'1/15 5'1/15 7/1/15 8/1/15 9/1/15 10/1/15 11/1/15 12/1/15 1/1/10 2/1/16 24733 24724 2480.4 2515.8 25307 2531.4 28458 2559 1 25845 26230 2523.1 2564.4 28864 2726.4 2754.8 2778.6 27952 24296 28416 280129 28622 2858 8 2884.9 2940.7 29410 3007.1 29996 30009 29966 301200 30397 30285 30442 3018.6 3081.7 30949 3099.0 3130.4 2748.210 2874.699 2973.670 3045.884 3139.227 2222.379 23101.340 2419.645 9509.062 3630.758 3702.165 3685.395 3733.580 3889.628 3925.880 2985.202 2932.630 2970.973 40019.08.1 4097.276 4072.188 4041.445 38/8.112 3898.571 4019.999 3868.788 4091.659 4099.282 2959. 169 2951.299 9989.687 4003,503 4048.765 4098.142 4028.138 3818.145 3779.881 3908.947 1.3394 1.3347 1.2953 1.3025 1.2993 1.3197 1.3098 1.3314 1.3354 1.3546 1.3481 1.3708 1.3818 1.3885 1.3828 1.391 1.3739 1.3485 1.34.13 1,3315 1.2880 1.2677 1.2473 1.2329 1.1615 1.135 1.0819 1.0422 1.1167 1.1225 1.04137 1.1136 1.1220 1.1228 1.0727 1.0889 1.0855 1.1092 1.05 1.031 1.0345 1.038 0.9919 0.944 D.9155 09:37 09308 0.9519 0.9324 0.888 0.8958 0.8974 0.9089 0.9316 0.9306 0.9365 09389 0.9309 09942 0.8781 0.8544 0.8257 0.8064 0.7797 0.7724 0.774 D.7991 [ 1 1.7715 D7407 0.7255 0.7059 0.72 0.7146 0.7247 0.7011 0.7134 AG 0.8821 1.0098 1.0244 1.0187 1.0198 1.0314 1.9402 1.1407 1.0342 1.9363 1.5488 1.0639 1.094 1.1054 1.1 107 1.0992 1.0894 1.083 1.417351 1.0526 1.1011 1.1212 1.1325 1.1532 1.2122 1.2499 1.2018 1.2237 1.2176 1.2965 1.2863 1.3147 1.3266 1.3072 1.3279 1.3713 1.4208 1.3797 data + Ready Average: 7609.469333 Count: 1136 Sum: 8781327.611 , + 110% AutoSave OF A APO ... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial C v 10 ~ A 25 Wrap Text Insert v General X G Ayo Delete Paste B 1 U U UvA = = = Y -- Merge & Center v $ $ % ) Sensitivity Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Analyze Data V A1 v w Y z AA AB AE AF AG AH A AJ 1.3797 1.3228 1.2819 155 156 167 156 159 160 161 162 163 164 165 166 167 188 189 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 100 211/16 31/16 41/16 &'1/16 6 1/16 7/1/16 811/16 911116 10/1/16 11:1/16 121/16 1/1/17 2/1/17 3:1/17 4/1/17 $11/17 61/17 7/1/17 811117 91117 10/1117 11:1:17 12117 1:1/18 21/18 3'1/18 4/1/18 41118 6/1/18 7/1/18 8/1/18 9/1/18 10/1/18 11/1/18 1211/18 AC 31304 3151.1 32003 3238.7 3246.7 3247.8 3315.1 3326.5 3335.7 3351.1 33424 3390.9 3404.7 3445.5 3454.2 3517.3 3579.80 3550.8 3580.7 3574.2 3606.7 3630.8 38 12.0 3853.2 3822.5 3866.4 3660.3 36554.7 3656.0 3676.8 3679.8 3703.5 3718. 3895.3 3744.1 AD 3908.947 3926 824 3912355 395B 600 3946 348 3748 9129 3843 108 3750.198 3008.149 3519.012 3509874 3594 328 3781494 3907.717 3953 027 3797.079 3797.151 3403 323 3929 042 3886 075 3871.663 3925.682 3823.708 3925.077 3991 241 3933 319 3756 052 3695 453 3675 647 3531.036 3503.593 3572.161 3560.108 3402731 3372911 1.1092 1.1134 1.1346 1.1312 1.1232 1.10156 1.1207 1.12-18 1.1014 1.0782 1.0545 1.0835 1.066 1.0891 1.0714 1.106 1.1283 1.153 1.1913 1.1813 1.1755 1.1743 1.1836 12197 1.234 12334 1.227 1.1423 1.1679 1 1685 1.1547 1.1667 1.1188 1.1364 1.138 0.7134 0.7504 0.7664 0.7318 0.7401 0.75731 0.7623 0.7591 0.7615 0.7532 0.7346 0.7465 0.7684 0.7622 0.7534 0.7437 0.7562 0.7807 0.7915 0.7974 0.7788 0.762 0.7648 0.7956 0.7867 0.7769 0.764 0.7525 0.7451 0.7403 0.7325 0.7205 0.7111 0.7247 0.7189 1.2945 1.2844 1.3052 1.2989 1.3108 1.3251 1.3431 1.3338 1.3183 1.3109 1.3397 1.3437 1.36016 1.3215 1.259 1.2609 1.2279 1.2607 1.2773 1.2769 1.2429 1.2590 1.2933 1.2732 1.2 1.3125 1.3133 1.3042 1.3034 1.3004 1.3205 1.3438 data + Ready Average: 7609.469333 Count: 1186 Sum: 8781327.611 + 110% AutoSave OF AA? 2... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments C X [G Arial v 10 ~ A 25 Wrap Text Insert v General ' , AY O Delete v Paste B 1 U UV CvA Av Y Y = = = - Merge & Center v $ % ) Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format v Analyze Data Find & Select V A1 1 X z AB AJ AK AL AM AN Start year AA End year 2004 2014 3 4 5 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 observation date M1SL 11/1/00 61103 7:1/03 &11/03 9/1103 10'1:03 11:1:03 121/03 1:1.04 21:04 3/1/04 4/1/04 51/04 B:1:04 7:1:04 &11/04 911/04 101.04 11/1104 121.04 1:1:05 211.05 311.05 4/1105 51:05 61.105 7/1105 AC AD AE AF AG AMBSL EXUSEU EXUSAL EXCAUS 1092.4 611291 D8552 0.5218 1.5428 1261.0 799.91B 1.1674 0.662 1.3525 1287.5 741.596 1.1365 0.8607 1.3821 12964 745.687 1.1156 0.8518 1.3983 1297.2 746839 1.1267 0.8635 1.3834 1297.9 753 935 1.1714 0.8943 1.2221 1299.1 754901 1.171 0.7188 1.313 13062 752980 1.2298 0.7291 1.3129 1306.0 755 824 12538 0.7717 1.2959 13214 763 246 1.254 0.777 1.3299 1328.7 764.456 1.2261 0.7495 1.3286 1332.B 768.000 1.1889 0.7443 1.342 1333.3 770.188 1.2 0.7059 1.3789 1342.7 775.422 1.2146 0.8837 1.3578 1340.8 780.983 12268 0.7161 1.3225 1354.3 781.823 1.2191 0.7111 1.3127 1262.5 796 294 12224 0.7028 1.2891 1262.3 792 217 1.2507 0.7237 1.2469 1374.2 793.892 1.2007 0.7704 1 1.1969 1376.0 787963 13406 0.7575 1.2189 1367.1 793 817 1.3123 0.7668 1.2248 1371.1 800.427 1.3013 0.7812 1.2401 1370,8 800 915 1.3185 0.7848 1.216 13584 802 330 12943 0.7738 1.2359 4200 1366.0 800 439 12597 0.7663 1.2555 1380.1 8114 9153 12156 0.7667 1.24012 1369.00 8116 6016 12:41 0.71574 1.2229 1378.00 HIB 01:55 1.2296 0.7614 1.2023 1378.6 812420 12234 0.7661 1.1777 1376.6 816 732 12022 0.7635 1.1774 1376,9 817.475 1.1789 0.7363 1.1815 1374.3 16.430 1.1961 0.7423 1.1615 1379.5 225.173 12126 0.7505 1.1672 1378.4 232.414 1.194 0.7418 1.1499 1383.1 234.047 12028 0.7200 1.1573 13814 835 329 12273 0.7389 1.1441 1387.2 836.974 12767 0.7639 1.11 1375.5 836.893 1.2861 0.7399 1.1137 1372.5 835 001 1.2881 0.7528 1.1294 1372.6 834.647 1.281 0.7631 1.1182 1361.3 834.227 12722 0.7519 1.1181 911/05 101/08 11/1105 1241/05 1/1/06 211/08 31/06 4/1/08 5/1/08 B:1/08 71/08 81/08 9:1108 data + Ready Average: 7609.469333 Count: 1186 Sum: 8781327.611 + 110% % AutoSave OF AA? 2... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 ~ A C. 5 Wrap Text General E. Insert v AY O [G Paste B 1 U oy A = = = Merge & Center v Y $ % Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter v Find & Select Sensitivity Analyze Data V A1 Y z AB AC AE AF AG AH AI AJ AK AL AM 1.1286 1.1359 1.1532 1.1763 1.171 1.2617 1.2896 1.3205 1.2993 1.308 1.3248 1.3513 1.3510 1.3421 1.3726 1.2626 1.3511 1.4233 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 50 60 81 82 83 84 65 66 67 68 69 70 71 72 73 74 75 763 77 78 79 80 81 1011:06 11/1/06 12/1/06 1/1/07 2/1/07 3/1/07 4/1/07 5/1:07 B/1:07 7/1/07 B/1/07 93/1/17 10/1/07 11/1/07 12/1/07 1/1/08 2/1/08 3/1/08 4/1/08 5/1:06 B/1/06 7/1/06 8/1/18 5/1/08 10/108 11/1/08 12/1/08 1/1/09 2/1/09 3/1/09 4/1/09 5/1/09 6/1:09 7/1/0099 1/1/00 5/1/09 1011/09 11/1/09 1370.4 1370.5 1388.4 1371.7 1382.9 1388.4 1378.2 1391,0 1388.2 1371.9 1376.8 1371.6 13796 13712 1373.0 1377.7 1380.4 1388.6 1391.6 1393.6 1404.6 1421.2 14.17.9 1462.2 1474.1 1513.6 1601.1 1582.8 1587.1 157.8 1612.0 1617.9 1659.0 16412.7 1600.7 1655.1 1678.3 1681.3 1691.9 AD --- 337.901 840.328 837.709 843.499 847.280 848.177 B49.954 849.602 351.165 B61.802 BA3.299 11.4014 896.411 857.433 847.370 851.369 857.100 880.680 855.651 B60.67 B63.BA 871.637 872.297 536.491 1142.185 1480.773 1669.269 1730. 169 1590.168 1688.491 1787.713 1799.228 1704.012 1683.749 1729.132 1819.780 1975.372 2014.694 2017.350 1.4683 1.4559 1.1728 1.4758 1.552 1.5754 1.5654 1.6842 1.5759 1.4955 1.4342 1.9266 1.2744 1.3511 1.3244 1.2797 1.305 1.3199 1.3648 1.4014 1.40012 1.4266 1.4575 1.4821 1.4908 1.4570 0.7544 0.7728 0.7858 0.7826 0.783 0.7932 0.8273 0.8254 0.8423 0.8877 D.8291 0.41 0.8986 0.8981 0.8719 0.8823 0.9133 0.9221 0.9309 0.9492 0.9511 0.962 0.8415 0.8168 0.687 0.6581 0.6719 0.6754 0.6504 0.0866 0.7158 0.7646 D.8025 0.149 0.8353 0.8522 0.9067 0.9187 0.9021 1.1882 1.135 1.0951 1.0861 1.0502 1.0579 1.01267 0.9754 0.9672 1,0021 1.0099 0.9886 1.0029 1.0137 0.9993 1.0166 1.013 1.1586 10587 1.1847 12171 12337 12248 12452 1.2845 12242 1.1528 1.1264 1.1229 10472 1 09-16 10547 1,0596 1.0537 12/1:00 data + Ready Average: 7609.469333 Count: 1136 Sum: 8781327.611 OP + 110% % AutoSave OF AA? 2... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial C v 10 ~ Al 25 Wrap Text Insert v General X [G Ayu 0 Delete Paste B 1 Uv Oy A - Y = = = - Merge & Center v $ $ % ) Conditional Format Cell Formatting es Table Styles Sensitivity Sort & Filter # Format Find & Select Analyze Data V A1 X Y Z AA AB AC AD AE AF AG AH AL AJ AK AL 1691.8 1674.5 1699.7 14579 1.4266 1.368 1.357 1.3417 12563 1.2223 12811 1.2003 13103 91 82 83 84 85 86 87 BB 99 90 1 92 93 94 95 BE 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 1211.09 1:1110 211/10 3/1/10 411/10 5/1/10 G11/10 7:1/10 81/10 911/10 101110 11/1/10 121/10 1/1/11 21/11 311/11 4/1/11 5/1/11 G1/11 7/1/11 841/11 11/11 10/1/11 11/1/11 1211/11 1/1/12 211/12 31/12 4/1/12 511/12 G41/12 7/1/12 841/12 SV1/12 10/1/12 11/1/12 12/1/12 1/1/13 1711.8 1899.8 1710.8 1731.7 1724.4 1749.3 1766.5 17809 18252 1995.8 1853 1872.5 1891.3 19014 1938.7 1968.2 2001.9 2113.8 2124.1 2140.2 2164.1 2163.5 2201.8 2209.9 2229.0 2248.8 2267.2 2277.3 2218.5 2348.9 23501 2422.5 2421.2 2460.5 2473.3 2017 350 2010.154 2151.018 2106.633 2044 379 2034.558 2024 077 2015 286 2014.724 1991 247 19198 598 1991.198 2009 353 2057 208 2213 647 2428 273 2531 785 2590 433 2871.520 2703 588 2580 468 2655682 2678 541 2523.193 2503.716 2547.726 2733 303 2884.414 2873 910 2836.134 2844 989 2869 480 2009 841) 2669 2415 688 2549 206 2565 524 2557 234 2719 240 1.3901 13654 1.3221 1.3371 1.3656 1.402 1.446 1.4335 1.4403 1.4275 1.4333 13747 13732 1.3558 1.3155 1.291 13238 1.3208 1.316 12906 12541 12278 1.2406 12895 12974 12837 1.3119 1.3304 0.9021 0.9127 0.8857 0.8123 0.8262 0.8713 0.8539 0.8788 0.900 0.9399 0.51818 0.9883 0.8929 0.8562 1.0084 1.0113 1.0589 1.0675 1.0617 1.0781 1.0502 1.6822 1.01168 1.0112 1.0122 1.0415 1.0732 1.0528 1.085 0.999 0.9900 1.03 1.0475 1.0406 1 0295 1.0405 1.0465 1.05 1,083 1.0438 1.0572 1.0228 1.0052 1.0403 1.0378 1.0422 1.0404 1.033 1.0179 1.0129 1.0081 0.9938 0.9676 0.9766 0.95 0.986 0.9766 0.9652 0.9817 1.0025 1.0198 1.0249 1.0235 1.013 0.8937 0.8938 0.9926 1.0097 1.029 1.0142 (1.9824 01.9783 0.5672 0.997 0.9698 0.8921 data + Ready Average: 7809.469333 Count: 1136 Sum: 8781327.611 EP + 110% AutoSave OF A APC ... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial C. v 10 VA 5 Wrap Text Insert v General X [G 0 0 >Delete Paste 1 B U = = = oy A -- Merge & Center v Y Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Sensitivity Analyze Data V A1 fix Y z AA AB AC AD AE AF AH A AJ AK 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 156 1/1/13 211.13 3/1/13 4'1/13 5'1:13 6'1/13 7/1/13 8'1/13 9/1/13 10/1/13 11/1/18 12/1/13 1/1/14 211/14 311/14 4'1/14 11/14 6'1/14 7/1/14 841/14 9/1/14 10/1/14 11/1/14 121.14 1/1/15 211.15 3/1/15 4'1/16 E'1/15 5'1/15 7/1/15 8/1/15 9/1/15 10/1/15 11/1/15 12/1/15 1/1/10 2/1/16 24733 24724 2480.4 2515.8 25307 2531.4 28458 2559 1 25845 26230 2523.1 2564.4 28864 2726.4 2754.8 2778.6 27952 24296 28416 280129 28622 2858 8 2884.9 2940.7 29410 3007.1 29996 30009 29966 301200 30397 30285 30442 3018.6 3081.7 30949 3099.0 3130.4 2748.210 2874.699 2973.670 3045.884 3139.227 2222.379 23101.340 2419.645 9509.062 3630.758 3702.165 3685.395 3733.580 3889.628 3925.880 2985.202 2932.630 2970.973 40019.08.1 4097.276 4072.188 4041.445 38/8.112 3898.571 4019.999 3868.788 4091.659 4099.282 2959. 169 2951.299 9989.687 4003,503 4048.765 4098.142 4028.138 3818.145 3779.881 3908.947 1.3394 1.3347 1.2953 1.3025 1.2993 1.3197 1.3098 1.3314 1.3354 1.3546 1.3481 1.3708 1.3818 1.3885 1.3828 1.391 1.3739 1.3485 1.34.13 1,3315 1.2880 1.2677 1.2473 1.2329 1.1615 1.135 1.0819 1.0422 1.1167 1.1225 1.04137 1.1136 1.1220 1.1228 1.0727 1.0889 1.0855 1.1092 1.05 1.031 1.0345 1.038 0.9919 0.944 D.9155 09:37 09308 0.9519 0.9324 0.888 0.8958 0.8974 0.9089 0.9316 0.9306 0.9365 09389 0.9309 09942 0.8781 0.8544 0.8257 0.8064 0.7797 0.7724 0.774 D.7991 [ 1 1.7715 D7407 0.7255 0.7059 0.72 0.7146 0.7247 0.7011 0.7134 AG 0.8821 1.0098 1.0244 1.0187 1.0198 1.0314 1.9402 1.1407 1.0342 1.9363 1.5488 1.0639 1.094 1.1054 1.1 107 1.0992 1.0894 1.083 1.417351 1.0526 1.1011 1.1212 1.1325 1.1532 1.2122 1.2499 1.2018 1.2237 1.2176 1.2965 1.2863 1.3147 1.3266 1.3072 1.3279 1.3713 1.4208 1.3797 data + Ready Average: 7609.469333 Count: 1136 Sum: 8781327.611 , + 110% AutoSave OF A APO ... EXCEL INFO Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial C v 10 ~ A 25 Wrap Text Insert v General X G Ayo Delete Paste B 1 U U UvA = = = Y -- Merge & Center v $ $ % ) Sensitivity Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Analyze Data V A1 v w Y z AA AB AE AF AG AH A AJ 1.3797 1.3228 1.2819 155 156 167 156 159 160 161 162 163 164 165 166 167 188 189 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 100 211/16 31/16 41/16 &'1/16 6 1/16 7/1/16 811/16 911116 10/1/16 11:1/16 121/16 1/1/17 2/1/17 3:1/17 4/1/17 $11/17 61/17 7/1/17 811117 91117 10/1117 11:1:17 12117 1:1/18 21/18 3'1/18 4/1/18 41118 6/1/18 7/1/18 8/1/18 9/1/18 10/1/18 11/1/18 1211/18 AC 31304 3151.1 32003 3238.7 3246.7 3247.8 3315.1 3326.5 3335.7 3351.1 33424 3390.9 3404.7 3445.5 3454.2 3517.3 3579.80 3550.8 3580.7 3574.2 3606.7 3630.8 38 12.0 3853.2 3822.5 3866.4 3660.3 36554.7 3656.0 3676.8 3679.8 3703.5 3718. 3895.3 3744.1 AD 3908.947 3926 824 3912355 395B 600 3946 348 3748 9129 3843 108 3750.198 3008.149 3519.012 3509874 3594 328 3781494 3907.717 3953 027 3797.079 3797.151 3403 323 3929 042 3886 075 3871.663 3925.682 3823.708 3925.077 3991 241 3933 319 3756 052 3695 453 3675 647 3531.036 3503.593 3572.161 3560.108 3402731 3372911 1.1092 1.1134 1.1346 1.1312 1.1232 1.10156 1.1207 1.12-18 1.1014 1.0782 1.0545 1.0835 1.066 1.0891 1.0714 1.106 1.1283 1.153 1.1913 1.1813 1.1755 1.1743 1.1836 12197 1.234 12334 1.227 1.1423 1.1679 1 1685 1.1547 1.1667 1.1188 1.1364 1.138 0.7134 0.7504 0.7664 0.7318 0.7401 0.75731 0.7623 0.7591 0.7615 0.7532 0.7346 0.7465 0.7684 0.7622 0.7534 0.7437 0.7562 0.7807 0.7915 0.7974 0.7788 0.762 0.7648 0.7956 0.7867 0.7769 0.764 0.7525 0.7451 0.7403 0.7325 0.7205 0.7111 0.7247 0.7189 1.2945 1.2844 1.3052 1.2989 1.3108 1.3251 1.3431 1.3338 1.3183 1.3109 1.3397 1.3437 1.36016 1.3215 1.259 1.2609 1.2279 1.2607 1.2773 1.2769 1.2429 1.2590 1.2933 1.2732 1.2 1.3125 1.3133 1.3042 1.3034 1.3004 1.3205 1.3438 data + Ready Average: 7609.469333 Count: 1186 Sum: 8781327.611 + 110%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!