Need find a tren

Closed
Report
-
 Trowa -
Hello,
Hey i am new to excel. i ma not expert in maths derivations - regression like...
i need to find a trend.
I have a list of materials and rate for the material in month wise.
i need what trend the rate is. ie. increasing or decreasing or some fluctuations.

Ex:
Material April May June July Trend
A 20 30 69 80 ? (INCREASING , DECREASING , OR .. )
B 80 30 30 20 ?
C 70 80 68 90 ?

ANY ONE CAN HELP ME ....

3 replies

Hi Mukil,

Let's say the data 20,30,69,80 is in range B2:E2 then put the following formula in F2:
=TREND(B2:E2,{1,2,3,4},5)

Best regards,
Trowa
0
Hi Trowa,

Thanks . just i need its an increasing trend or decreasing trend or some fluctuations..

Ex:

if values are 10 20 25 30 then it should say increasing
30 20 15 10 then it should say decreasing
10 8 25 15 then it should say some fluct
0
Hi Mukil,

I have put the numbers in range A1:D3:
10	20	25	30
30	20	15	10
10	8	25	15


In column F I have put the trend formula:
=TREND(A1:D1,{1,2,3,4},5)
=TREND(A2:D2,{1,2,3,4},5)
=TREND(A3:D3,{1,2,3,4},5)


This results in:
37,5
2,5
22,5


In column G I have put an array formula (Array formula's need to be confirmed by hitting Ctrl+Shift+Enter):
=SUM(IF(A1:D1<F1,1,0))
=SUM(IF(A2:D2<F2,1,0))
=SUM(IF(A3:D3<F3,1,0))


This results in:
4
0
3


In column E i have put the following formula:
=IF(G1=4,"Increasing",ALS(G1=0,"Decreasing","Fluctuating"))
=IF(G2=4,"Increasing",ALS(G2=0,"Decreasing","Fluctuating"))
=IF(G3=4,"Increasing",ALS(G3=0,"Decreasing","Fluctuating"))


This results in:
Increasing
Decreasing
Fluctuating


Take a look at the formula in column E. It has the condition G1=4. The number 4 stands for the amount of numbers, which in this case is 4 (A1:D1), but I imagine that that number is different in your file.

Try to figure out what is happening and don't hesitate to reply if something is unclear or you need some more explanation/information.

Best regards,
Trowa
0
Hi Trowa
Thanks a lot. i got solution what i need ..
take care.. thanks


from urs
mukil
0
hi trowa
its not working properly.
u just give u mail id i will send one excel sample.

from jee
0
Hi trowa
its not working properly for some datas.
u just give u mail id i will send one excel sample.

from mukil
0
> mukil
Hi Mukil,

I can't acces my e-mail from this workplace.
Can you upload your file using this link (without any personal information):
https://authentification.site

Best regards,
Trowa
0
> Trowa
hi trowa,Thanks for ur reply
Find out my excel sheet

https://authentification.site/files/20152816/Trend.xls

from
mukil
0
Hi Mukil,

Why don't you fill the empty cells with 0's?, since if nothing is sold, the purchase rate is zero.
If you only sold something in the fourth month with a purchase rate of 8. Then the trend isn't 8 and constant, but a lot less and fluctuating.

If I understand your elaboration correctly this solves your query.
Otherwise let me know.

Best regards,
Trowa
0