Download the Big Mac index data here: https://github.com/TheEconomist/big-mac-data/blob/master/source-data/big-mac-source-data.csv. Use this data to answer the following questions.

1. Create a new column with the real exchange rate for every country in the spreadsheet. Use Excel formulas.

2. Make a scatter plot in Excel of the GDP (expressed in USD using the nominal interest rate) and the real

exchange rate.

3. Find the line of best fit for the data (by adding a "add trendline" to the plot.)

4. Using the equation for the trendline you obtain, predict the RER for each country

5. Discuss which currencies are over-valued and which are under-valued.