ExcelBanter - trend damping

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - trend damping (https://www.excelbanter.com/excel-discussion-misc-queries/257639-trend-damping.html)

HD[_3_]

trend damping

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!!

EricG

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!!

All times are GMT +1. The time now is 08:15 AM.