Create a third column in your spreadsheet labeled, “Actual Temperature.” Creat a formula that’s will fill the third column with actually temperature data for each month. Double check your formula and data analysis by completing the modified table in the answer space.

Hello! I recently was asking the same question and had to get the formula from the teacher, who admitted that it was a confusing question because we didnt have anything to work off of. Its actually not that complicated!

You take the Anomaly value, add 13.9, and it equals the actual temp!

Anomaly value + 13.9 =actual temp

EXAMPLE: 0.03 + 13.9 = 13.93

Hope this helps!

Explanation:

See attached...