trends

U

usenet

how in excel can i tell that

1
2
3
is growth
3
2
1
is loss
and
3
0
3
is no change

I want to just display the trend with a up , down or no change arrow
all the functions like trend etc and stdev show loss and gain as no
difference
 
G

Gary''s Student

Consider:

=IF(endpoint-startpoint>0) then gain
=IF(endpoint-startpoint<0) then lose
=IF(endpoint-startpoint=0) then no change
 
U

usenet

Thanks Gary how ever that wont work in this kind of instance where the trend
is higher

10
20
10
30
9
40
9

and also this one where the trend is clearly lower

50
40
50
30
51
20
51
lastly this one where the trend is even


20
19
21

Any other ideas

Thanks
 
P

Pete_UK

Are these meant to be equally-spaced values (eg at some time interval)
? In other words, does the row number imply an x-value to these
y-values? If so, then you could do a least-squares fit to the data and
derive the best "slope" of the values to indicate whether it is
increasing, decreasing or level.

It's been a few years since I last did this, so I can't help you with
the formulae straightaway, but I hope this helps.

Pete
 
Top