How can I detect abrupt changes in my data
 

Hi al

I'm trying to figure out how I could find abrupt changes in my measurement data
these changes could be sudden increase on decrease but the normal measurement would b
a slow increase

has anybody an idea how to solve this

regard

Pascal

How can I detect abrupt changes in my data
 

Hi Pascal
you haven't provided much information. But as a starter:
Assumptions: column A stores your measurment data
- enter the following in B2
=IF(ABS(A2-AVERAGE($A$1:$A1))epsilon,"massive change","")
and copy down (replace epsilon with a value of your choice)

or you may use
=IF(ABS(A2-A1)epsilon,"massive change","")


--
Regards
Frank Kabel
Frankfurt, Germany

Pascal wrote:
Hi all

I'm trying to figure out how I could find abrupt changes in my
measurement data
these changes could be sudden increase on decrease but the normal
measurement would be a slow increase.

has anybody an idea how to solve this ?

regards

Pascal