- #1
joelupchurch
- 149
- 0
I loaded the monthly temperature anomalies from HADCRU, GISS and UAH into a single Excel spreadsheet to make it easier to compare them. The result look like the attached image below:
I thought the spreadsheet might be handy for other people, so I've attached it as a zipped Excel file. It also includes the CO2 data from Mauna Loa. I've included links to where I got the data from. What you see in the image is a 12 month moving average and a linear trend for each data set. All three datasets start in December 1978, since that is when the UAH dataset starts.
It is interesting to see how much you can manipulate the linear trend by changing the start date for the graph. In Excel, right click on the graph and click on Select Data. In the Select Data Source dialog go to th Chart Data Range where it says ='Combine'!$A$1:$D$374. Change $1 to whatever row you want to start with.
I thought the spreadsheet might be handy for other people, so I've attached it as a zipped Excel file. It also includes the CO2 data from Mauna Loa. I've included links to where I got the data from. What you see in the image is a 12 month moving average and a linear trend for each data set. All three datasets start in December 1978, since that is when the UAH dataset starts.
It is interesting to see how much you can manipulate the linear trend by changing the start date for the graph. In Excel, right click on the graph and click on Select Data. In the Select Data Source dialog go to th Chart Data Range where it says ='Combine'!$A$1:$D$374. Change $1 to whatever row you want to start with.