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
|