Hi, does excel have an inbuilt function to evaluate a simple trend? In a worksheet each column represents a month, a=Jan, b=Feb, c=Mar, each row contains sales for the month. I'm hoping for a formula that I could enter in column d, the range being (A1:C1) and returns 0 for static trend, 1 for increase in trend, -1 for decrease in trend, or something similar. Does excel have a function that would do this. Thanks for any help.
Last edited by darren101; 04-03-2009 at 03:32 PM.
Try =RANK(B9;$B$9:$E$9;1)
Hi, thanks for this suggestion. RANK appears to rank the number within the range, I’m looking for someway of evaluating the range to determine an upward or downward trend..
Oh, sorry, misunderstood... You have trend function...
=TREND(A2:D2;A1:D1;E1;0)
PINK -Y's
Blue X's
Brown - New X
Yeah, i tried that one but found you could only use it to test one row against another, i’m trying to evaluate one row at a time, (A1:C1) whats the trend of those numbers, thanks for the help, appreciate your time....
What time? I write something every half hour and didn't help you at all
So no need to thankS
maybe I'm not understand well, but as you change E1 to F1;G1... you will get new data for all numbers...
Assuming you have Excel dates (or some numeric values) in A1:C1, and the values to test in A2:C2, then this returns -1, 0, or 1:
=SIGN(SLOPE(A2:C2, A1:C1))
Entia non sunt multiplicanda sine necessitate
Hi, the only numbers i want to evaluate are (A1:C1), do the numbers in row1 have an upward or downward trend... sorry i’m probably not explaining this very well..
I tried ‘TREND(A2:G2,,A2:G2,TRUE)’ which seemed to return a positive number if the trend was upward and a negative number if the trend was downward but this might have been luck with my test data as i’m not sure how this function works....
=sign(slope(a1:c1, {1,2,3}))
Fantastic, does exactly what i need, thanks (i wont pretend to know how)
You could look at Help ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks