Question

To begin this assignment, please download the Excel Data file from Canvas "Data for Homework 5.1". The worksheet contains data for 2019 on countries with 2019 population greater than 10 million. Three variables are reported for each country: (1) Gross Domestic Product for 2019 (in billions of $US converted to $US on a purchasing power parity basis); population in 2019 (in millions); CO2 emissions from fuel consumption in 2019 (in millions of tons). The first step is to calculate 2019 GDP in $1,000 per capita. Put this in column F. Next put CO2 2019 emissions per capita in column G. The next step is to create a scatter plot of GDP per capita and emissions per capita, with GDP per capita on the horizontal axis. Do this exactly as you did in HW1.2. Just like before, add a linear trendline, and select the option to make the equation for the trendline visible. Now answer the questions below. Question: For 2019, CO2 emissions per capita in the U.S. equal (in tons): From the fitted trendline, we can see that on average, a country with an additional $1,000 of GDP per person tends to have an increase in carbon emissions per person equal to tons .6 1.1 .1 .2 Figure out the points in the graph that corresponding to the U.S., Canada, France and Germany. Compare the positions of these points with the trendline. Which statement is true about per capita CO2 emissions for these four countries? All four countries are above the trendline. The points for the US, Germany, and Canada are above the trendline, while France is below. The US is above the trendline, while Canada, Germany, and France are below the trendline. US and Canada are above the trend line, France and Germany are below the trend line

Answer 1

To calculate GDP per capita in $1,000, divide the GDP of each country by its population and multiply the result by 1,000. Divide CO2 emissions of each country by its population to find CO2 emissions per capita. Create a scatter plot of GDP per capita and emissions per capita, add a trendline, and compare the positions of data points for specific countries with the trendline to determine their per capita CO2 emissions.

Step-by-step explanation:

To calculate 2019 GDP per capita in $1,000, you need to divide the GDP of each country by its population and multiply the result by 1,000. This will give you the GDP per capita in thousands of dollars. You can do this by entering the formula =B2*1000/C2 in cell F2 and dragging it down to fill the rest of the column.

To calculate CO2 emissions per capita, you can divide the CO2 emissions of each country by its population. Enter the formula =D2/C2 in cell G2 and drag it down to fill the rest of the column.

To create a scatter plot of GDP per capita and emissions per capita, select the data in columns F and G, go to the Insert tab, and choose Scatter. Add a trendline to the scatter plot by right-clicking on a data point, selecting Add Trendline, and choosing a linear trendline. Make sure to check the option to display the equation.

To find the CO2 emissions per capita for the U.S., look for the data point on the scatter plot that corresponds to the U.S. and read the value on the y-axis.

To find the data points for Canada, France, and Germany, look for their respective data points on the scatter plot and compare their positions with the trendline. Based on their positions, determine which statement about their per capita CO2 emissions is true.