View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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