Question: data a lets use the 19511980 average global temperature of...
a) Let’s use the 1951-1980 average global temperature of 14°C as a base temperature. Create a new column of data that shows each year’s temperature anomaly using this base temperature. Anomalies are calculated by taking the value – average.
b) Create a line graph or a bar graph of the original temperature data but only use the data from 1970-2016. Your y-axis should be display the temperatures and your x-axis should display the year. Add a linear trendline to this graph (right click on the data on the graph and select trendline). Be sure to display the equation of this trendline on the graph (this can be done by clicking on the “Format Trendline” option).