In: Statistics and Probability
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 |
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.