Question: Create a new scatter plot in Excel with Global CO2 Emissions (billion tons) as the independent variable and Global Average Temperature (C) as the dependent

Create a new scatter plot in Excel with Global CO2 Emissions (billion tons) as the independent variable and Global Average Temperature (C) as the dependent variable. 2. Add a linear trendline to your scatter plot and display the equation on the chart. 3. Identify and interpret the slope (m) of your line. What does this value represent in the context of climate change? y=3.9101x-188.82 The slope of the line is 3.910, 4. Identify and interpret the y-intercept (b). What does this value represent in your model? The y-intercept is -188.82, 5. If global CO2 emissions reach 40 billion tons, what would be the predicted global average temperature? Show work in a nearby cell. 6. If we want to limit global average temperature increase to 1.5C above pre-industrial levels, what would be the maximum allowable CO2 emissions according to your model? Show work in a nearby cell. y=3.9101x-188.82

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock