Question
Problem 5. Please refer CO2 emissions (metric tons per capita) in 2011 data in HW#1_Data (MS Excel). Suppose that the smallest possible change of emissions
Problem 5. Please refer "CO2 emissions (metric tons per capita) in 2011" data in "HW#1_Data" (MS Excel). Suppose that the smallest possible change of emissions is 0.01 metric tons. In addition, we assume that the class width is five and the lower class limit of the first class is zero. (a) Generate a frequency table and a histogram using MS Excel. (b) What is the lower class boundary for the third class? (c) What is the upper class boundary for the fourth class? (d) Is the distribution shape symmetric, uniform, skewed to the left, or skewed to the right?
Problem 6. Please refer "CO2 emissions (metric tons per capita) in 2011" data in "HW#1_Data" (MS Excel). (a) Find the mean and median. (b) Suppose the data includes all countries in the world. Find the range, variance, and standard deviation.
Problem 7. Please refer two data sets in "HW#1_Data" (MS Excel): "CO2 emissions (metric tons per capita) in 2011" and "GDP per Capita (in USD) in 2011". (a) Draw a scatterplot. (b) Find the correlation coefficient between CO2 emissions per capita and GDP per capita.
CO2 emissions (metric tons per capita) and GDP per Capita (in USD) in 2011 (source: World Bank Database) | ||||
Country | CO2 emissions per Capita | GDP per Capita | ||
Afghanistan | 0.43 | 622.38 | ||
Albania | 1.61 | 4437.81 | ||
Algeria | 3.32 | 5447.40 | ||
Andorra | 5.97 | 41630.05 | ||
Angola | 1.35 | 5053.74 | ||
Antigua and Barbuda | 5.82 | 12817.84 | ||
Argentina | 4.56 | 13392.92 | ||
Armenia | 1.67 | 3417.17 | ||
Aruba | 23.92 | 25353.79 | ||
Australia | 16.52 | 62216.55 | ||
Austria | 7.77 | 51123.56 | ||
Azerbaijan | 3.65 | 7189.69 | ||
Bahamas, The | 5.20 | 21514.90 | ||
Bahrain | 17.95 | 22238.71 | ||
Bangladesh | 0.37 | 838.55 | ||
Barbados | 5.58 | 15530.89 | ||
Belarus | 6.68 | 6305.77 | ||
Belgium | 8.85 | 47699.81 | ||
Belize | 1.67 | 4517.12 | ||
Benin | 0.51 | 799.04 | ||
Bermuda | 6.08 | 85973.16 | ||
Bhutan | 0.77 | 2485.79 | ||
Bolivia | 1.60 | 2377.70 | ||
Bosnia and Herzegovina | 6.20 | 4779.66 | ||
Botswana | 2.32 | 7504.85 | ||
Brazil | 2.19 | 13042.42 | ||
Brunei Darussalam | 24.39 | 41787.02 | ||
Bulgaria | 6.71 | 7750.04 | ||
Burkina Faso | 0.12 | 665.81 | ||
Burundi | 0.02 | 240.61 | ||
Cambodia | 0.31 | 879.15 | ||
Cameroon | 0.27 | 1258.92 | ||
Canada | 14.14 | 52086.53 | ||
Cabo Verde | 0.86 | 3766.11 | ||
Central African Republic | 0.06 | 484.58 | ||
Chad | 0.04 | 988.44 | ||
Chile | 4.62 | 14582.17 | ||
China | 6.71 | 5574.19 | ||
Colombia | 1.56 | 7227.77 | ||
Comoros | 0.22 | 790.57 | ||
Congo, Dem. Rep. | 0.05 | 350.27 | ||
Congo, Rep. | 0.54 | 3453.22 | ||
Costa Rica | 1.70 | 8963.68 | ||
Cote d'Ivoire | 0.31 | 1231.87 | ||
Croatia | 4.80 | 14542.18 | ||
Cuba | 3.17 | 6092.61 | ||
Cyprus | 6.74 | 31836.62 | ||
Czech Republic | 10.43 | 21656.94 | ||
Denmark | 7.25 | 61304.06 | ||
Djibouti | 0.56 | 1472.01 | ||
Dominica | 1.75 | 7023.35 | ||
Dominican Republic | 2.18 | 5820.40 | ||
Ecuador | 2.35 | 5223.38 | ||
Egypt, Arab Rep. | 2.64 | 2816.67 | ||
El Salvador | 1.10 | 3821.34 | ||
Equatorial Guinea | 8.91 | 22944.93 | ||
Eritrea | 0.11 | 544.46 | ||
Estonia | 14.05 | 17453.75 | ||
Ethiopia | 0.08 | 355.59 | ||
Faeroe Islands | 11.72 | 50910.43 | ||
Fiji | 1.42 | 4351.92 | ||
Finland | 10.16 | 50787.56 | ||
France | 5.19 | 43807.48 | ||
Gabon | 1.42 | 11530.15 | ||
Gambia, The | 0.24 | 516.98 | ||
Georgia | 1.77 | 3219.61 | ||
Germany | 8.92 | 45936.08 | ||
Ghana | 0.40 | 1587.19 | ||
Greece | 7.56 | 25872.01 | ||
Grenada | 2.41 | 7410.76 | ||
Guatemala | 0.75 | 3166.58 | ||
Guinea | 0.23 | 447.79 | ||
Guinea-Bissau | 0.15 | 659.48 | ||
Guyana | 2.36 | 3408.73 | ||
Haiti | 0.22 | 740.95 | ||
Honduras | 1.10 | 2323.76 | ||
Hong Kong SAR, China | 5.70 | 35142.49 | ||
Hungary | 4.86 | 14032.77 | ||
Iceland | 5.90 | 45970.89 | ||
India | 1.66 | 1471.66 | ||
Indonesia | 2.30 | 3647.63 | ||
Iran, Islamic Rep. | 7.80 | 7874.48 | ||
Iraq | 4.20 | 5839.31 | ||
Ireland | 7.88 | 52828.42 | ||
Israel | 8.95 | 33707.32 | ||
Italy | 6.70 | 38364.94 | ||
Jamaica | 2.87 | 5332.47 | ||
Japan | 9.29 | 46203.71 | ||
Jordan | 3.60 | 4665.95 | ||
Kazakhstan | 15.81 | 11357.95 | ||
Kenya | 0.33 | 1012.88 | ||
Kiribati | 0.60 | 1645.81 | ||
Korea, Rep. | 11.84 | 24155.83 | ||
Kuwait | 28.10 | 47551.38 | ||
Kyrgyz Republic | 1.20 | 1123.88 | ||
Lao PDR | 0.19 | 1300.98 | ||
Latvia | 3.79 | 13781.21 | ||
Lebanon | 4.67 | 9132.43 | ||
Lesotho | 1.08 | 1241.21 | ||
Liberia | 0.22 | 378.81 | ||
Libya | 6.20 | 5517.78 | ||
Liechtenstein | 1.41 | 157092.97 | ||
Lithuania | 4.54 | 14367.21 | ||
Luxembourg | 20.90 | 113239.56 | ||
Macao SAR, China | 2.13 | 67012.96 | ||
Macedonia, FYR | 4.52 | 5079.96 | ||
Madagascar | 0.11 | 456.33 | ||
Malawi | 0.08 | 369.60 | ||
Malaysia | 7.90 | 10427.76 | ||
Maldives | 2.93 | 6497.55 | ||
Mali | 0.08 | 680.83 | ||
Malta | 6.03 | 22347.71 | ||
Marshall Islands | 1.95 | 3290.03 | ||
Mauritania | 0.63 | 1390.93 | ||
Mauritius | 3.13 | 8984.63 | ||
Mexico | 3.88 | 9715.11 | ||
Micronesia, Fed. Sts. | 1.24 | 2998.64 | ||
Moldova | 1.40 | 1970.57 | ||
Mongolia | 6.92 | 3772.93 | ||
Montenegro | 4.15 | 7318.74 | ||
Morocco | 1.74 | 3066.50 | ||
Mozambique | 0.13 | 524.89 | ||
Namibia | 1.24 | 5539.62 | ||
Nepal | 0.16 | 695.88 | ||
Netherlands | 10.06 | 53537.28 | ||
New Zealand | 7.12 | 37896.85 | ||
Nicaragua | 0.84 | 1679.75 | ||
Niger | 0.08 | 378.20 | ||
Nigeria | 0.54 | 2514.15 | ||
Norway | 9.19 | 100575.12 | ||
Oman | 20.20 | 21164.34 | ||
Pakistan | 0.94 | 1230.82 | ||
Palau | 10.86 | 9765.31 | ||
Panama | 2.63 | 9036.04 | ||
Papua New Guinea | 0.75 | 1838.70 | ||
Paraguay | 0.84 | 3983.50 | ||
Peru | 1.78 | 5731.35 | ||
Philippines | 0.87 | 2371.85 | ||
Poland | 8.34 | 13891.14 | ||
Portugal | 4.71 | 23194.74 | ||
Qatar | 44.02 | 89115.90 | ||
Romania | 4.21 | 9200.28 | ||
Russian Federation | 12.65 | 13323.88 | ||
Rwanda | 0.06 | 606.90 | ||
Samoa | 1.25 | 4063.56 | ||
Sao Tome and Principe | 0.59 | 1374.13 | ||
Saudi Arabia | 18.07 | 23256.10 | ||
Senegal | 0.59 | 1081.13 | ||
Serbia | 6.80 | 6423.29 | ||
Seychelles | 6.84 | 12189.01 | ||
Sierra Leone | 0.15 | 490.88 | ||
Singapore | 4.32 | 53121.23 | ||
Slovak Republic | 6.37 | 18138.73 | ||
Slovenia | 7.50 | 24983.69 | ||
Solomon Islands | 0.37 | 1648.85 | ||
South Africa | 9.26 | 8080.87 | ||
Spain | 5.79 | 31832.24 | ||
Sri Lanka | 0.73 | 3128.69 | ||
St. Kitts and Nevis | 5.05 | 13737.32 | ||
St. Lucia | 2.27 | 7195.67 | ||
St. Vincent and the Grenadines | 2.18 | 6183.68 | ||
Sudan | 0.35 | 1596.45 | ||
Suriname | 3.65 | 8448.50 | ||
Swaziland | 0.86 | 4093.38 | ||
Sweden | 5.52 | 59593.68 | ||
Switzerland | 4.63 | 88002.61 | ||
Tajikistan | 0.36 | 841.22 | ||
Tanzania | 0.15 | 740.38 | ||
Thailand | 4.53 | 5539.49 | ||
Timor-Leste | 0.16 | 1015.72 | ||
Togo | 0.32 | 572.03 | ||
Tonga | 0.98 | 4226.69 | ||
Trinidad and Tobago | 37.14 | 18287.40 | ||
Tunisia | 2.40 | 4298.09 | ||
Turkey | 4.38 | 10584.16 | ||
Turkmenistan | 12.18 | 5724.54 | ||
Uganda | 0.11 | 591.44 | ||
Ukraine | 6.26 | 3569.76 | ||
United Arab Emirates | 20.43 | 39901.22 | ||
United Kingdom | 7.09 | 41020.38 | ||
United States | 17.02 | 49781.36 | ||
Uruguay | 2.30 | 14166.56 | ||
Uzbekistan | 3.91 | 1544.83 | ||
Vanuatu | 0.59 | 3275.02 | ||
Venezuela, RB | 6.42 | 10754.59 | ||
Vietnam | 1.97 | 1543.03 | ||
West Bank and Gaza | 0.57 | 2664.95 | ||
Yemen, Rep. | 0.92 | 1282.40 | ||
Zambia | 0.21 | 1654.53 | ||
Zimbabwe | 0.69 | 768.56 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started