In slide 14 of the lecture on chapter 19 of our textbook, I compared the GDPs of United States and Brazil from 2005 to 2010. Now it is your turn! The excel file below contains data on GDP, GDP deflator and PPP exchange rate for several countries. Data are from the World Bank. Choose two countries and six consecutive years. Then compare the GDP of these two countries in dollars at constant 2017 prices. Set up a table like I did on slide 14 and post the results. The excel file contains four sheets: the first is GDP at local currency unit (LCU), the second is GDP deflator (base year varies by country), the third is PPP exchange rate (LCU/dollar), and the fourth is GDP in PPP dollars at 2017 prices (so you can use the fourth sheet to check your results and see if you are doing it right). You may need to "enable editing" once you open the excel file in order to use it. Comparing GDPs of United States and Brazil 2005 2009 2010 PY US$ 13,037 United States (billions) 2006 2007 2008 13,815 14,452 14,713 0.96 0.98 1.00 14,391 14,747 14,713 14,449 14,992 1.02 P 0.93 1.01 Y 2008 US$ 14,018 14,306 14,698 2005 2010 PY R$ 3,886 2,171 0.81 P Brazil (billions) 2006 2007 2008 2009 2,409 2,720 3,110 3,333 0.86 0.92 1.00 1.07 2,801 2,957 3,110 3,115 2008 PPP exchange rate = 1.216 R$/US$ 2,304 2,431 2,558 2,562 1.16 Y 2008 R$ 2,680 3,350 Y 2008 US$ 2,204 2,755 In slide 14 of the lecture on chapter 19 of our textbook, I compared the GDPs of United States and Brazil from 2005 to 2010. Now it is your turn! The excel file below contains data on GDP, GDP deflator and PPP exchange rate for several countries. Data are from the World Bank. Choose two countries and six consecutive years. Then compare the GDP of these two countries in dollars at constant 2017 prices. Set up a table like I did on slide 14 and post the results. The excel file contains four sheets: the first is GDP at local currency unit (LCU), the second is GDP deflator (base year varies by country), the third is PPP exchange rate (LCU/dollar), and the fourth is GDP in PPP dollars at 2017 prices (so you can use the fourth sheet to check your results and see if you are doing it right). You may need to "enable editing" once you open the excel file in order to use it. Comparing GDPs of United States and Brazil 2005 2009 2010 PY US$ 13,037 United States (billions) 2006 2007 2008 13,815 14,452 14,713 0.96 0.98 1.00 14,391 14,747 14,713 14,449 14,992 1.02 P 0.93 1.01 Y 2008 US$ 14,018 14,306 14,698 2005 2010 PY R$ 3,886 2,171 0.81 P Brazil (billions) 2006 2007 2008 2009 2,409 2,720 3,110 3,333 0.86 0.92 1.00 1.07 2,801 2,957 3,110 3,115 2008 PPP exchange rate = 1.216 R$/US$ 2,304 2,431 2,558 2,562 1.16 Y 2008 R$ 2,680 3,350 Y 2008 US$ 2,204 2,755