In the video of the lecture a graph is presented on the relative changes of population, economic output per person, energy intensity of economic output and co2 intensity of energy consumption.

The data can be downloaded from:

Population numbers USA from the Worldbank

https://data.worldbank.org/indicator/SP.POP.TOTL?locations=USLinks to an external site.

CO2 emissions (kt)

https://data.worldbank.org/indicator/EN.ATM.CO2E.KT?locations=USLinks to an external site.

Gross Domestic Product (US$)

https://data.worldbank.org/indicator/NY.GDP.MKTP.CDLinks to an external site.

Primary energy consumption estimates by source (select Total primary energy consumption)

https://www.eia.gov/totalenergy/data/annual/Links to an external site.

Find first time series from 1990-2020 for population, co2 emissions, GDP and primary energy consumption.

Then calculate the the time series of the four components of the IPAT equation as presented in the presentation.

Now divide the values of those time series by the value of each component in 1990, so you get the relative values of the components (1 for 1990).

Build a graph in Excel.