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
Get step-by-step solutions from verified subject matter experts
