How can I detect abrupt changes in my data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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","")
 
Back
Top