trends

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

usenet - 08 Jan 2006 18:59 GMT

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

Reply to this Message

Gary''s Student - 08 Jan 2006 20:20 GMT

Consider:

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

Signature

Gary's Student

> how in excel can i tell that
>
[quoted text clipped - 15 lines]
> all the functions like trend etc and stdev show loss and gain as no
> difference

Reply to this Message

usenet - 09 Jan 2006 17:05 GMT

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

> Consider:
>
[quoted text clipped - 21 lines]
>> all the functions like trend etc and stdev show loss and gain as no
>> difference

Reply to this Message

Pete_UK - 09 Jan 2006 19:18 GMT

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

Reply to this Message