Smoothing of Data

[munleyj]

I have 35 years of temperature data. I have the average of each day in a column. However, my data is noisy. How can I smooth the data? Do I need a filter and how would I do this?b I would like to send you the file but I can not attach files. PLEASE HELP!

 

[wmc]

From post 12, I gathered that the goal is to smooth the data in such a way as to create the impression that temperatures are consistently rising.

 

[munleyj]

right! Since the file is February and heading towards march it should rise gradually.

 

[GaryOfah]

Try formula on lets say 10, 20, 30 cell range:

AVERAGE, SMALL, ROUND and derivatives...
Then you can do it few times in few rows or columns. That way you have a filter.

But also I don't see what exactly you will use it for?
It can help us if we know why are you doing it...

Look here!
You got a temperature range in cells G6:M6
in M7 =AVERAGE(G6:M6) ...result 4,2857
in M8 =ROUNDDOWN(M7,0) ...result 4
Now you have round down.
So, next cell you are copying same formula to right and it will be... AVERAGE(G7:M7)...

Then you can in another row apply another average...to be sure...
So probably it will be solid to smooth it that way.

So you can play with such combinations to do it, as you like.
But anyway try to explain us why are you doing it and will the data derived that way, not be wrong?

 

[munleyj]

I am using it for a a reference of normals for may area.

 

[GaryOfah]

As others already said, I also can't produce in my mind what would be the best scenario and how not to distort data. I suppose you don't want to distort data to be useless.
So play with #23 or something else to suit your needs.