Hi everybody,

I need to filter my data from a data base and the criteria for the
removal of such data points includes: (1) if the recorded values are
not within the temperature range 5 °C to 35 °C); (2) if consecutive
temperature data points deviate by 2°C.

The data looks like this:


Time Temperature (°C)

3:40:48 PM 25.5
3:40:49 PM 25.7
3:40:50 PM -42.8
3:40:51 PM 25.6
3:40:52 PM 25.7
3:40:54 PM 25.7
3:40:55 PM 30.8
3:40:56 PM 25.7
3:40:57 PM 25.5
3:40:58 PM 25.8
3:41:01 PM 28.5
3:41:02 PM 25.7
3:41:03 PM 25.7
3:42:01 PM 25.7
3:42:03 PM 25.7
3:42:05 PM 25.6
3:43:23 PM 25.7


The time intervals are not constant and every minute has a different
set of seconds (some times the 60 sec and some times just 3 seconds of
that particular minute).

Is there any formula to sort this?

Thank you very much!




--
Sharkies