Trend Analysis

[garfield]

I am looking for a trend formula to determine if my data has a trend.

It is time series data of 300 institutions combined into 11 groups spanning 11 years. The trend analysis must be done on the indivudual institutions and each group. The data is in a pivot table by group.

I have tries th etrend function but cannot get it to work. Even the example from Excel itself I am doing wrong.

Thx fro the help, Garfield

 

[PaddyD]

hi - welcome to the board!

what trend - that the institutions form 3 clusters with respect to the first letter of their names? that insitutions in a group have a name length that's proportional to the size of the group?

seriously, you'll needd to provide a little more data than that to get any meaningful advice. review the 'posting tips' thread at the top of the baord (and copied below) for info on how to post in a way that maximises the chances of getting decent replies:

http://www.mrexcel.com/board2/viewtopic.php?t=49751

 

[tusharm]

If you are looking for some time series regressions, you might want to consider a program better suited to the job than XL. It's been an awfully long time since I did any time series work, but you should check with your colleagues / professors / managers as to what software they'd recommend.

I am looking for a trend formula to determine if my data has a trend.

It is time series data of 300 institutions combined into 11 groups spanning 11 years. The trend analysis must be done on the indivudual institutions and each group. The data is in a pivot table by group.

I have tries th etrend function but cannot get it to work. Even the example from Excel itself I am doing wrong.

Thx fro the help, Garfield

 

[garfield]

Gentlemen,

PLease excuse my ignorance of proper protocol regarding questions. I will put together a better statement of my problem and the relevant system info and restate my problem better. I am, unfortunately, working in an unknown subject matter area and my knowledge base in spreadsheet analysis is minimal.