Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
High and Low values in column | New Users to Excel | |||
ID High Values | Excel Discussion (Misc queries) | |||
Y Axis in a chart - high to low values | Excel Discussion (Misc queries) | |||
etsimate values of a linear trend for each pair of known values | Excel Discussion (Misc queries) | |||
How can I calculate trend growth rates in Excel? | Excel Discussion (Misc queries) |