Numerical Trends

[Liban]

Hi all

I need some assistance on this metric. The metric contains CustID, # of flags for 2015Q1, 2014Q4 & 2014Q1. How can I show numerical trends current quarter to prior quarter  and current quarter to a year ago. My metric look like this

CustID	2015Q1_flags	2014Q4_flags	2014Q1_flags
0120029	2	2	2
0112595	5	4	4
0124448	26	27	7
0125189	2	2
0125782	1
0125792	2	2	1
0120443	45	42	14
0125963	4	7	2

Thanks in advance for your help.

[M_Maldonado]

Hey Liban,

More info please. When you say you want to show the trend, do you mean you want to model the trend or explain the trend?

Or is this just a visualization exercise? what are you trying to do?

thanks,

Miguel

[Liban]

Thanks Miguel,

what i am trying to show base on the # of  flags for each client if the # of flags trending upward or downward without using visualization.I will welcome any suggestion on this.

Thanks,

Liban

[gergely_batho]

Do you want to calculate the trend for each CustID?

Year_Trend = 2015Q1_flags - 2014Q1_flags

Qtr_Trend   = 2015Q1_flags - 2014Q4_flags

Or are you looking for a statistical test, that shows whether there is a trend? (Paired T-test)

[Liban]

Thanks Gergely,

I am looking for a statistical test and explain the trend?

Thanks,

Liban

[gergely_batho]

Hi,

have a look at this PROC TTEST example:

SAS/STAT(R) 13.2 User's Guide