Final answer:
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.