According to the estimated coefficients, what is

the proportion of countries which had a decline in emissions in 2016? (Report

to 1 decimal place and include appropriate units)

According to the estimated coefficients, what is

the proportion of countries which had a decline in emissions in 1990? (Report

to 1 decimal place and include appropriate units)

Compare the slope in both linear trend models.

What happened to the slope in the second linear trend model?

Now create a time trend variable in Column C. Estimate a new linear trend model with CO₂ as the dependent variable (Y) and the time trend you created as the independent variable (X).

What is the interpretation of the intercept?

Estimate a linear trend model with CO₂ as the dependent variable (Y) and Year as the independent variable (X).

What is the interpretation of the intercept?

Create a line graph of the CO₂ emissions, what does it tell you?

Instructions:

(1) Highlight the data in Column B for the co2 variable

(2) In the Insert tab, find the Insert Line or Area Chart icon and click the first template to create a line graph.

(3) Add in the years as axis labels: right-click the x-axis, click Select Data..., click the Edit button under the Horizontal (Category) Axis Labels, then highlight Column A (starting from cell A2) for the Axis label range and click OK.