View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] HammerJoe@gmail.com is offline
external usenet poster
 
Posts: 126
Default Need formula to calculate trend for the high values in data.

Hi,

I am tracking on a daily basis some data.

Ie:

2007/07/10 10.1
2007/07/11 10.8
2007/07/12 12.2
2007/07/13 11.9
2007/07/14 10.5
2007/07/15 12.1
2007/07/16 10.2
2007/07/17 11.5
2007/07/18 12.00
2007/07/19 11.9

If we look at this data we can clearly see that the highest numbers
are decreasing over time (12.2,12.1,12,11.9) so drawing a line in a
graph for this trend would show that it is decreasing (safe to guess
the next highest number would 11.8 at some point in the future).

I need a formula to calculate this.
Trend() does not work the way I want it.
Is there another function that does this or anyone has any idea for a
formula?

Thanks