Question

Country	Continent	GDP (millions of US$)
Afghanistan	Asia	18,181
Albania	Europe	12,847
Algeria	Africa	190,709
Angola	Africa	100,948
Argentina	South America	447,644
Australia	Oceania	1,488,221
Austria	Europe	419,243
Azerbaijan	Europe	62,321
Bahrain	Asia	26,108
Bangladesh	Asia	113,032
Belarus	Europe	55,483
Belgium	Europe	513,396
Bolivia	Africa	24,604
Bosnia and Herzegovina	Europe	17,965
Botswana	Africa	17,570
Brazil	South America	2,492,908
Brunei	Asia	15,533
Bulgaria	Europe	53,514
Burma	Asia	51,925
Cambodia	Asia	12,861
Cameroon	Africa	25,759
Canada	North America	1,736,869
Chile	South America	248,411
China	Asia	7,298,147
Colombia	South America	328,422
Congo, Democratic Republic of the	Africa	15,668
Congo, Republic of the	Africa	14,769
Costa Rica	North America	40,947
Côte d'Ivoire	Africa	24,096
Croatia	Europe	63,842
Cyprus	Europe	24,949
Czech Republic	Europe	215,265

THE REST IS ON THE NEXT POSTS: Thank U!

Recall in Ch. 2, problem 2, you sorted and filtered the countries in GDPlist data. This time, do the following.

• Build a PivotTable to show the number of countries in each continent and the average GDP of countries in each continent (use Continent as the row label).
• Format the average GDP with one decimal digit and comma for 1000 separator, e.g., 123,456.7.
• Sort the continents in the order of highest average GDP to the lowest average GDP.
• Which continent has the highest average GDP? Which continent has the lowest average GDP?

Answer 1