Task One
Calculate the rate of growth of the exchange rates between two currencies using exchange rate data on your selected countries. Before doing so, answer the following question.
What is the rate of growth and which formula is used to calculate it?
Display the rates of growth of the exchange rates between the two currencies of your selected countries in Excel or SPSS (or Tableau) chart/graph over the period 2000-2021.
Task Two
Calculate the inflation rates in each of your two selected countries using the Consumer Price
Index (CPI) from the 2022 WDI data. Remember the inflation rate is the rate of growth of the
CPI.
Display the inflation rates of your selected countries in Excel or SPSS (or Tableau) chart/graph
over the period 2000-2021. Then answer the following question.
Which of your two selected countries has the highest rate of inflation based on the CPI?
Task Three
Calculate the inflation rates in each of your two selected countries using the GDP Deflator from
the 2022 WDI data. Remember the inflation rate is the rate of growth of the GDP Deflator.
Display the inflation rates of your selected countries in Excel or SPSS (or Tableau) chart/graph
over the period 2000-2021. Then answer the following question.
Which of your two selected countries has the highest rate of inflation based on the GDP
Deflator?
Task Four
Calculate the difference between your two selected countries CPI based inflation rate. This difference is the predicted rates of growth of the exchange rate over the period 2000-2021.
Also, calculate the difference between your two selected countries GDP Deflator based inflation
rate. These differentials are also known as the predicted rates of growth of the exchange rate over
the period 2000-2021.
Display the predicted rates of growth of the exchange rate of currencies of your selected
countries (from both the CPI and the GDP Deflator) in Excel or SPSS (or Tableau) chart/graph
over the period 2000-2021. Then answer the following question.
Are there any substantial differences in the predicted rates of growth of the exchange rates of
currencies of your selected countries over 2000-2021 from the two indicators (CPI and GDP
Deflator)?
Task Five
Display the actual and predicted rates of growth of the exchange rate of currencies of your
selected countries (calculated in Task One and in Task Four) in Excel or SPSS (or Tableau)
chart/graph over the period 2000-2021. Then answer the following question.
Is the PPP a theory of the exchange rate determination in the long run based on the CPI? (Hints:
You should compare the actual rates of growth of the exchange rates of currencies of your
selected countries to the predicted rates of growth of the exchange rates of currencies of your
selected countries based on the CPI).
Is the PPP a theory of the exchange rate determination in the long run based on the GDP
Deflator? (Hints: You should compare the actual rates of growth of the exchange rates of
currencies of your selected countries to the predicted rates of growth of the exchange rates of
currencies of your selected countries based on the GDP Deflator)
Task Six
Use your answers to the questions and your visuals to draft a full report describing all the results
obtained from Task One to Task Five. What were the challenges in completing this project and
how did you overcome them?