Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table contains a partial list of countries, the continents on which they are located, and their respective gross domestic products (GDP) in U.S.

The following table contains a partial list of countries, the continents on which they are located, and their respective gross domestic products (GDP) in U.S. dollars. A list of 125 countries and their GDPs is contained in the file GDPlist.

a. Sort the countries in GDPlist from largest to smallest GDP. What are the top 10 countries according to GDP?

b. Filter the countries to display only the countries located in Africa. What are the top 5 countries located in Africa according to GDP?

c. What are the top 5 countries by GDP that are located in Europe?

image text in transcribed

image text in transcribed

B 1 Country Continent DP (millions of US$) 2 Afghanistan Asia 18,181 Albania Europe 12,847 4 Algeria Africa 190,709 5 Angola Africa 100,948 Argentina South Americ 447,644 7 Australia Oceania 1,488,221 Austria Europe 419,243 9 Azerbaijan Europe 62,321 10 Bahrain Asia 26,108 11 Bangladesh Asia 113,032 12 Belarus Europe 55,483 13 Belgium Europe 513,396 14 Bolivia Africa 24,604 15 Bosnia and Herzegovina Europe 17,965 16 Botswana Africa 17,570 17 Brazil South Americ 2,492,908 18 Brunei Asia 15,533 19 Bulgaria Europe 53,514 20 Burma Asia 51,925 21 Cambodia Asia 12,861 22 Cameroon Africa 25,759 23 Canada North Americ 1,736,869 24 Chile South Americ 248,411 25 China Asia 7,298,147 Colombia South Americ 328,422 27 Congo, Democratic Republic Africa 15,668 28 Congo, Republic of the Africa 14,769 29 Costa Rica North Americ 40,947 Cte d'Ivoire Africa 24,096 31 Croatia Europe 63,842 32 Cyprus Europe 24,949 Czech Republic Europe 215,265 34 Denmark Europe 333,238 35 Dominican Republic North Americ 56,700 Ecuador South Americ 66,381 37 Egypt Africa 235,719 El Salvador North Americ 22,761 39 Equatorial Guinea Africa 19,805 40 Estonia Europe 22.225 41 Ethiopia Africa 31,256 42 Finland Europe 266,553 France Europe 2,776,324 44 Gabon Africa 16,176 45 Georgia Europe 14,347 46 Germany Europe 3,577,031 47 Ghana 37,158 48 Greece Europe 303,065 49 Guatemala North Americ 46,897 50 Honduras North Americ 17,381 51 Hong Kong Asia 243,302 52 Hungary Europe 140,303 53 Iceland Europe 14,048 54 India Asia 1,676,143 55 Indonesia Asia 845,680 56 Iran Asia 482,445 57 Iraq Asia 115,388 58 Ireland Europe 217,669 59 Israel Asia 242,897 Italy Europe 2,198,730 61 Jamaica North Americ 14,807 62 Japan Asia 5,869,471 Jordan Africa 29,233 Kazakhstan Asia 178,312 Africa 64 Kazakhstan 65 Kenya Kuwait 67 Latvia Lebanon 69 Libya 70 Lithuania 71 Luxembourg 72 Malaysia 73 Mali 74 Mauritius 75 Mexico 76 Morocco 77 Mozambique 78 Namibia 79 Nepal 80 Netherlands 81 New Zealand $2 Nigeria Norway 84 Oman 85 Pakistan 86 Panama 87 Papua New Guinea Paraguay 89 Peru 90 Philippines 91 Poland 92 Portugal 93 Qatar 94 Romania 45 Russia 96 Saudi Arabia 97 Senegal 98 Serbia 99 Singapore 100 Slovakia 101 Slovenia 102 South Africa 103 South Korea 104 Spain 105 Sri Lanka 106 Sudan South Sudan 107 Sweden 108 Switzerland 109 Taiwan 110 Tanzania 111 Thailand 112 Trinidad and Tobago 113 Tunisia 114 Turkey 115 Turkmenistan 116 Uganda 117 Ukraine 118 United Arab Emirates 119 United Kingdom 120 United States 121 Uruguay 122 Uzbekistan 123 Venezuela 124 Vietnam 125 Yemen 126 Zambia 127 Asia Africa Asia Europe Asia Africa Europe Europe Asia Africa Africa North Americ Africa Africa Africa Asia Europe Oceania Afrioa Europe Asia Asia North Americ Oceania South Americ South Americ Asia Europe Europe Asia Europe Asia Asia Africa Europe Asia Europe Europe Africa Asia Europe Asia Africa Europe Europe Asia Africa Asia North Americ Asia Asia Asia Africa Europe Asia Europe North Americ South Americ Asia South Americ Asia Africa Africa 178,312 34,796 176,667 28,252 39,039 36,874 42,718 58,412 278,680 10,600 11,313 1.154,784 99,241 12,827 12,461 18,580 840,433 161,851 238,920 483,650 71,888 210,566 30,569 12,655 21,236 173,502 213,129 513,821 238,880 173,847 189,776 1,850,401 577.595 14,461 45,064 259,849 96,089 49,588 408,074 1,116,247 1,493,513 59,095 64,750 538,237 636,059 466,832 23,333 345,649 22,707 46,360 778,089 25,742 16,810 164,960 360,136 2,417,570 15,094,025 46,872 45,353 315,841 122,722 33,675 19,206

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting For Managers

Authors: Eric Noreen, Peter Brewer, Ray Garrison

6th Edition

1264100590, 9781264100590

More Books

Students also viewed these Accounting questions

Question

5. It is the needs of the individual that are important.

Answered: 1 week ago