Previous Topic Next Topic

Need find a tren

Closed
Mukil - Dec 14, 2009 at 12:56 AM
 Trowa - Jan 11, 2010 at 08:54 AM
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 responses

Answer 1 / 3
Trowa
Dec 14, 2009 at 09:03 AM
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
Mukil
Dec 18, 2009 at 12:10 AM
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
Answer 2 / 3
Trowa
Dec 21, 2009 at 09:13 AM
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
Mukil
Dec 28, 2009 at 12:32 AM
Hi Trowa
Thanks a lot. i got solution what i need ..
take care.. thanks


from urs
mukil
0
jee
Jan 1, 2010 at 06:13 AM
hi trowa
its not working properly.
u just give u mail id i will send one excel sample.

from jee
0
mukil
Jan 3, 2010 at 11:25 PM
Hi trowa
its not working properly for some datas.
u just give u mail id i will send one excel sample.

from mukil
0
Trowa > mukil
Jan 4, 2010 at 08:40 AM
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
Mukil > Trowa
Jan 5, 2010 at 01:27 AM
hi trowa,Thanks for ur reply
Find out my excel sheet

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

from
mukil
0
Answer 3 / 3
Trowa
Jan 11, 2010 at 08:54 AM
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