Question

Predict what the temperature anomaly would be at a CO2 level of 450 ppm

CO2 (ppm)	Temp Anomaly (deg. C)
335.40	0.2
336.84	0.34
338.75	0.43
340.11	0.14
341.45	0.39
343.05	0.21
344.65	0.2
346.12	0.25
347.42	0.41
349.19	0.52
351.57	0.38
353.12	0.53
354.39	0.53
355.61	0.24
356.45	0.28
357.10	0.39
358.83	0.57
360.82	0.49
362.61	0.55
363.73	0.85
366.70	0.6
368.38	0.58
369.55	0.68
371.14	0.8
373.28	0.78
375.80	0.69
377.52	0.88
379.80	0.78
381.90	0.86
383.79	0.65
385.60	0.79
387.43	0.92
389.90	0.79
391.65	0.77
393.85	0.81
396.52	0.88
398.65	0.96
400.83	1.23

Answer 1

Using excel to run the regression analysis:

Input the values as shown below:

The output is

The regression line is:

Y = -3.80890230414214 + 0.0120298273917277 * X

When X = 450

Y = 1.60452002213531

Let me know in comments if anything is not clear. Will reply ASAP. Please do upvote if satisfied.