Climate change research is supported by both the physical theories underlying the climate and a mountain of data -- all tied together using a large number of simulations and models. The data (CO2, temp, etc...) comes in two forms: direct measurements made by scientists over the last couple of hundred years; and indirect measurements inferred from ice-cores, tree rings, isotope ratios, etc...
There are some really amazing climate data visualisations available, e.g.,
Asides:
For the tasks below you have been provided with primary and secondary data in Comma Separated Value (CSV) files -- at the bottom of the page. You have also been given the spreadsheet and Plotly visualisations; however, please do not rely on these too much, as you need to be able to perform and design the visualisations for yourselves.
Image from Wikipedia: Keeling Curve
We are going to reproduce the famous Keeling Curve shown in the image. This is an introductory task to practice your spreadsheet and data visualisation skills.
=Average(B2:B13)
to calculate the cell C7 and drag the formula down (copy-paste is easier than dragging...)C:C
as a new data series. In this exercise we'll use the Scripps Merged CO2 data, along with the combined temperature data from the Jones & Mann 2004 paper. Import/copy the two CSV files from the folder below into a spreadsheet and make separate scatter plots. Calculate their moving averages and add to the scatter plots.
You can make a two-axis charts in Excel and Google Sheets, but the two sets of dependent variable (y-axes) data needs to occur at the same dependent variable (x-axis) values. This is not the case with our data, as the CO2 data gives a point only every couple of decades, while the temperature data is every year. You can fix it by using a VLOOKUP or some interpolation.... or you can use something like Plotly which is happy to have to separate scatter plots on the same chart.
Use the skills from Task 1 to produce a visualisation like that below. Think about your design choices: Colour & Opacity, Axes, Grids, Titles, Legends, Data Range, Moving Average / Smoothings, Annotations.
Explore how the graph changes when you adjust the y-axes ranges -- it moves the separate scatter plots up and down with respect to each other and can make it look like CO2 increase precedes or follows the temperature increase.