stdev inside a series of data

[willnatalie]

I have 53,000 temperature data points read once per minute in one column.

What I would like to attempt is finding an hours worth of data points that contains the lowest standard deviation around a certain temperature.

I could make new columns using a formula as such

cell 1=IF(COUNTIF(AB2:AB62,">215")+COUNTIF(AB2:AB62,"<210")>0,"",STDEV(AB2:AB62))

the next row in that column being

cell 2=IF(COUNTIF(AB3:AB63,">215")+COUNTIF(AB3:AB63,"<210")>0,"",STDEV(AB3:AB63))

Then weeding out the lowest value in that column to find the set of 60 data points I need.
I am just curious to see if there is a way of attempting in one cell without adding many more columns because I need this bases on other temperatures as well.

If there is confusion on what I am asking let me know

thanks

Will

 

[barry houdini]

I think it's easier to find the minimum STDEV, for the actual data points associated with that I think your suggested method might be better.....but if you use B2:B62 that's actually 61 data points, shouldn't it be B2:B61?

 

[willnatalie]

yea.. your right I was thinking 0-60 which is 61 points.