This assignment tests your ability to find, download, manipulate and chart statistical series in a way that is mathematically correct and visually appealing using Excel software.

The underlying formulae, commands and specifications have been hidden from the examples provided, but you should **not** do so yourself. The cells you fill in MUST contain the underlying formulae and commands.

Likewise, the charts in the examples provided are pasted images of the originals, but you should provide the original charts linked to the data that you've put on this spreadsheet.

Download the monthly statistical series for the nominal and real effective exchange rates from January 2000 to the present for a foreign country/currency of your choice from the Bank for International Settlement's website (see source and URL in lines 204-205).

1) Prepare a chart of the nominal and real effective exchange rates for the period since Jan-00, to be formatted to look **exactly** like the example; that is, same size, fonts, colors, line styles, borders, tick marks, legends, etc., **except** that you should adjust the vertical scale to maximize the display of information (1 point).

2) Provide the answer to the following question in S38: Did the currency of your choice experience a nominal and/or real effective appreciation or depreciation during the global financial crisis of late 2008/early 2009 (namely, between Aug-08 and Mar-09), and if so by how much? Show how you did your calculations in box I135 (1 point).

3) Prepare a chart of the real effective exchange rates for the currency of your choice (except for the Swiss franc, which is the example) and for the USD for the period since Jan-04, to be formatted to look **exactly** like the example;that is, same size, fonts, colors, line styles, borders, tick marks, legends, etc., **except** that you may adjust the vertical scale to retain the same display of information (1 point).

4) Answer the following question starting in S58: If Canada's nominal GDP in 2011 was CAD 1.719 trillion, and the CAD/USD spot exchange rate averaged 0.99 in 2011, how much was Canada's GDP worth in USD? (1 point)

5) Answer the following question starting in S61: If Mexico's nominal GDP in 2011 was USD 1.155 trillion, and the MXP/USD spot exchange rate averaged 12.42 in 2011, how much was Mexico's GDP worth in MXP? (1 point)

Subject | General |

Due By (Pacific Time) | 11/06/2014 08:00 am |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |