Project #46248 - International Economics

 

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
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy