Hi All,
I use a trend line best fit in Xcelcius and I want to know if the trend is going up or down or neutral.
Is there an Xcelcius command that gives the slope of the trend line?
If not any easy way to calculate the slope?
Thanks
Jamie Lill
jamie-lill@live.ca (BOB member since 2010-08-05)
Sorry but i am confused. Elaborate more?
NycPriya (BOB member since 2010-11-04)
I doubt that the slope is simply available for reference. I think your best bet would be to look up a formula used to calculate best fit and a formula to calculate the slope. You can then put those formulae in your Excel data model to reference them.
Lugh (BOB member since 2009-07-16)
I just map the trend data into a range and then see whether the start point is greater than the end point, or not.
Debbie
Debbie 
(BOB member since 2005-03-01)