Explor data using moving average

[marwan1023]

I want  analyze local and global temperature data and compare the temperature trends for city Riyadh  to overall global temperature trends. using  Moving averages Temperatures Over Time (5 , 10-Year Moving Average)

1-Create a line chart that compares your city’s temperatures with the global temperatures. Make sure to plot the moving average rather than the yearly averages in order to smooth out the lines, making trends more observable

2-Make observations about the similarities and differences between the world averages and your city’s averages, as well as overall trends.

i will attached analyze by excl example the result

and attached 

Thanks 

[AbhilashR · Accepted solution]

@marwan1023 - attached proof of concept should help you get started in what you are looking to achieve. In my example I have charted Riyad vs. Global temp for 5 and 10 Year moving avg.

Hope this helps.