LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
High and Low values in column Lee Coleman New Users to Excel 2 January 27th 07 11:31 AM
ID High Values Premio1 Excel Discussion (Misc queries) 1 November 15th 06 04:36 PM
Y Axis in a chart - high to low values Chuck Excel Discussion (Misc queries) 0 August 17th 06 06:05 PM
etsimate values of a linear trend for each pair of known values Maarten Excel Discussion (Misc queries) 2 January 15th 06 09:04 PM
How can I calculate trend growth rates in Excel? david34 Excel Discussion (Misc queries) 4 July 16th 05 05:44 PM


All times are GMT +1. The time now is 12:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"