Thread: trend damping
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
EricG EricG is offline
external usenet poster
 
Posts: 220
Default trend damping

How dense are your data points? Every month, weekly, daily? You might want
to try a moving average with a period appropriate for your data set.

HTH,

Eric

"HD" wrote:

I am trying to do a trend over 24 months but with placing more emphasis on
the most recent 6 months of data points. Help!!